单项选择题
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）
A.The online redo log files and archived redo log files are required to accomplish the recovery.
B.The uncommitted transaction will be committed at the next startup of the database instance.
C.The uncommitted transaction is rolled back automatically at the next opening of the database.
D.The DBA has to perform the recovery on the database to recover the uncommitted transaction
相关考题
-
单项选择题
Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 isperformed（）
A.The table created by SKD is not accessible and SKD cannot create new tables.
B.The tables created by SKD and HR remain， but both cannot create new tables.
C.The table created by HR remains and HR still has the CREATE TABLE system privilege.
D.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users. -
多项选择题
YouaremanaginganOracleDatabase11gdatabasewiththefollowingbackupstrategy：1）OnSunday，anincrementallevel0tapebackupisperformed.2）MondaythroughSaturday，acumulativeincrementallevel1tapebackupisperformed.Whichtwostatementsaretrueregardingthebackupsperformed（）
A.The backup performed in step 1 backs up all blocks that have ever been in use in the database.
B.The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.
C.The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.
D.The backup performed in step 2 backs up all blocks that have changed since the most recent incrementalbackup at level 1 -
单项选择题
View the Exhibit and identify the component marked with a question mark.（）
A.Checkpoint （CKPT）
B.Process Monitor （PMON）
C.Archiver Processes （ARCn）
D.Recoverer Process （RECO）
E.Memory Manager process （MMAN）
