Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 111:

  Which commands are used for RMAN database recovery? (Choose all that apply.)

  A. restore
  B. repair
  C. copy
  D. recover
  E. replace
  A. restore
  D. recover

• Question 112:

  You want to perform the following operations for the DATA ASM disk group:

  Verify the consistency of the disk.

  Cross-check all the file extent maps and allocation tables for consistency.

  Check whether the alias metadata directory and file directory are linked correctly.

  Check that ASM metadata directories do not have unreachable allocated blocks.

  Which command accomplishes these tasks?

  A. ALTER DISKGROUP data CHECK;
  B. ALTER DISKGROUP data CHECK DISK;
  C. ALTER DISKGROUP data CHECK FILE;
  D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;
  A. ALTER DISKGROUP data CHECK;

• Question 113:

  What can you determine about the following linguistic sorts based only on their names?

  1.

  GERMAN

  2.

  FRENCH_M

  A. 1 is a monolingual sort.
  B. 2 is a monolingual sort.
  C. 1 is case insensitive.
  D. Both 1 and 2 are case insensitive.
  E. Case sensitivity is unknown.
  A. 1 is a monolingual sort.

• Question 114:

  When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?

  A. SET_JOB_ARGUMENT_VALUE
  B. SET_JOB_VALUE_ANYDATA
  C. SET_JOB_ANYDATA_VALUE
  D. SET_SPECIAL_JOB_VALUE
  E. SET_JOB_ANYTYPE_VALUE
  C. SET_JOB_ANYDATA_VALUE

• Question 115:

  Which of the following statements are true regarding the Recycle Bin? (Choose all that apply.)

  A. The Recycle Bin is a physical storage area for dropped objects.
  B. The Recycle Bin is a logical container for dropped objects.
  C. The Recycle Bin stores the results of a Flashback Drop operation.
  D. The objects in the Recycle Bin are stored in the tablespace in which they were created.
  B. The Recycle Bin is a logical container for dropped objects.
  D. The objects in the Recycle Bin are stored in the tablespace in which they were created.

• Question 116:

  What command is used to reset a database to a previous incarnation?

  A. reset incarnation
  B. incarnation reset
  C. reset database to incarnation
  D. reset database incarnation
  E. reset databse incarnation number
  C. reset database to incarnation

• Question 117:

  How many database instances are used during a database-duplication process?

  A. One
  B. Two
  C. Three
  D. Four
  E. Five
  B. Two

• Question 118:

  Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line? Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database. (Choose all that apply.)

  A. rman target=/ catalog=/@rcat
  B. rman target=/ catalog=rcat_own/rcat_own
  C. rman target=/ catalog=rcat_own/rcat_own@RCAT
  D. rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCAT
  E. You cannot connect to the target database and the recovery catalog at the same time.
  C. rman target=/ catalog=rcat_own/rcat_own@RCAT
  D. rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCAT

• Question 119:

  Which of the following Oracle features utilize the undo tablespace? (Choose all that apply)

  A. Flashback Query
  B. Flashback Drop
  C. Flashback Table
  D. Flashback Database
  E. Transaction Processing
  F. Recycle Bin
  A. Flashback Query
  C. Flashback Table
  E. Transaction Processing

• Question 120:

  You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database.

  The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?

  A. Open the database in NORMAL mode
  B. Open the database in read-only mode
  C. Open the database in RESTRICTED mode
  D. Open the database with the RESETLOGS option
  D. Open the database with the RESETLOGS option