Free Oracle 1Z0-053 Exam Dumps Questions & Answers

Which operation requires that you create an auxiliary instance manually before executing the operation? (Choose all that apply.)

• A.Backup-based database duplication.
• B.Tablespace point-in-time recovery.
• C.Active database duplication.
• D.No operation requires the creation of an auxiliary instance.

When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?

• A.CASCADE
• B.INCLUDING DEPENDENCIES
• C.INCLUDING DEPENDENCIES CASCADE
• D.None of the above
• E.COMPACT

Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)

• A.It bypasses the OS file system cache.
• B.It uses the operating system kernel NFS layer for user tasks and network communication modules.
• C.A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.
• D.Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.
• E.File systems need not be mounted by the kernel NFS system when being served through Direct NFS.

Which of the following datatypes store time-zone information in the database?

• A.DATE
• B.TIMESTAMP
• C.TIMESTAMP WITH LOCAL TIME ZONE
• D.TIMESTAMP WITH TIME ZONE
• E.DATETIME

What command would you issue to enable automated backups of control files?

• A.enable controlfile autobackup
• B.alter system controlfile autobackup on
• C.configure controlfile autobackup on
• D.alter database controlfile autobackup on