Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 81:

  Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B? (Choose all that apply.)

  A. A must contain all of the characters defined in B.
  B. A must be Unicode.
  C. The encoded values in A must match the encoded values in B for all characters defined in B.
  D. A must be a multi-byte character set.
  E. The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B.
  A. A must contain all of the characters defined in B.
  C. The encoded values in A must match the encoded values in B for all characters defined in B.

• Question 82:

  Which is the correct command to put the database in ARCHIVELOG mode?

  A. alter database archivelog
  B. alter system enable archivelog mode
  C. alter database enable archive
  D. alter database archivelog enable
  E. None of the above
  A. alter database archivelog

• Question 83:

  Which type of database file is spread across all disks in a disk group?

  A. All types of files are spread across all disks in the disk group.
  B. Datafiles
  C. Redo log files
  D. Archived redo log files
  E. Control files
  A. All types of files are spread across all disks in the disk group.

• Question 84:

  You run the following commands:

  RMAN> list expired backup; RMAN> delete expired backup;

  What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?

  A. They will be renamed.
  B. Nothing will happen to them. The backup set pieces do not exist.
  C. They will be deleted immediately since they are not in the flash recovery area.
  D. You will need to manually remove the physical files listed in the output of the commands.
  E. They will become hidden files and removed 10 days later.
  B. Nothing will happen to them. The backup set pieces do not exist.

• Question 85:

  Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository (ADR)?

  A. The incident metadata is purged when the problem is resolved and the DBA closes the SR.
  B. The incident files and dumps are not retained in the ADR for the manually created incidents.
  C. The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR
  D. The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month.
  D. The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month.

• Question 86:

  Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.

  The steps to recover the damaged data files are follows:

  1.

  Mount the database

  2.

  Open the database

  3.

  Recover the data file

  4.

  Restore the data file

  5.

  Make the data file offline

  6.

  Make the data file online

  Which option identifies the correct sequence that you must use to recover the data files?

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

• Question 87:

  Examine the output of the query that you executed to list the objects in the recycle bin:

  

  You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:

  SQL> PURGE TABLE sales_tab;

  What would be the outcome of this command?

  A. All three tables in the recycle bin are purged
  B. Only the table with the oldest DROPSCN is purged
  C. The command returns an error because multiple entries with the same name exist in the recycle bin
  D. Only the table with the latest DROPSCN is purged
  B. Only the table with the oldest DROPSCN is purged

• Question 88:

  The SQL Tuning Advisor configuration has default settings in your database instance.

  Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?

  A. statistics recommendations
  B. SQL Profile recommendations
  C. Index-related recommendations
  D. restructuring of SQL recommendations
  B. SQL Profile recommendations

• Question 89:

  You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups.

  Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups. Identify two options for completing this task. (Choose two.)

  A. Reregistering the target database in recovery catalog
  B. Transporting the new tablespaces to the recovery catalog database
  C. Syncronizing the recovery catalog with the target database control file
  D. Performing a fresh backup of the target database to include the new data files in the catalog database
  C. Syncronizing the recovery catalog with the target database control file
  D. Performing a fresh backup of the target database to include the new data files in the catalog database

• Question 90:

  View the Exhibit.

  You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File

  System option as the storage mechanism.

  What would be the result of choosing this option?

  Exhibit:

  

  A. Disk mirroring and striping would be done automatically
  B. The database files would be managed by the operating system's file system
  C. DBCA would not save the database files by using Optimal File Architecture (OFA)
  D. The data files are automatically spread across all available storage devices to optimize performance and resource utilization
  B. The database files would be managed by the operating system's file system