Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 251:

  Which three are true about the Automatic Workload Repository (AWR)? (Choose three.)

  A. It is maintained by executing the PL/SQL procedures in the DBMS_STATS package.

  B. It includes statistics that contain the number of distinct values per table column.

  C. It includes statistics that contain the number of rows per table.

  D. AWR data is stored in the SYSAUX tablespace.

  E. Automatic AWR snapshots are created by the Manageability Monitor (MMON) background process.

  F. By default, AWR data is retained for eight days.

  Correct Answer: DEF

• Question 252:

  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.

  Correct Answer: DE

• Question 253:

  Which two affect the time taken for instance recovery? (Choose two.)

  A. size of archivelogs

  B. size of existing RMAN backupsets

  C. UNDO_RETENTION value

  D. size of UNDO tablespace

  E. FAST_START_MTTR_TARGET value

  F. size of redo logs

  Correct Answer: EF

• Question 254:

  You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI). You select the "Install and Configure Grid Infrastructure for a Standalone Server' option. Which task is performed by OUI as part of this installation?

  A. creation of privileged operating system group that are used for OS authentication.

  B. creation of an ASM disk group and registration of ASM components with Oracle Restart

  C. creation of a general purpose database

  D. creation and configuration of Enterprise Managed Cloud Control on the server

  Correct Answer: B

• Question 255:

  You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the

  profile.

  Some user sessions are currently connected to the database instance and are using the APP_USER

  profile.

  This command is used to drop the profile:

  SQL> DROP PROFILE app_user;

  Which statement describes the result?

  A. The command produces an error.

  B. The profile is dropped and current user sessions use the DEFAULT profile immediately.

  C. The profile is dropped, the sessions are terminated, and the subsequent user sessions use the DEFAULT profile.

  Correct Answer: A

• Question 256:

  In a database, EXAMPLE is the default tablespace and DEFERRED_SEGMENT_CREATION is FALSE. Examine these commands executed by SYS:

  

  What will be the outcome and why?

  A. U1.TAB1 will be created

  B. It will fail because U1 has no quota on EXAMPLE

  C. It will fail because U1 has no default tablespace

  D. It will fail because U1 does not have the CREATE TABLE privilege

  E. It will fail because U1 does not have the CREATE SESSION privilege

  Correct Answer: D

• Question 257:

  Which two are true about server-generated alerts? (Choose two.)

  A. Stateful alerts are preserved across instance restarts.

  B. They are automatically written to alert.log.

  C. By default, an email is sent by the database instance for each server-generated alert.

  D. Stateless alerts can be found in DBA_OUTSTANDING_ALERTS.

  E. By default, a server-generated alert is raised for each tablespace that has 85 % or more of its space used.

  Correct Answer: BE

• Question 258:

  Which two statements are true about tablespaces? (Choose two.)

  A. A database instance stores undo data in the SYSTEM tablespace if no undo tablespace exists

  B. A database instance hangs if the SYSAUX tablespace becomes unavailable

  C. A database with a locally managed SYSTEM tablespace can have dictionary-managed user tablespaces

  D. A database can contain multiple undo tablespaces

  E. A database can contain only a single temporary tablespace

  Correct Answer: AD

• Question 259:

  Which statement is true regarding undo tablespace?

  A. Undo tablespace is a temporary tablespace.

  B. Only one undo tablespace can exist in a database.

  C. Undo tablespace can consist of only one data file that is reused in a cyclic fashion.

  D. Multiple undo tablespace can exist in a database but only one can be active at a time.

  Correct Answer: D

• Question 260:

  Table EMP resides in the USERS tablespace.

  Examine this command:

  SQL> DROP TABLE emp PURGE;

  Which two methods would you use to recover EMP? (Choose two.)

  A. Flashback Transaction Backout

  B. re-creating the table and reinserting the rows

  C. Flashback Drop

  D. Flashback Table

  E. performing a tablespace point in time recovery of USERS

  Correct Answer: BE