Which two are prerequisites for creating a backup-based duplicate database? (Choose two.)
A. connecting to the target database and a recovery catalog to execute the duplicate command
B. creating a password file for an auxiliary instance
C. connecting to an auxiliary instance
D. matching the database identifier (DBID) of the source database and the duplicate database E. creating an SPFILE for the target database
LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID).
SSL has been configured for the database and OID and the password file has been configured for the database.
User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.
Which authentication method will be attempted first?
A. authentication by password file
B. authentication by using certificates over SSL
C. authentication by using the Oracle Internet Directory
D. authentication by using the local OS of the database server
Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted.
Examine the steps to recover the online redo log group and move it to a new location.
1.
Restore the corrupted redo log group.
2.
Restore the database from the most recent database backup.
3.
Perform an incomplete recovery.
4.
Relocate the member of the damaged online redo log group to a new location.
5.
Open the database with the resetlogs option.
6.
Issue a checkpoint and clear the log.
Identify the required steps in the correct order.
A. 1, 3, 4, 5
B. 6, 3, 4, 5
C. 2, 3, 4, 5
D. 6, 4, 3, 5
You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges.
The statistics_level parameter is PDB modifiable.
As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?
A. The statistics_level parameter is set to all when any of the PDBs is reopened.
B. The statistics_level parameter is set to all only for PDB2 when it is reopened.
C. The statistics_level parameter is set to all when the root database is restarted.
D. The statement is ignored because there is no SPFILE for a PDB.
Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is
performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?
A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
B. level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
C. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
Your database is running in ARCHIVELOG mode. Examine the initialization parameters you plan to set for your database instance.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch' LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch' L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'
Identify the statement that correctly describes these settings.
A. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the LOG_ARCHIVE_DEST_.n destinations.
B. Optional destinations cannot use the fast recovery area.
C. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for LOG_ARCHIVE_DEST_4.
D. These settings work only if LOG__ARCHIVE_MIN_SUCCEED_DEST is set to a value of 4.
Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler? (Choose three.)
A. A job is specified as part of a program definition.
B. A program can be used in the definition of multiple jobs.
C. A program and job can be specified as part of a schedule definition.
D. A program and schedule can be specified as part of a job definition.
E. A program and window can be specified as part of a job definition.
Which two statements describe the relationship between a window, a resource plan, and a job class? (Choose two.)
A. A window specifies a resource plan that will be activated when that window becomes active.
B. A window specifies a job class that will be activated when that window becomes active.
C. A job class specifies a window that will be open when that job class becomes active.
D. A window in association with a resource plan controls a job class allocation.
E. A window in association with a job class controls a resource allocation.
You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).
You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation?
A. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system
B. capturing the workload on the production system and replaying the workload for one PDB at a time on the test system
C. capturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs
D. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the test system
Identify three benefits of unified auditing. (Choose three.)
A. It helps to reduce disk space used to store an audit trail in a database.
B. It guarantees zero-loss auditing.
C. It reduces overhead on a database caused by auditing, by having a single audit trail.
D. An audit trail cannot be modified because it is read-only.
E. It automatically audits Recovery Manager (RMAN) events.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-063 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.