1Z0-063 | Downloadable Database 12c 1Z0-063 exam


Q91. Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? 

A. Reduced logical I/O 

B. Reduced virtual memory utilization 

C. Improved Serial Execution performance 

D. Reduced physical I/O 

E. Reduced CPU utilization 

Answer: B,E 

Q92. You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements: 

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; 

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; 

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; 

For which database users is the audit policy now active? 

A. all users exceptsys 

B. all users except scott 

C. all users except sys and scott 

D. all users except sys, system, and scott 

Answer:

Q93. You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. 

Which method or feature should you use? 

A. Database Replay 

B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report 

C. Active Session History (ASH) report 

D. SQL Performance Analyzer 

Answer:

Reference:http://docs.oracle.com/cd/E24628_01/server.121/e17635/tdppt_degrade.htm 

Q94. 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 

Q95. You issue the RMAN commands: 

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; 

RKAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY; 

RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON; 

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; 

Which three tasks are performed by the BACKUP DATABASE command? 

A. switching the online redo log file 

B. backing up all data files as image copies and archive log files, and deleting those archive log files 

C. backing up only the used blocks in the data files 

D. backing up all used and unused blocks in the data files 

E. backing up allarchived log files and marking them as obsolete 

Answer: A,C,E 

Q96. You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation? 

A. The backup must be performed in mount state. 

B. The tablespace must betaken offline. 

C. All files must be backed up as backup sets. 

D. The database must be backed up as an image copy. 

Answer:

Q97. Examine these Data Pump commands to export and import objects from and to the same database. 

The dba has not yet created users hr1 and oe1. 

$expdp system/manager schemas = hr.oe directory = EXP_DIR dumpfile = export.dat include = table 

$ impdpsysten/manager schemas = hr1,oe1 directory = EXP_DIR dumpfile = export.dat remap_schena=hr:hrl, oe:oe1 

What will happen when running these commands? 

A. expdp will fail because no path has been defined for the dumpfile. 

B. expdp will succeed but impdp will fail because the users do not exist. 

C. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas. 

D. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively. 

Answer:

110. RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database: 

RMAN> DUPLICATE TARGET DATABASE TO dup1 

FROM ACTIVE DATABASE 

NOFILENAMECHECK 

PASSWORD FILE 

SPFILE; 

Which two statements are true about the execution of the duplicate command? 

A. All archive redo log files are automatically copied to the duplicate database. 

B. The duplicate database has the same directory structure as the source database. 

C. The duplicate database is created by using the backups created during the execution of 

D. the duplicate command. 

E. The password file and SPFILE for theduplicate database dup1 are created in their respective default locations. 

F. The duplicate database is created without using RMAN backups and prod: is allowed to remain open during duplication. 

Answer: A,F 

Q98. In which situation can you use Flashback Database? 

A. whenundoing a shrink data file operation 

B. when retrieving a dropped tablespace 

C. when returning to a point in time before the restoration or re-creation of a control file 

D. when returning to a point in time before the most recent open resetlogs operation 

Answer:

Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm(pre requisites, thirdpara) 

http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194 

Q99. Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup? 

A. Tables or table partitions can be recovered by using an auxiliary instance only. 

B. Tables or table partitions with a foreign key cannot be recovered. 

C. Tables or table partitions can be recovered only when the database is in mount state. 

D. Tables or table partitions from the system and sysauxtablespaces cannot be recovered. 

E. Tables with not null constraints cannot be recovered. 

Answer: A,D 

Reference:http://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695(Limitat ions of Recovering Tablesand Table Partitions from RMAN Backups) 

Q100. Your database is running in archivelog modeand Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database? 

A. Enable minimal supplemental logging. 

B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back. 

C. Enable the recyclebin. 

D. Enable undo retention guarantee. 

E. Enable Fast Recovery Area. 

Answer: A,C