Want to know Actualtests 1Z0-063 Exam practice test features? Want to lear more about Oracle Oracle Database 12c: Advanced Administration certification experience? Study Best Quality Oracle 1Z0-063 answers to Renewal 1Z0-063 questions at Actualtests. Gat a success with an absolute guarantee to pass Oracle 1Z0-063 (Oracle Database 12c: Advanced Administration) test on your first attempt.


♥♥ 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

Free Instant Download NEW 1Z0-063 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/1Z0-063-exam-dumps.html

Q31. Which two statements are true regarding SecureFile lobs? 

A. The amount of undo retained is user controlled. 

B. They can be used only for nonpartitioned tables. 

C. Fragmentation is minimized by using variable-sized chunks. 

D. They support random reads and writes of encrypted LOB data. 

Answer: C,D 

Reference:http://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm#AD LOB46113 


Q32. For which two requirements would you use the Database Resource Manager? 

A. limiting the CPU used per database call 

B. specifying the maximum number of concurrent sessions allowed for a user 

C. specifying the amount of private space a session can allocate in the shared pool of the SGA 

D. limiting the degree of parallelism of operations performed by a user or group of users 

E. specifying an idle time limit that applies to sessions that are idle and blocking other sessions 

Answer: B,E 


Q33. The CATDBI2c database contains an Oracle Database 12c catalog schema owned by the rc12c user. 

The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RCII user. 

A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open. 

In the CATDB12c database, you execute the commands: 

Srman 

RMAN> CONNECT CATALOG rc12c/pass12c8catdbI2c 

RMAN> IMPOST CATALOG rc1l/pwdcatl19catdbl1 DBID=I423241; 

What is the outcome of the import? 

A. It fails because the target database and recovery catalog database are of different versions. 

B. It succeeds and all global scripts in the sc:: catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed. 

C. It succeeds but the database is not automatically registered in the Rc12c catalog. 

D. It fails because RMAN is not connected to the target database with DBID=1423241. 

Answer:


Q34. Which three statements are true about unplugging a pluggable database (PDB)? 

A. The PDB must be open in read only mode. 

B. The PDB must be dosed. 

C. The unplugged PDB becomes a non-CDB. 

D. The unplugged PDB can be plugged into the same multitenant container database (CDB) 

E. The unplugged PDB can be plugged into another CDB. 

F. The PDB data files are automatically removed from disk. 

Answer: B,D,E 

Explanation: B, not A: The PDB must be closed before unplugging it. 

D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means,quite simply, that an unplugged PDB cannot be moved across an endianness difference. 

E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that thePDB’s datafiles can remain in place. 

Reference: Oracle White Paper, Oracle Multitenant 


Q35. Your database supports a Decision Support System (DSS)workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache. 

What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance? 

A. SQL Performance Analyzer 

B. SQL Access Advisor 

C. SQL Tuning Advisor 

D. Automatic Workload Repository (AWR) report 

E. Automatic Database Diagnostic Monitor (ADDM) 

Answer:

Reference:http://docs.oracle.com/cd/B28359_01/server.111/b28275/tdppt_sqltune.htm#TD PPT160(4thpara) 


Q36. Which three RMAN persistent settings can be set for a database? 

A. backup retention policy 

B. default backup device type 

C. default section size for backups 

D. default destinations for backups 

E. multiple backup device types for a single backup 

Answer: A,B,D 

Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup004.htm#i10197 39 


Q37. Which two are prerequisites for setting up Flashback Data Archive? 

A. Fast Recovery Area should be defined. 

B. Undo retention guarantee should be enabled. 

C. Supplemental logging should be enabled. 

D. Automatic Undo Management should be enabled. 

E. All users using Flashback Data Archive should have unlimitedquota on the Flashback Data Archive tablespace. 

F. The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled. 

Answer: D,F 

Reference:http://www.oracle.com/technetwork/database/focus-areas/storage/total-recall-whitepaper-171749.pdf(page 8) 


Q38. Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). 

A. to store backup information of multiple databases in one place 

B. to restrict the amount of space that is used by backups 

C. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause 

D. to store RMAN scripts that are available to any RMAN client that can connect to target databasesregistered in the recovery catalog 

E. to automatically delete obsolete backups after a specified period of time 

Answer: A,C,D 


Q39. Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database(COB) plan using Oracle Database Resource Manager? 

A. maximum undo per consumer group 

B. maximum idle time for a session in a PDB 

C. parallel server limit 

D. CPU 

E. maximum number of sessions for a PDB 

Answer: C,D 


Q40. Which two statements are true about a common user? 

A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs. 

B. A common user with the create user privilege can createother common users, as well as local users. 

C. A common user can be granted only a common role. 

D. A common user can have a local schema in a PDB. 

E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace. 

Answer: C,D