Oracle Database 12c: Advanced Administration - 1z0-063 Exam Practice Test

A. All audit data is written to both the traditional locations and to the unified location. B. The audit trail uses less space. C. The audit trail is read-only. D. Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the unified location. E. The audit trail is in a single format.

A. when recovering a table to a point in time B. when recovering dropped tables that are present in the recyclebin C. when recovering data that was lost after a DDL operation modified the structure of a table D. when recovering a table that has been logically corrupted E. when recovering the data of a table to the desired point in time, which is more recent than the oldest available undo

A. DB_FLASHBACK_RETENTION_TARGET B. DB_RECOVERY_FILE_DEST C. DB_RECOVERY_FILE_DEST_SIZE D. at least two locations using DB_CREATE _ONLINE_LOG_DEST_n E. DB_CREATE_FILE_DEST F. LOG_ARCHIVE_DEST

A. Executing DML statements on objects stored in the datafile being moved B. Performing file shrink of the data file being moved C. Querying tables in the datafile being moved D. Flashing back the database E. Creating and dropping tables in the datafile being moved F. Performing Block Media Recovery for a data block in the datafile being moved

A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB. B. A database managed by Oracle Restart can have additional services created or existing services modified by using the SRVCTL utility for each PDB. C. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created. D. Only a common user can create additional services for a PDB. E. When a PDB is created, a service with the same name as the PDB is created in the PDB.

A. Recovery Manager (RMAN) backup pieces B. Control file autobackups C. Flashback data archives (FDA) D. Archived redo log files E. Server parameter file (SPFILE)

A. all users except sys B. all users except sys, system, and scott C. all users except scott D. all users except sys and scott

A. It restores all data files and control files from the most recent backup taken before the "until time", and then recovers up to the "until time" using any restored archive logs that are needed to complete the task. B. It restores all data files from the specified time, and then applies the redo logs. C. It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time. D. It restores the control file and all data files from the most recent backups, and then applies the redo logs up to the "until time".