Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 471:

  If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string, what happens to disks that are already a part of the same or another disk group?

  A. The command fails unless you specify the FORCE option.
  B. The command fails unless you specify the REUSE option.
  C. The command must be reissued with a more specific discovery string.
  D. The other disks, already part of the disk group, are ignored.
  C. The command must be reissued with a more specific discovery string.

• Question 472:

  The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3.The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this:

  1.SQL> GRANT recovery_catalog_owner TO vpc1; 2.RMAN> CONNECT CATALOG vpc1/password@catdb; 3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN> CONNECT CATALOG catowner/password@catdb; 5.RMAN> CREATE VIRTUAL CATALOG;

  What is the correct sequence in which the commands have to be executed?

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

• Question 473:

  The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements? (Choose all that apply.)

  A. Date format
  B. Decimal character
  C. Group separator
  D. First day of the month
  E. None of the above
  F. All of the above
  A. Date format
  B. Decimal character
  C. Group separator

• Question 474:

  Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?

  A. SQL statements that are part of the AWR baseline only
  B. SQL statements based on the AWR top SQL identification
  C. SQL statements that are part of the available SQL Tuning Set (STS) only
  D. SQL statements that are available in the cursor cache and executed by a user other than SYS
  B. SQL statements based on the AWR top SQL identification

• Question 475:

  You are working as a DBA on the decision support system.

  There is a business requirement to track and store all transactions for at least three years for a few tables in the database.

  Automatic undo management is enabled in the database.

  Which configuration should you use to accomplish this task?

  A. Enable Flashback Data Archive for the tables.
  B. Specify undo retention guarantee for the database.
  C. Enable supplemental logging for the database.
  D. Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.
  E. Create Flashback Data Archive on the tablespace on which the tables are stored.
  A. Enable Flashback Data Archive for the tables.

• Question 476:

  Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

  A. An ASM instance mounts an ASM control file
  B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
  C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
  D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
  C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
  D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

• Question 477:

  You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.

  You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following commands:

  RMAN> CONNECT CATALOG rco11/password@catdb

  RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER;

  Which two statements are true regarding the tasks accomplished with these commands? (Choose two.)

  A. They import all metadata from the RCAT10 catalog.
  B. They unregister the database from the RCAT10 catalog.
  C. They do not register the databases registered in the RCAT10 catalog.
  D. They register all databases registered in the RCAT10 catalog.
  A. They import all metadata from the RCAT10 catalog.
  D. They register all databases registered in the RCAT10 catalog.

• Question 478:

  You issue the following command: RMAN>CONFIGURE BACKUP OPTIMIZATION ON; What is the result of this command on your backups?

  A. An incremental backup strategy will be used automatically.
  B. Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.
  C. RMAN will configure itself for maximum performance at the cost of CPU.
  D. RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.
  E. RMAN will automatically compress backups.
  B. Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.

• Question 479:

  To enable faster incremental backups, you enabled block change tracking for the database.

  Which two statements are true about the block change tracking file? (Choose two.)

  A. Multiple change tracking files can be created for a database.
  B. The change tracking file must be created after the first level 0 backup.
  C. RMAN does not support backup and recovery of the change tracking file.
  D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
  C. RMAN does not support backup and recovery of the change tracking file.
  D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

• Question 480:

  Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?

  A. New channels for restore and recovery tasks
  B. New name for the data files of the tablespace
  C. Auxiliary name for the data files of the tablespace
  D. Auxiliary destinations for an auxiliary set of data files
  D. Auxiliary destinations for an auxiliary set of data files