Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 21:

  You have enabled backup optimization for the RMAN environment.

  Identify two criteria on which RMAN will skip the file, if it has already been backed up. (Choose two.)

  A. The data file backup is done with multiple channels
  B. The data files is in the read-write mode after being backed up in the read only mode
  C. The backup was taken after the data files was taken offline-normal or is in the read only mode
  D. The data file backup complies with the back retention policy and the backup duplexing feature
  C. The backup was taken after the data files was taken offline-normal or is in the read only mode
  D. The data file backup complies with the back retention policy and the backup duplexing feature

• Question 22:

  When exporting metadata for the transportable tablespaces, what is the correct next step after confirming endian format?

  A. Export the tablespaces using data pump.
  B. Determine if the transportable set is self-contained.
  C. Convert the datafiles using RMAN.
  D. Copy the datafiles from source to destination.
  B. Determine if the transportable set is self-contained.

• Question 23:

  Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSET parameters?

  A. V$VALID_NLS_VALUES
  B. NLS_VALID_VALUES
  C. NLS_VALUE_OPTIONS
  D. V$NLS_VALUE_OPTIONS
  E. V$NLS_VALID_VALUES
  E. V$NLS_VALID_VALUES

• Question 24:

  View the Exhibit for some of the parameter settings. You start a session and issue the following command:

  SQL>CREATE INDEX emp_ename ON emp(ename)

  TABLESPACE users INVISIBLE;

  What is the outcome of the above command?

  Exhibit:

  

  A. The index is not used by the optimizer but is maintained during DML operations.
  B. The index is not used by the optimizer and is not maintained during DML operations.
  C. The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.
  D. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.
  A. The index is not used by the optimizer but is maintained during DML operations.

• Question 25:

  You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.

  Which two statements are true in this scenario for the features enabled for ASM? (Choose two.)

  A. The ASM-preferred mirror read feature is enabled.
  B. The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.
  C. The ASM disk is dropped immediately from a disk group when it becomes unavailable.
  D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.
  A. The ASM-preferred mirror read feature is enabled.
  B. The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.

• Question 26:

  By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options?

  A. Automatic PGA Memory Management
  B. Automatic SGA Memory Management
  C. Automatic Shared Memory Management
  D. Automatic Memory Management
  E. Manual SGA Memory Management
  F. None of the above
  C. Automatic Shared Memory Management

• Question 27:

  Automatic data conversion will occur if which of the following happens?

  A. The client and server have different NLS_LANGUAGE settings.
  B. The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.
  C. The client and server are in different time zones.
  D. The client requests automatic data conversion.
  E. The AUTO_CONVERT initialization parameter is set to TRUE.
  B. The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.

• Question 28:

  You want to use the automatic management of backup and recovery operations features for your database.

  Which configuration must you set?

  A. Enable the flash recovery area and specify it as the archived redo log destination.
  B. Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
  C. Enable the flash recovery area but do not specify it as the archived redo log destination.
  D. Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
  A. Enable the flash recovery area and specify it as the archived redo log destination.

• Question 29:

  You executed the following commands:

  SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false; SQL> EXECUTE

  DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH','false');

  SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');

  Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

  A. The statistics are stored in the pending statistics table in the data dictionary.
  B. The statistics are treated as the current statistics by the optimizer for all sessions.
  C. The statistics are treated as the current statistics by the optimizer for the current sessions only.
  D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.
  A. The statistics are stored in the pending statistics table in the data dictionary.

• Question 30:

  Which two statements correctly describe the relationship among the Scheduler components: job, program, and schedule? (Choose two)

  A. A job is specified as part of a program definition
  B. A program can be used in the definition of multiple jobs
  C. A program and job can be specified as part of a schedule definition
  D. A program and schedule can be specified as part of a job definition
  B. A program can be used in the definition of multiple jobs
  D. A program and schedule can be specified as part of a job definition