多选题Which two statements complete a transaction?（）ADELETE employees;BDESCRIBE employees;CROLLBACK TO SAVE POINT C;DGRANT SELECT ON employees TO SCOTHEALTER TABLE employees SET UNUSED COLUMN sal;FSelect MAX(sal) FROM employees WHERE department _ id 20;
多选题
Which two statements complete a transaction?（）
A
DELETE employees;
B
DESCRIBE employees;
C
ROLLBACK TO SAVE POINT C;
D
GRANT SELECT ON employees TO SCOTH
E
ALTER TABLE employees SET UNUSED COLUMN sal;
F
Select MAX(sal) FROM employees WHERE department _ id 20;
参考解析
解析：
暂无解析
相关考题：
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?() A. point-in-time recoveryB. execute the ROLLBACK command with transaction numberC. flashback the database to before the transaction was committedD. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
View the following SQL statements:You want to back out transaction T2. Which option would you use?() A. It is possible, but transaction T3 also backs out.B. It is possible with the NOCASCADE_FORCE option.C. It is possible with the NONCONFLICT_ONLY option.D. It is not possible because it has conflicts with transaction T3.
Which two statements complete a transaction? () A. DELETE employees;B. DESCRIBE employees;C. ROLLBACK TO SAVE POINT C;D. GRANT SELECT ON employees TO SCOTHE. ALTER TABLE employees SET UNUSED COLUMN sal;F. Select MAX(sal) FROM employees WHERE department _ id 20;
Which two statements are true about a Work Item with "Open" Notification? ()(Choose two.) A. The Work Item is not eligible for Purge.B. The Work Item is eligible for a Permanent purge.C. The Work Item is eligible for a Temporary purge.D. The Work Item is not complete because it still has Open Notification.E. The Work Item is eligible for both Temporary and Permanent purge.
Which two statements are true about L2TP tunnels?（） (Choose two.)A、Traffic is clear textB、Traffic is encryptedC、They are initiated by the LNSD、They are initiated by the LAC
Which two statements complete a transaction?（）A、DELETE employees;B、DESCRIBE employees;C、ROLLBACK TO SAVE POINT C;D、GRANT SELECT ON employees TO SCOTHE、ALTER TABLE employees SET UNUSED COLUMN sal;F、Select MAX(sal) FROM employees WHERE department _ id 20;
Which two statements complete a transaction? （）A、DELETE employees;B、DESCRIBE employees;C、ROLLBACK TO SAVEPOINT C;D、GRANT SELECT ON employees TO SCOTT;E、ALTER TABLE employees SET UNUSED COLUMN sal;F、SELECT MAX(sal) FROM employees WHERE department_id = 20;
In which two conditions are resumable statements suspended？（）A、 when a user exceeds the space quotaB、 when a user session is terminatedC、 when a table that is being accessed by the current transaction is not foundD、 when a user manually suspends the statementE、 when the maximum extents of a segment is reached
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）A、point-in-time recoveryB、execute the ROLLBACK command with transaction numberC、flashback the database to before the transaction was committedD、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
Which two statements are true regarding transactions in an Oracle database（）A、Multiple transactions can use the same undo segment.B、A transaction is assigned an undo segment when it is started.C、More than one transaction cannot share the same extent in the undo tablespace.D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
Which two statements about the background process of the database writer are true（）A、It is possible to have multiple database writers in an Oracle instance.B、It writes dirty buffers， if any， to data files whenever a checkpoint occurs.C、It writes dirty buffers， if any， to data files whenever a transaction commits.D、It writes dirty buffers， if any， to data files before the log writer （LGWR） writes
Which two statements about the background process of thedatabase writerare true（） A、It is possible to have multiple database writers in an Oracle instance.B、It writes dirty buffers， if any， to data files whenever a checkpoint occurs.C、It writes dirty buffers， if any， to data files whenever a transaction commits.D、It writes dirty buffers， if any， to data files before the log writer （LGWR） writes.
Which two statements about Flashback Query are true？（）A、It is generated by using the redo log files. B、It helps in row-level recovery from user errors.C、It can be performed to recover ALTER TABLE statements D、It fails when undo data pertaining to the transaction is overwritten.E、The database has to be opened with the resetlogs option after performing Flashback Query.
多选题Which two statements are true regarding transactions in an Oracle database（）AMultiple transactions can use the same undo segment.BA transaction is assigned an undo segment when it is started.CMore than one transaction cannot share the same extent in the undo tablespace.DThe transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
多选题Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct?（）AYou can find information about only active transactions from the viewBYou can find information about read only transactions from the viewCYou require the SELECT ANY TRANSACTION system privilege to access the viewDYou can find information about both active and committed transactions from the viewEYou require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view
多选题Which two statements complete a transaction?（）ADELETE employees;BDESCRIBE employees;CROLLBACK TO SAVEPOINT C;DGRANT SELECT ON employees TO SCOTT;EALTER TABLE employees SET UNUSED COLUMN sal;FSelect MAX(sal) FROM employees WHERE department_id = 20;
单选题You work as a database administrator at Certkiller .com. You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEEStable. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）A perform point-in-time recoveryB perform a Flashback Table operation to restore the table to the state it was in two days agoC perform a Flashback Database operation to restore the database to the state it was in two days agoD perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
多选题Which two statements about the background process of the database writer are true（）AIt is possible to have multiple database writers in an Oracle instance.BIt writes dirty buffers， if any， to data files whenever a checkpoint occurs.CIt writes dirty buffers， if any， to data files whenever a transaction commits.DIt writes dirty buffers， if any， to data files before the log writer （LGWR） writes
单选题You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）Aperform point-in-time recoveryBperform a Flashback Table operation to restore the table to the state it was in two days agoCperform a Flashback Database operation to restore the database to the state it was in two days agoDperform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
多选题You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? （）(Choose two.)ABackup compression should be enabledBParallelism for the channel should be set to 2CAll the files must be backed up as backup setsDThe backup may be stored either on disk or on media with media manager
单选题Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions？（）A point-in-time recoveryB execute the ROLLBACK command with transaction numberC flashback the database to before the transaction was committedD determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
多选题In which two conditions are resumable statements suspended？（）Awhen a user exceeds the space quotaBwhen a user session is terminatedCwhen a table that is being accessed by the current transaction is not foundDwhen a user manually suspends the statementEwhen the maximum extents of a segment is reached
单选题A customer needs to install a database on a server. Which of the following statements describes how to modify the RAID configuration for optimal performance？（）APlace both the database and transaction log on two logical drives in one RAID-10 arrayBPlace both the database and transaction log on two logical drives in one RAID-1E arrayCPlace the database on a RAID-1E array and place the transaction log on a separate RAID-5 arrayDPlace the database on a RAID-5 array and place the transaction log on a separate RAID-1E array
多选题Which two statements complete a transaction? （）ADELETE employees;BDESCRIBE employees;CROLLBACK TO SAVE POINT C;DGRANT SELECT ON employees TO SCOTHEALTER TABLE employees SET UNUSED COLUMN sal;FSelect MAX(sal) FROM employees WHERE department _ id 20;
多选题The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable： ERROR at line 1： ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened byuser JIM has a transaction that caused the deadlock. Which two statements are true regarding the session ofSCOTT in this scenario（）AThe session is terminated after receiving the error and JIM can continue with his transaction.BSCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.CThe session is rolled back after receiving the error and JIM can continue with his transaction.DSCOTT has to reexecute the last command in the transaction after he commits the transaction.
多选题Which two statements are true about a Work Item with "Open" Notification? （）(Choose two.)AThe Work Item is not eligible for Purge.BThe Work Item is eligible for a Permanent purge.CThe Work Item is eligible for a Temporary purge.DThe Work Item is not complete because it still has Open Notification.EThe Work Item is eligible for both Temporary and Permanent purge.
多选题You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）AEvent Viewer gives more details on the failure.BThe alert log file gives detailed information about the failure.CPMON rolls back the transaction and releases the locks.DSMON rolls back the transaction and releases the locks.EThe transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.FData modified by the transaction up to the last commit before the abnormal termination is retained in the database.