Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 171:

  Which two are true about FAST_START_MTTR_TARGET? (Choose two.)

  A. It is overridden by LOG_CHECKPOINT_INTERVAL
  B. If it is set to 0, the MTTR Advisor is disabled
  C. A higher value increases the I/O overhead
  D. It is applicable only when the database is in ARCHIVELOG mode
  E. A lower value increases the time taken to perform instance recovery
  A. It is overridden by LOG_CHECKPOINT_INTERVAL
  C. A higher value increases the I/O overhead

• Question 172:

  Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

  A. The database files are corrupted when the database is open
  B. The user has dropped an important table that needs to be recovered
  C. The archived redo log files are missing for which the backup is not available
  D. The database is not opening because the required database files are missing
  A. The database files are corrupted when the database is open
  D. The database is not opening because the required database files are missing

• Question 173:

  User A executes the following command to drop a large table in your database:

  SQL> DROP TABLE trans;

  While the drop table operation is in progress; user B executes the following command on the same table;

  SQL> DELETE FROM trans WHERE tr_type='SL';

  Which statement is true regarding the DELETE command?

  A. It fails to delete the records because the records are locked in the SHARE mode
  B. It deletes the rows successfully because the table is locked in the SHARE mod
  C. It fails to delete the records because the table is locked in EXCLUSIVE mode
  D. It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode
  C. It fails to delete the records because the table is locked in EXCLUSIVE mode

• Question 174:

  Examine the following statement that is used to modify the primary key constraint on the SALES table:

  SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;

  Which three statements are true regarding the above command? (Choose three.)

  A. The constraint remains valid.
  B. The index on the constraint is dropped.
  C. It allows the loading of data into the table using SQL *Loader.
  D. New data conforms to the constraint, but existing data is not checked.
  E. It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
  A. The constraint remains valid.
  B. The index on the constraint is dropped.
  C. It allows the loading of data into the table using SQL *Loader.

• Question 175:

  View the Exhibit and examine the privileges granted to the MGR_ROLE role.

  The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator (DBA) grants MGR_ROLE to the user SKD by executing the command:

  SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION;

  Which statement is true about the user SKD after he/she is granted this role? Exhibit:

  

  A. The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it
  B. The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor
  C. The user SKD can grant the privileges in the MGR_ROLE role to other users but not with ADMIN OPTION
  D. The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke privileges from them
  A. The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it

• Question 176:

  Which is true about enabling AUTOEXTEND for data files?

  A. It can be enabled for a new data file that is added to a tablespace only if the existing data files in that tablespace have autoextend enabled.
  B. It can be enabled only for data files in non-OMF tablespaces.
  C. It can be enabled only for data files only in smallfile tablespaces.
  D. It can be enabled only for data files only in biglfile tablespaces.
  E. It can be enabled for an existing data file in a tablespace by using the ALTER TABLESPACE command.
  E. It can be enabled for an existing data file in a tablespace by using the ALTER TABLESPACE command.

• Question 177:

  You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file. View the Exhibit and check the commands executed.

  

  What is the location of the alert_orcl.log file?

  A. ORACLE_HOME/dbs
  B. ORACEL_HOME/rdbms
  C. /u01/app/oracle/admin/orcl/adump
  D. /u01/app/oracle/flash_recovery_area
  E. ORACLE_BASE/diag/rdbms/orcl/alert
  F. ORACLE_BASE/diag/rdbms/orcl/orcl/trace
  F. ORACLE_BASE/diag/rdbms/orcl/orcl/trace

• Question 178:

  Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?

  A. It is the time period after which the undo data becomes obsolete.
  B. It is the time period after which the committed undo data would be transferred to a temporary tablespace.
  C. It is the minimum time period up to which the committed undo data would be retained if free undo space is available.
  D. It is the time period after which the undo data is transferred to the Flash Recovery Area to provide read consistency.
  C. It is the minimum time period up to which the committed undo data would be retained if free undo space is available.

• Question 179:

  In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?

  A. When the data file of the undo tablespace is autoextensible
  B. When there are more than one undo tablespace available in the database
  C. When the undo tablespace is of a fixed size and retention guarantee is not enabled
  D. When the undo tablespace is autoextensible and retention guarantee is not enabled
  C. When the undo tablespace is of a fixed size and retention guarantee is not enabled

• Question 180:

  Which two are true about consistent database backups? (Choose two.)

  A. They can only be taken if the database is in ARCHIVELOG mode.
  B. They can only be taken by using RMAN command.
  C. They can only be taken when a RECOVERY CATALOG is used.
  D. They can only be taken by using RMAIN when the database is in MOUNT state.
  E. They can only be taken if a NORMAL, TRANSACTIONAL, OR IMMEDIATE shutdown has been performed and the backup is taken before the database is reopened.
  D. They can only be taken by using RMAIN when the database is in MOUNT state.
  E. They can only be taken if a NORMAL, TRANSACTIONAL, OR IMMEDIATE shutdown has been performed and the backup is taken before the database is reopened.