Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 191:

  The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects. Which statement is true in this scenario?

  A. The statistics collection continues until all objects are processed.
  B. The job is terminated and the statistics collected are restored to a time before the job started.
  C. This produces an error and the statistics collected are locked until the next time that the maintenance window is opened.
  D. The job is terminated and the statistics for the remaining objects are collected the next time that the maintenance window is opened.
  D. The job is terminated and the statistics for the remaining objects are collected the next time that the maintenance window is opened.

• Question 192:

  Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)

  A. Shared SQL Area will be allocated in the shared pool
  B. Shared SQL Area will be allocated when a session starts
  C. Shared SQL Area will be allocated in the large pool always
  D. The whole of Private SQL Area will be allocated in the Program Global Area (PGA) always
  E. Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool
  F. The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter
  A. Shared SQL Area will be allocated in the shared pool
  F. The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter

• Question 193:

  You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time. How would you achieve this?

  A. Lock statistics for the tables.
  B. Change STALE_PERCENT to zero for the tables.
  C. Set the TIMED_STATISTICS parameter to TRUE.
  D. Set the STATISTICS_LEVEL parameter to BASIC.
  E. Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.
  A. Lock statistics for the tables.

• Question 194:

  Some non-DBA users in your database have been granted ANY TABLE system privileges and they are able to access data dictionary base tables. You decide to restrict their access to data dictionary objects. Which method would you adopt to achieve this objective?

  A. Revoke the RESOURCE role from the users.
  B. Set the value of the OS_ROLES parameter to TRUE.
  C. Use Database Resource Manager to restrict user access to objects.
  D. Grant ANY TABLE system privileges again without ADMIN OPTION.
  E. Set the value of the O7_DICTIONARY_ACCESSIBILITY parameter to FALSE.
  E. Set the value of the O7_DICTIONARY_ACCESSIBILITY parameter to FALSE.

• Question 195:

  You executed the following command to perform a backup of the USERS tablespace:

  SQL> ALTER TABLESPACE users BEGIN BACKUP;

  ALTER TABLESPACE users BEGIN BACKUP

  *

  ERROR at line 1:

  ORA-01123: cannot start online backup; media recovery not enabled

  What could be the reason for this error?

  A. The MTTR Advisor is disabled.
  B. The database is in NOARCHIVELOG mode.
  C. The tablespace is already in backup mode.
  D. The Flash Recovery Area is not configured.
  B. The database is in NOARCHIVELOG mode.

• Question 196:

  View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:

  ORA-01555: snapshot too old

  What could be the reason for this error? Exhibit:

  

  A. The query is unable to get a read-consistent image.
  B. There is not enough space in Flash Recovery Area.
  C. There is not enough free space in the flashback archive.
  D. The query is unable to place data blocks in undo tablespace.
  A. The query is unable to get a read-consistent image.

• Question 197:

  Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)

  A. Recover from failures in the RAC environment.
  B. Diagnose and repair a data file corruption online.
  C. Diagnose and repair a data file corruption offline.
  D. Diagnose and repair failures on a standby database.
  A. Recover from failures in the RAC environment.
  D. Diagnose and repair failures on a standby database.

• Question 198:

  Note the following points describing various utilities in Oracle Database 11g: Which point describes the Oracle Data Pump utility?

  1.

  It enables the transfer of data from one database to another

  2.

  It provides a complete solution for the backup, restoration and recovery needs of the entire database

  3.

  It enables the loading of data from an external file into tables of an Oracle Database

  4.

  It provides a tape backup management for the Oracle ecosystem

  A. 1
  B. 2
  C. 3
  D. 4
  E. 1 and 3
  F. 1, 2, 3 and 4
  A. 1

• Question 199:

  Note the following structures in your database server:

  1.

  Extents

  2.

  OS Blocks

  3.

  Tablespace

  4.

  Segments

  5.

  Oracle Data Block

  Which option has the correct arrangement of these structures from the smallest to the largest?

  A. 2, 5, 1, 4, 3
  B. 1, 2, 3, 4, 5
  C. 5, 2, 1, 3, 4
  D. 2, 1, 5, 4, 3
  A. 2, 5, 1, 4, 3

• Question 200:

  You execute the following command to change the status of the SALES tablespace:

  SQL> ALTER TABLESPACE sales OFFLINE;

  Which statements describe the effect of the command? (Choose all that apply.)

  A. The tablespace would require recovery to go back online.
  B. A checkpoint is taken on all data files that are associated with the SALES tablespace.
  C. The sessions that subsequently try to access the objects in the SALES tablespace receivean error.
  D. The new status of the SALES tablespace is recorded in the control file when the database instance is closed.
  B. A checkpoint is taken on all data files that are associated with the SALES tablespace.
  C. The sessions that subsequently try to access the objects in the SALES tablespace receivean error.