Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 131:

  Which of the following represents the correct sequence of events for Database Replay?

  A. Capture, analyze, preprocess, replay
  B. Capture, preprocess, analyze, replay
  C. Capture, preprocess, replay, analyze
  D. Analyze, capture, preprocess, replay
  E. None of the above
  C. Capture, preprocess, replay, analyze

• Question 132:

  Which of the following statements are true about the BACKUP command? (Choose all that apply.)

  A. The BACKUP command can not be used to make image copies of a datafile.
  B. The BACKUP command can improve performance by multiplexing backup files.
  C. The BACKUP can take advantage of the block-change tracking capability.
  D. The BACKUP command cannot store data in incremental backups.
  E. The BACKUP command can store data in cumulative incremental backups only.
  B. The BACKUP command can improve performance by multiplexing backup files.
  C. The BACKUP can take advantage of the block-change tracking capability.

• Question 133:

  Which of these formats represents the correct hierarchy for the ADR?

  A. /rdbms/diag//
  B. /diag/rdbms//
  C. /diag/rdbms//
  D. None of the above
  C. /diag/rdbms//

• Question 134:

  You opened the encryption wallet and then issued the following command:

  SQL>CREATE TABLESPACE securespace

  DATAFILE '/home/user/oradata/secure01.dbf'

  SIZE 150M

  ENCRYPTION USING '3DES168'

  DEFAULT STORAGE(ENCRYPT);

  Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.

  What is the outcome?

  A. It creates the table and encrypts the data in it.
  B. It generates an error because the wallet is closed.
  C. It creates the table but does not encrypt the data in it.
  D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
  B. It generates an error because the wallet is closed.

• Question 135:

  Examine the following command that is used to duplicate a database on the same host:

  RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; }

  Which two statements describe the effect after the database is duplicated successfully? (Choose two)

  A. The data files of the read-only tablespaces in the target database are not duplicated
  B. The read-only tablespaces in the target database are still defined in new the database
  C. The read-only tablespaces in the target database are changed to online after duplication
  D. The data files of the read-only tablespaces in the target database get duplicated
  E. The read-only tablespaces in the target database are not defined in the new database
  A. The data files of the read-only tablespaces in the target database are not duplicated
  B. The read-only tablespaces in the target database are still defined in new the database

• Question 136:

  Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN. (choose all that apply)

  A. Limiting the input/output (I/O) bandwidth consumption
  B. Specifying the size of backup sets and backup pieces
  C. Specifying vendor-specific information for a media manager
  D. Specifying the parallelism for backup and restore operations
  A. Limiting the input/output (I/O) bandwidth consumption
  C. Specifying vendor-specific information for a media manager

• Question 137:

  Which setting enables the baselines by default in Oracle Database 11g?

  A. setting the STATISTICS_LEVEL parameter to TYPICAL
  B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)
  C. enabling Automated Maintenance Task using Oracle Enterprise Manager
  D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
  A. setting the STATISTICS_LEVEL parameter to TYPICAL

• Question 138:

  When starting up your ASM instance, you receive the following error: SQL> startup pfile=$ORACLE_HOME/dbs/init+ASM.ora ASM instance started

  Total System Global Area 104611840 bytes Fixed Size 1298220 bytes Variable Size 78147796 bytes ASM Cache 25165824 bytes

  ORA-15032: not all alternations performed ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DGROUP3" ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DGROUP2" ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DGROUP1"

  In trying to determine the cause of the problem, you issue this query: SQL> show parameter asm

  

  What is the cause of the error?

  A. The ASM_DISKGROUPS parameter is configured for three disk groups: DGROUP1, DGROUP2, and DGROUP3. The underlying disks for these disk groups have apparently been lost.
  B. The format of the ASM_DISKGROUPS parameter is incorrect. It should reference the disk group numbers, not the names of the disk groups
  C. The ASM_POWER_LIMIT parameter is incorrectly set to 1. It should be set to the number of disk groups being attached to the ASM instance.
  D. The ASM_DISKSTRING parameter is not set; therefore disk discovery is not possible.
  E. There is insufficient information to solve this problem.
  D. The ASM_DISKSTRING parameter is not set; therefore disk discovery is not possible.

• Question 139:

  The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? (Choose two)

  A. All the related indexes and views are automatically dropped
  B. The flashback drop feature can recover only the table structure
  C. Only the related indexes are dropped whereas views are invalidated
  D. The flashback drop feature can recover both the table structure and its data
  C. Only the related indexes are dropped whereas views are invalidated
  D. The flashback drop feature can recover both the table structure and its data

• Question 140:

  Which of the following RMAN structures can data from a datafile span?

  A. RMAN backup-set pieces spanning backup sets
  B. RMAN backup-set pieces within a given backup set
  C. RMAN backups
  D. RMAN channels
  E. None of the above
  B. RMAN backup-set pieces within a given backup set