1Z0-053 무료 덤프문제 온라인 액세스

Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.
Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)

• A.Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES.
• B.Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES.
• C.Define the POWER option while adding or removing the disks.
• D.Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.

Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?

• A.DIAGNOSTIC_DEST is always equal to $ORACLE_BASE.
• B.DIAGNOSTIC_DEST is always equal to $ORACLE_HOME.
• C.The default value is the value of the environment variable $ORACLE_BASE; if $ORACLE_BASE isn't set, then it is set to $ORACLE_HOME.
• D.The default value is the value of the environment variable $ORACLE_HOME; if $ORACLE_HOME isn't set, then the default is set to $ORACLE_BASE.

You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.
What configuration would you effect to achieve your objective? (Choose all that apply.)

• A.Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.
• B.Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
• C.Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
• D.Set the ASM compatibility attribute for the ASM disk group to 11.1.0.

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.
You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table:
SQL> SELECT object_name, original_name, droptime FROM recyclebin;

What would be the outcome of the precedent statement?

• A.It returns an error because the table name is not specified as per the names in the OBJECT_NAME column
• B.It retrieves the version of the table for which undo information is available
• C.It retrieves the oldest version of the table from the recycle bin
• D.It retrieves the latest version of the table from the recycle bin

While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 p.m. on September 6, 2008.
Which of the following would be the correct commands to use to restore the database to a point in time before the corruption?

• A.Option E
• B.Option B
• C.Option D
• D.Option A
• E.Option C