Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 261:

  Which two operations can be performed on an external table? (Choose two.)

  A. Create a view on the table
  B. Create an index on the table
  C. Create a synonym on the table
  D. Add a virtual column to the table
  E. Update the table using the UPDATE statement
  F. Delete rows in the table using the DELETE command
  A. Create a view on the table
  C. Create a synonym on the table

• Question 262:

  See the Exhibit:

  

  Identify the component marked with a question mark:

  A. Checkpoint (CKPT)
  B. Process Monitor (PMON)
  C. Archiver Processes (ARcn)
  D. Recoverer Process (RECO)
  E. Memory Manager Process (MMAN)
  A. Checkpoint (CKPT)

• Question 263:

  Examine these commands and their output:

  

  A power failure occurs. The instance is restarted and this query is executed.

  SQL> SELECT ename FROM emp;

  What is the outcome?

  A. No rows are returned
  B. Only Adam and Alan are displayed
  C. Adam, Alan, Ben, and Bryan are displayed
  D. Only Adam, Alan, and Bryan are displayed
  E. Only Adam, Alan, and Ben are displayed
  B. Only Adam and Alan are displayed

• Question 264:

  See the Exhibit to observe the roles assigned to the SL_REP user.

  

  Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SL_REP user?

  A. The user must enable the role explicitly
  B. The user can grant the role to other users
  C. The user cannot user the role until the DBA enables it explicitly
  D. The user can start using the role immediately without any changes
  A. The user must enable the role explicitly

• Question 265:

  In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.)

  A. if a table is not in a cluster
  B. if a table has an active trigger
  C. if a table has an encrypted column
  D. if a table has a column of data type LONG defined on it
  E. if a table has a referential integrity constraint defined on it
  B. if a table has an active trigger
  C. if a table has an encrypted column
  E. if a table has a referential integrity constraint defined on it

• Question 266:

  Which two are true about the Archive (ARCn) processes? (Choose two.)

  A. They are enabled only when the database is in ARCHIVELOG mode
  B. They create archivelogs after every log switch
  C. They are used during instance recovery
  D. They automatically delete obsolete archive logs to make space for new archive logs
  E. They archive redo directly from the redo log buffer
  A. They are enabled only when the database is in ARCHIVELOG mode
  D. They automatically delete obsolete archive logs to make space for new archive logs

• Question 267:

  You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The Flash Recovery Area is specified as the destination for the archived redo log files. You notice this warning in the alert log file:

  ORA19815: WARNING: db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0 remaining bytes available.

  What would you do to reclaim the used space in the Flash Recovery Area? (Choose two.)

  A. Back up the Flash Recovery Area.
  B. Decrease the retention time for the database backup and flashback log files.
  C. Manually delete all the archived log files from the Flash Recovery Area by using operating system (OS) commands.
  D. Manually delete all the expired backup sets from the Flash Recovery Area by using operating system (OS) commands.
  A. Back up the Flash Recovery Area.
  B. Decrease the retention time for the database backup and flashback log files.

• Question 268:

  You are working on a database that must be functioning 24 hours a day, 7 days a week. The database is configured in ARCHIVELOG mode.

  Which two options do you have for performing user-managed backups? (Choose two.)

  A. You can perform consistent backups only.
  B. You can perform a complete database backup without shutting down the database instance.
  C. You can back up data files only when all data files have the same SCN recorded in the control file.
  D. You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGIN BACKUP or ALTER DATABASE BEGIN BACKUP commands.
  B. You can perform a complete database backup without shutting down the database instance.
  D. You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGIN BACKUP or ALTER DATABASE BEGIN BACKUP commands.

• Question 269:

  You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days of statistics collection. The optimizer statistics retention period is set to its default value.

  Which action would help to use the previous set of statistics on the objects?

  A. Restore statistics from statistics history.
  B. Reduce the optimizer statistics retention period by 2 days.
  C. Set the OPTIMIZER_PENDING_STATISTICS parameter to TRUE.
  D. Reduce the Automatic Workload Repository (AWR) retention period by 2 days.
  A. Restore statistics from statistics history.

• Question 270:

  Which statement is true about the Manageability Monitor (MMON) background process?

  A. It transfers statistics from memory to disk at regular intervals.
  B. It coordinates the rebalance activity for disk groups when ASM is used.
  C. It communicates with the Automatic Storage Management (ASM) instance on behalf of the database instance.
  D. It performs dynamic memory management when Automatic Shared Memory Management is enabled for the database instance.
  A. It transfers statistics from memory to disk at regular intervals.