The Secret of 1Z0-063 question
Exam Code: 1Z0-063 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Database 12c: Advanced Administration
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-063 Exam.
Q21. A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?
A. Set the backup_tape_io_slaves parameter to true.
B. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
C. Configure large pool if not already done.
D. Remove the rate parameter, if specified, in the allocate channel command.
E. Always use RMAN compression for tape backups ratherthan the compression provided by media manager.
F. Always use synchronous I/O for the database.
Answer: B,C,D
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmtunin.htm
Q22. 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.
Answer: C,D
Q23. Examine the initialization parameter that is set in the PFILE:
DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'
You execute the following command to create theCDB1. container database (CDB):
SQL>CREATEDATABASECDB1
DEFAULTTABLESPACE users
DEFAULTTEMPORARY TABLESPACEtemp
UNDO TABLESPACEundotbsl
ENABLEPLUGGA3LEDATABASE
SEED
SYSTEMDATAFILESSIZE125M AUTOEXTEND ON NEXT10M MAXSIZEUNLIMITED
SYSAUXDATAFILESSIZE100M;
Which three statements are true?
A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
D. It sets the users tablespace as the default for both the root and seed databases.
E. undotbs1 is used as the undo tablespace for both the root and seed databases.
F. It creates a multitenant container database with the root database opened and the seed database mounted.
Answer: A,B,E
Q24. You want to create a guaranteed restore point for your database by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command.
A. The database must be running in archivelog mode.
B. Flashback Database must be enabled.
C. Fast Recovery Area must be enabled.
D. The recyclebin must be enabled for the database.
E. Undo retention guarantee must be enabled.
F. A database backup must be taken.
Answer: A,C
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb002.htm
Q25. You create two Resource Manager plans, one for night time workloads, the other for day time.
How would you make the plans switch automatically?
A. Use job classes.
B. Use scheduler windows.
C. Use the mapping rule for the consumer groups.
D. Set the switch_time plan directive for both plans.
E. Use scheduler schedules.
Answer: B
Q26. Which two statements are true abouta multitenant architecture?
A. Each pluggable database (PDB) has its own initialization parameter file.
B. A PDB can have a private undo tablespace.
C. Log switches occur only at the container database level.
D. A PDB can have a private temporary tablespace.
E. Each PDB has a private control file.
Answer: C,D
Q27. You restore and recover your database to anew host by using an existing RMAN open database backup.
Which step must you perform next?
A. Execute catproc.sqi to recompile invalid PL/SQL modules.
B. Open the database with the resetlogs option.
C. Set a new database identifier (DBID) for the newly restored database.
D. Use the RMAN set newname and switch commands to switch to new files.
Answer: A
Q28. Identify three benefits of unified auditing.
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.
Answer: C,D,E
Q29. Examine the command used to perform an incrementallevel-0 backup:
RMAN>BACKUPINCREMENTALLEVEL0DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the
command:
SQL>ALTERDATABASEENABLEBLOCKCHANGETRACKINGUSING
FILE'/mydir/rman_change_track.f'
To perform an incremental level-1 cumulative backup, you issue the command:
RMAN>BACKUPINCREMENTALLEVEL1CUMULATIVEDATABASE;
Which two statements are true in the preceding situation?
A. The block change tracking data is used only from the next incremental backup.
B. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.
C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.
D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.
E. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.
Answer: C,E
Q30. In a database supporting an OLTP workload, tables are frequently updated on both key and non-keycolumns.
Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?
A. heap table with a primary key index
B. external table
C. hash clustered table
D. global temporary table
E. index clustered table
Answer: E