Proper study guides for Renovate Oracle Oracle Database 12c: Advanced Administration certified begins with Oracle 1Z0-063 preparation products which designed to deliver the Refined 1Z0-063 questions by making you pass the 1Z0-063 test at your first time. Try the free 1Z0-063 demo right now.


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

Q41. Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command: 

SQL>STARTUP 

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

A. All redo log files are opened. 

B. The root, the seed, and all the PDBs are opened in read-write mode. 

C. All the PDBs are opened in read-write mode. 

D. All the PDBs are in closed state. 

E. Only the root databaseis opened in read-write mode. 

Answer: A,E 


Q42. For which three pieces of information can you use the RMAN list command? 

A. stored scripts in the recovery catalog 

B. available archived redo log files 

C. backup sets and image copies that are obsolete 

D. backups of tablespaces 

E. backups that are marked obsolete according to the current retention policy 

Answer: A,B,D 

Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup007.htm 

http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585 

The primary purpose of the LIST command is to list backup andcopies. For example, you can list: 

–Backups and proxy copies of a database, tablespace, datafile, archived redo log, or control file 

–Backups that have expired 

–Backups restricted by time, path name, device type, tag, or recoverability 

–Archived redolog files and disk copies 


Q43. You set the following parameters in the parameter file and restart the database instance: 

NEMORY_MAX_TARGET=0 

MEMORY__TARGET=500M 

PGA_AGGREGATE_TARGET=90M 

SGA_TARGET=270M 

Which two statements are true? 

A. The memory_max_target parameter is automatically set to 500 MB. 

B. The pga_aggregate_target and sga_target parameters are automatically set to zero. 

C. The value of the memory_max_target parameter remains zero for the database instance. 

D. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively. 

E. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values. 

Answer: C,E 


Q44. 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 systemand 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 thetest system 

Answer:


Q45. You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command. 

What is the outcome? 

A. The PDB is closed. 

B. The PDB is placed in mount state. 

C. The command executes only if the common user is granted the set container privilege for the PDB. 

D. The command results in an error because the PDB can be shut down only by a local user. 

Answer:

Reference:http://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN13652 


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


Q47. When is the UNDO_RETENTION parameter value ignored by a transaction? 

A. when the data file of the undo tablespace is autoextensible 

B. when there are multiple undotablespaces available in a database 

C. when the undo tablespace is of a fixed size and retention guarantee is not enabled 

D. when Flashback Database is enabled 

Answer:

Reference:http://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm(undo retention, see the bullets) 


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


Q49. After implementing full Oracle Data Redaction, you change the default value for the number 

data type as follows: 

SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE 

SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1) 

PL/SQL procedure successfully completed. 

SQL> select number_value from redaction_values_for_type_full; 

NUMBER VALUE 

-1 

After changing the value, you notice that FULL redaction continues to redact numeric data with a zero. 

What must you do to activate the new default value for numeric full redaction? 

A. Re-enable redaction policies that use FULL data redaction. 

B. Re-create redaction policies that use FULL data redaction. 

C. Re-connect the sessions that access objects with redaction policies defined on them. 

D. Flush the shared pool. 

E. Restart the database instance. 

Answer:

Explanation: About Altering the Default Full Data Redaction Value You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect. 


Q50. You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization. 

Which two backup solutions can be used? 

A. RMAN recovery catalog 

B. RMAN Media Management Library 

C. Enterprise Manager Cloud Control 

D. Enterprise Manager Database Express 

E. Oracle Secure Backup 

Answer: A,C