Online Access Free 1Z0-053 Practice Test

View the Exhibit to examine the output for the V$DIAG_INFO view. Which statements are true regarding the location of diagnostic traces? (Choose all that apply.)
Exhibit:

• A.The location of the trace file for the current session is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.
• B.The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/ rdbms/orclbi/orclbi/trace.
• C.The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
• D.The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.

You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE
\INITORCL.ORA'
Using RMAN, how would you respond to this error?

• A.Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.
• B.Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.
• C.Issue the restore spfile from autobackup command from the RMAN prompt.
• D.Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.
• E.Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.

You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.
Which statement about the result is true?

• A.The database instance starts, but Automatic Memory Management is disabled.
• B.The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter.
• C.The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE.
• D.The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA.

View the Exhibit.
As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals.
Which background process performs this activity?

• A.CKPT
• B.SMON
• C.DBWR
• D.MMON

Which three functions are performed by the SQL Tuning Advisor? (Choose three.)

• A.Checking query objects for missing and stale statistics
• B.Recommending bitmap, function-based, and B-tree indexes
• C.Recommending optimization of materialized views
• D.Building the SQL profile
• E.Recommending restructuring SQL queries that are using bad plans