Testking offers free demo for 1Z0-063 exam. "Oracle Database 12c: Advanced Administration", also known as 1Z0-063 exam, is a Oracle Certification. This set of posts, Passing the Oracle 1Z0-063 exam, will help you answer those questions. The 1Z0-063 Questions & Answers covers all the knowledge points of the real exam. 100% real Oracle 1Z0-063 exams and revised by experts!
♥♥ 2017 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-063 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q81. Which three statements are true about Oracle Restart?
A. It can be configured to automatically attempt to restart various components after a hardware or software failure.
B. While starting any components, it automatically attempts to start all dependencies first and in properorder.
C. It can be configured to automatically restart a database in case of normal shutdown of the database instance.
D. It can be used to only start Oracle components.
E. It runs periodic check operations to monitor the health of Oracle components.
Q82. Yourdatabase supports an OLTP workload. Examine the output of the query:
SQL> SSLECT target_mttr, estimated_mttr FROM v$instance_recovery Target_mttrestimated_mttr
To ensure faster instance recovery, youset the fast_start_mttrjtargh:t initialization parameter to
What is the effect of this setting on the database?
A. Automatic checkpoint tuning is disabled.
B. The frequency of log switches is increased.
C. The overhead on database performance is increased because of frequent writes to disk.
D. The MTTR advisor is disabled.
Q83. Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN?
A. The compatible initialization parameter is set to 10.2 or higher.
B. There are no guaranteed restore points defined for the database.
C. The default device for the backup must be set to disk.
D. The tablespaces are locally managed.
E. The fast recovery area is less than 50 percentfree.
Reference:http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#BRAD V89481(See unused block compression)
Q84. Examine the following set of RMAN commands:
RKAN> CONFIGURE CHANNEL del DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ;
ALLOCATE CHANNEL chl DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
Which statement is true about the RMAN run block execution?
A. The script is executed and both DC1 and chi channels are used for script execution.
B. The execution of the script fails because multiple channels cannot exist simultaneously.
C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN run block.
D. The new channel, chi, is ignored because a channel has been configured already.
Q85. You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema.
After a few days, you want to alter the EMPLOYEES table by executing the command:
SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);
Which statement is true about the execution of the command?
A. It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.
B. It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.
C. It executes successfully and continues to store metadata related to the EMPLOYEES table.
D. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.
Q86. Examine the output: SQL > ARCHIVE LOGLIST Database log modeArchive Mode
Automatic archivalEnabled Archive DestinationUSE_DB_RECOVERY_FILE_DEST
Oldest online log sequence376
Next log sequence to archive378
Current log sequence378
Which three types of files are automatically placed in the fast recovery area?
A. Flashback data archives (FDA)
B. Archived redo log files
C. Control file autobackups
D. Server parameter file (SPFILE)
E. Recovery Manager (RMAN) backup pieces
Q87. Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIEDBY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?
A. password-mode encryption
B. dual-mode encryption
C. transparent encryption
D. default encryption
Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGE JABH(to make password –encrypted backups)
Q88. Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file?
A. Shut downthe instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.
B. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.
C. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.
D. Mount the database, restore all data files belongingto the system tablespace from the last backup, and open the database.
Q89. Which two statements are true about the Automatic Diagnostic Repository (ADR)?
A. The ADR base is shared across multiple instances.
B. The ADR base keeps all diagnostic information in binary format.
C. The ADR can be used to store statspack snapshots to diagnose database performance issues.
D. The ADR can be used for problem diagnosis even when the database instance is down.
E. The ADR is used to store Automatic Workload Repository (AWR) snapshots.
Q90. You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameterto YYYY-MM-DD. The default format of which two data types would be affected by this setting?
C. INTERVAL YEAR TO MONTH
D. INTERVAL DAY TO SECOND
E. TIMESTAMP WITH LOCAL TIME ZONE