Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 61:

  You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into your current database.

  Which is the most effective method to access this data in your database?

  A. Use the database link.
  B. Use the SQL*Loader utility.
  C. Use the Oracle Data Pump utility.
  D. Create an external table and leave the data in the flat file.
  D. Create an external table and leave the data in the flat file.

• Question 62:

  You set the following parameters in the parameter file and restarted the database: MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted? (Choose two.)

  A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
  B. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
  C. The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
  D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.
  A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
  D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.

• Question 63:

  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.
  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.

• Question 64:

  View the Exhibit.

  

  You are creating an additional database by using the Database Configuration Assistant (DBCA). You opted to create a General Purpose database and during the database creation realize that the Block Size field is not enabled. What could be the reason for this?

  A. You have chosen the File System option as the storage option.
  B. You have chosen the Automatic Storage Management (ASM) as the storage option.
  C. The data block size can be increased only when DBCA is invoked from Oracle Universal Installer (OUI).
  D. You are using General Purpose template and not the Custom Database template to create the database.
  D. You are using General Purpose template and not the Custom Database template to create the database.

• Question 65:

  SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command?

  A. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT
  B. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users
  C. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session
  D. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully
  E. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT
  C. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session

• Question 66:

  Which is true about invalid PL/SQL objects?

  A. They must be manually recompiled before they can be used if a DDL is performed on a table that is referenced in the PL/SQL object.
  B. They are automatically recompiled against the new definition of a referenced object when they are called.
  C. They are automatically recompiled against the new definition of a referenced object at the same time as the modified referenced object.
  D. They can be manually recompiled only by using SQL commands.
  B. They are automatically recompiled against the new definition of a referenced object when they are called.

• Question 67:

  Which two statements are true regarding undo tablespaces? (Choose two.)

  A. The database can have more than one undo tablespace
  B. The UNDO_TABLESPACE parameter is valid in both automatic and manual undo management
  C. Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions
  D. An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up
  A. The database can have more than one undo tablespace
  C. Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions

• Question 68:

  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.
  B. They are automatically written to alert.log.
  E. By default, a server-generated alert is raised for each tablespace that has 85 % or more of its space used.

• Question 69:

  Your database instance is running with full workload after database creation. You have decided to use a fixedsize undo tablespace. You want to use the undo Advisor to estimate the capacity of the undo tablespace.

  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undo tablespace? (Choose two.)

  A. The retention period to support flashback
  B. The expected length of the longest-running query
  C. The number of undo tablespaces in the database
  D. The size of the Flash Recovery Area for the database instance
  A. The retention period to support flashback
  B. The expected length of the longest-running query

• Question 70:

  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