1Z0-063 | The Updated Guide To 1Z0-063 vce

Q81. You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB). 

The following are the possible steps to accomplish this task: 

1. 

Place all the user-defined tablespace in read-only mode on the source database. 

2. 

Upgrade the source database to a 12c version. 

3. 

Create a new PDB in the target container database. 

4. 

Perform a full transportable export on the source database withthe VERSION parameter set to 12 using the expdp utility. 

5. 

Copy the associated data files and export the dump file to the desired location in the target database. 

6. 

Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options. 

7. 

Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. 

Identify the correct order of the required steps. 

A. 2, 1, 3, 4, 5, 6 

B. 1, 3, 4, 5, 6, 7 

C. 1, 4, 3, 5, 6, 7 

D. 2, 1, 3, 4, 5, 6, 7 

E. 1, 5, 6, 4, 3, 2 

Answer: C 

Q82. What can be automatically implemented after the SQL Tuning Advisoris run as part of the Automated Maintenance Task? 

A. statistics recommendations 

B. SQL profile recommendations 

C. SQL statement restructure recommendations 

D. creation of materialized views to improve query performance 

Answer: C 

Reference:http://docs.oracle.com/cd/E11882_01/server.112/e16638/sql_tune.htm#PFGRF 

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

0 

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: E 

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. 

Q84. You notice a performance change in your production Oracle 12c database. You want to knowwhich change caused this performance difference. 

Which method or feature should you use? 

A. Compare Period ADDM report 

B. AWR Compare Period report 

C. Active Session History (ASH) report 

D. taking a new snapshot and comparing it with a preserved snapshot 

Answer: B 

Explanation: The awrddrpt.sql report is the Automated Workload Repository Compare Period Report. The awrddrpt.sql script is located in the $ORACLE_HOME/rdbms/admin directory. 

Incorrect: Not A: Compare Period ADDM Use this report to perform a high-level comparison of one workload replay to its capture or to another replay of the same capture. Only workload replays that contain at least 5 minutes of database time can be compared using this report. 

Q85. 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: B 

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

Q86. Which two are prerequisites for creating a backup-based duplicate database? 

A. connecting to the target database and a recovery catalog to execute the duplicate command 

B. creating a password file for an auxiliary instance 

C. connecting to an auxiliary instance 

D. matching the database identifier (DBID) of the source database and the duplicate database 

E. creating an SPFILE for the target database 

Answer: A,B 

Reference:http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#CH DEDFFH 

Q87. Your database is running in archivelog mode. Examine the parameters for your database instance: 

LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY' 

LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch' 

LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch' 

LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch' 

LOG_ARCHIVE _MIN_SUCCEED_DEST = 2 

While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used. 

What happens at the next log switch? 

A. The database instance hangs and the redo logfiles are not overwritten. 

B. The archived redo log files are written to the fast recovery area until the mandatory destination is made available. 

C. The database instance is shutdown immediately. 

D. The destination set by the log_archive_dest parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success. 

Answer: D 

Q88. 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: A 

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

Q89. Which three statements are true about the keystore storage framework for transparent data encryption? 

A. It facilitates and helps to enforce keystore backup requirements. 

B. It handles encrypted data without modifying applications. 

C. It enables a keystore to be stored only in a file on a file system. 

D. It enables separation of duties between the database administrator and the security administrator. 

E. It transparently decrypts data for the databaseusers and applications that access this data. 

F. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations. 

Answer: A,D,F 

Reference: http://oradb-srv.wlv.ac.uk/E16655_01/network.121/e17729/asotrans.htm#CHDEABCA (benefits of the keystore storage framework) 

Q90. Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN: 

1.Create media families for data files and archived redo log files. 

2.Configure database backup storage selectors or RMAN media management parameters. 

3.Create an OSB user preauthorized for RMAN operations. 

4.Configure RMAN Access to the OSB SBT. 

5.Disable Non-Uniform Memory Access (NUMA) awareness by setting the 

ob_ignore_numa parameter to 0. 

Identify the steps in the correct order. 

A. 1, 4, 3, 2, 5 

B. 1, 3, 4, 5, 2 

C. 4, 3, 1, 2, 5 

D. 4, 3, 5, 1, 2 

Answer: C