多项选择题

A.Disable automatic checkpoint tuning.B.Check the size ……

You notice that the performance of the database has degraded because of frequent checkpoints.
Which twoactions resolve the issue（）

A.Disable automatic checkpoint tuning.
B.Check the size of the redo log file size and increase the size if it is small.
C.Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
D.Decrease the number of redo log members if there are more than one redo log members available in eachredo log group.

<上一题目录下一题>

热门试题

多项选择题Examinethecommand： SQL>ALTERUSERskdACCOUNTLOCK； Whichtwostatementsaretrueafterthecommandisexecuted（）

A.The SKD user cannot log in to the database instance.
B.The objects owned by the SKD user are not accessible to any user.
C.The other users can access the objects owned by the SKD user， on which they have access.
D.The password for the SKD user expires and the user is forced to change the password at the next log in

单项选择题You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase. Which option of IMPDP would you use to accomplish this task（）

A.FULL
B.SCHEMAS
C.TRANSFORM
D.REMAP_SCHEMA
E.REMAP_TABLESPACE

单项选择题View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is trueabout the output of the command（）

A.The backup piece is expired as the new backup is available.
B.The backup piece is expired because the operating-system file was not found.
C.The backup piece is expired because the retention period for the backup has expired.
D.The backup piece is expired because the backup set to which it belongs is not complete

单项选择题View the Exhibit to examine the error that occurred during the database startup. You opened an RMAN sessionfor the database. To repair the failure， you executed the following command as the first RMAN command：RMAN>REPAIR FAILURE； Which statement describes the consequence of this command（）

A.The command performs the recovery and closes the failure.
B.The command only displays the advice and the RMAN script required for recovery.
C.The command executes the RMAN script to repair the failure and remove the entry from the AutomaticDiagnostic Repository （ADR）.
D.The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command

多项选择题Examine the following output： SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）

A.It is ignored by the query optimizer.
B.It is not used while the index is being rebuilt.
C.The index cannot be rebuilt， and has to be re-created.
D.The index is automatically rebuilt when used the next time