Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 1:

  Which Scheduler view(s) can be queried to see which jobs are currently executing? (Choose all that apply.)

  A. DBA_SCHEDULER_JOB_RUN_DETAILS
  B. DBA_SCHEDULER_RUNNING_JOBS
  C. DBA_SCHEDULER_CURRENT_JOBS
  D. DBA_SCHEDULER_JOBS
  E. DBA_SCHEDULER_EXECUTING_JOBS
  B. DBA_SCHEDULER_RUNNING_JOBS
  D. DBA_SCHEDULER_JOBS

• Question 2:

  The SQL Tuning Advisor has been configured with default configurations in your database instance.

  Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?

  A. statistics recommendations
  B. SQL profile recommendations
  C. index-related recommendations
  D. restructuring of SQL recommendations
  B. SQL profile recommendations

• Question 3:

  Which command is used to begin a tablespace point-in-time recovery?

  A. Restore tablespace
  B. Recover tablespace
  C. Tablespace recover
  D. Recover to time
  E. recover datafile
  B. Recover tablespace

• Question 4:

  Examine the following ALTER command;

  SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;

  What is the purpose of the command?

  A. It cancels all pending disk drops within the disk group.
  B. It adds previously dropped disks back into the disk group.
  C. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.
  D. It mounts disks in the disk group for which the drop-disk operation has already been completed.
  E. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed.
  A. It cancels all pending disk drops within the disk group.

• Question 5:

  Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform? (Choose three.)

  A. Both source and target database must be the same character set
  B. Both source and target database must have the same endian format
  C. The COMPATIBLE parameter must be the same in the source and target databases.
  D. The minimum compatibility level for both the source and target database must be 10.0.0.
  E. All read-only and offline data files that belong to the tablespace to be transported must be platform aware.
  A. Both source and target database must be the same character set
  B. Both source and target database must have the same endian format
  D. The minimum compatibility level for both the source and target database must be 10.0.0.

• Question 6:

  You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows:

  CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP '';

  Which statement regarding the above command is correct?

  A. It will create the tablespace TEMP1 in group G1.
  B. It will create the tablespace TEMP1 in group G3.
  C. It will not add the tablespace TEMP1 to any group.
  D. It will create the tablespace TEMP1 in the default group.
  C. It will not add the tablespace TEMP1 to any group.

• Question 7:

  Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query?

  A. XID
  B. VERSIONS_PK
  C. VERSIONS_XID
  D. VERSIONS_UNIQUE
  C. VERSIONS_XID

• Question 8:

  You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, as shown here:

  1.

  Put the tablespaces in backup mode.

  2.

  Back up the datafiles for all tablespaces.

  3.

  Take the tablespaces out of backup mode.

  4.

  Back up all archived redo logs.

  Your colleague asks for you to comment on his plan. Which response would be correct?

  A. The plan will work as is.
  B. The plan needs to be modified to allow for an archive-log switch after step 3.
  C. The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.
  D. The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.
  E. The plan cannot work as presented.
  B. The plan needs to be modified to allow for an archive-log switch after step 3.

• Question 9:

  Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement:

  ALTER TABLESPACE data1 BEGIN BACKUP;

  While you are performing the backup, an error occurs that causes the instance to terminate abnormally.

  Which statement about the DATA1 tablespace is true?

  A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
  B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
  C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
  D. If you restart the database, the database will not be opened.
  D. If you restart the database, the database will not be opened.

• Question 10:

  To enable resumable space allocation for the instance, which of the following initialization parameters you set to a nonzero value?

  A. RESUMABLE_SPACE_TIME
  B. RESUMABLE_SPACE
  C. RESUMABLE_TIME
  D. RESUMABLE_TIMEOUT
  E. TIME_RESUMABLE
  D. RESUMABLE_TIMEOUT