1Z0-053 Online Practice Questions and Answers

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

Following is the list of locations in random order where oranfstab can be placed.

1./etc/mtab 2.$ORACLE_HOME/dbs/oranfstab 3./etc/oranfstab

What is the sequence in which Direct NFS will search the locations?

A. 1, 2, 3

B. 3, 2, 1

C. 2, 3, 1

D. 1, 3, 2

You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (Choose two.)

A. Its entries are specific to a single database.

B. It contains file systems that have been mounted by Direct NFS.

C. It is globally available to all Oracle 11g databases on the machine.

D. It contains file systems that have been mounted by the kernel NFS system.

Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?

A. The SGA Tuning Advisor

B. The SQL Access Advisor

C. The SQL Tuning Advisor

D. The Memory Advisor

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

You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to 'ora_%t_%s_%r.log'. Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?

A. The archived redo log files will be overwritten.

B. The archived redo log files are deleted automatically.

C. The archived redo log files should be moved to some other location.

D. The archived redo log files are still maintained because the file names are unique.

Which of the following best describes a full backup?

A. All datafiles of a database

B. All datafiles, archive logs, and control files

C. All datafiles and control files

D. All the used blocks in a datafile

Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generated since the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.

A. 13:00 on Tuesday.

B. 15:00 on Tuesday.

C. Up until the last available archived redo log on Sunday.

D. To any point; all the redo should still be available in the online redo logs.

E. The database is not recoverable.