Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 141:

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

  A. AWR data is stored in the SYSTEM tablespace
  B. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter
  C. It is the foundation for the self-managing infrastructure
  D. The taking of AWR snapshots cannot be disabled
  E. By default, AWR snapshots are taken every 60 minutes
  B. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter
  C. It is the foundation for the self-managing infrastructure
  E. By default, AWR snapshots are taken every 60 minutes

• Question 142:

  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
  A. A database instance stores undo data in the SYSTEM tablespace if no undo tablespace exists
  D. A database can contain multiple undo tablespaces

• Question 143:

  You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:

  Warning (%): 90

  Critical (%): 95

  Which background process is responsible for issuing alerts when the threshold is crossed?

  A. System monitor (SMON)
  B. Process monitor (PMON)
  C. Memory manager process (MMAN)
  D. Manageability Monitor process (MMON)
  D. Manageability Monitor process (MMON)

• Question 144:

  You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The table in which you plan to load data in an important table having various integrity constraint defined on it.

  Which constraints will remain enabled by default during this operation? (Choose all that apply.)

  A. CHECK
  B. UNIQUE
  C. NOT NULL
  D. PRIMARY KEY
  E. FOREIGN KEY
  B. UNIQUE
  C. NOT NULL
  D. PRIMARY KEY

• Question 145:

  For which database operation would you need the database to be in the MOUNT state?

  A. Renaming the control files
  B. Re-creating the control files
  C. Dropping a user in your database
  D. Dropping a tablespace in your database
  E. Configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
  E. Configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

• Question 146:

  After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database:

  SQL> ALTER DATABASE OPEN;

  Which two statements are true? (Choose two.)

  A. The online redo log files and online data files are opened
  B. All the online data files headers are checked for consistency
  C. Instance recovery is performed before opening the database
  D. The path and existence of all the log file members are checked
  A. The online redo log files and online data files are opened
  B. All the online data files headers are checked for consistency

• Question 147:

  Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

  A. Failure when no standby database is configured
  B. Failure because a data file is renamed accidentally
  C. Failure that requires no archive logs to be applied for recovery
  D. Failure due to loss of connectivity-for example, an unplugged disk cable
  B. Failure because a data file is renamed accidentally
  D. Failure due to loss of connectivity-for example, an unplugged disk cable

• Question 148:

  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
  B. creation of an ASM disk group and registration of ASM components with Oracle Restart

• Question 149:

  In your database:

  SGA_TARGET = 270M

  PGA_AGGREGATE_TARGET = 90M

  The MEMORY_TARGET and MEMORY_MAX_TARGET parameters are currently not configured.

  You execute the command:

  ALTER SYSTEM SET MEMORY_TARGET = 400M;

  What is the outcome and why?

  A. The execution fails because SGA_TARGET and PGA_AGGREGATE_TARGET are already configured
  B. The execution is successful and automatic memory management is enabled
  C. The execution is successful but does not enable automatic memory management because the MEMORY_MAX_TARGET parameter must be configured to a value greater than MEMORY_TARGET
  D. The execution fails because the MEMORY_MAX_TARGET parameter must be configured to 400M before configuring the MEMORY_TARGET parameter
  B. The execution is successful and automatic memory management is enabled

• Question 150:

  Examine the commands executed in the following sequence:

  

  Which statement is true about the above commands?

  A. The commands execute successfully.
  B. Command 6 produces an error because of circular role grant.
  C. Command 5 produces an error because a role cannot be granted to another role.
  D. Command 3 produces an error because the MGRROLE role already contains system privileges. The table created by HR remains and HR still has the CREATE TABLE system privilege.
  E. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
  B. Command 6 produces an error because of circular role grant.