Want to know Ucertify 1Z0-063 Exam practice test features? Want to lear more about Oracle Oracle Database 12c: Advanced Administration certification experience? Study Actual Oracle 1Z0-063 answers to Renewal 1Z0-063 questions at Ucertify. 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

Q21. Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? 

A. A DBA can check specific tables with the DMU 

B. The database to be migrated must be opened read-only. 

C. The release of the database to be converted can be any release since 9.2.0.8. 

D. The DMU can report columns that are too long in the converted characterset 

E. The DMU can report columns that are not represented in the converted characterset 

Answer: A,D,E 

Explanation: A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps ofthe migration process. 

D: Exceed column limit 

The cell data will not fit into a column after conversion. 

E: Need conversion 

The cell data needs to be converted, because its binary representation in the target 

character set is different than the representation in the current character set, but neither 

length limit issues nor invalid representation issues have been found. 


Q22. 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:


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


Q24. In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure: 

CREATEORREPLACEPROCEDUREcreate_test_v(v_emp_idNUMBER,v_enameVARCHA 

R2,v_SALARYNUMBER,v_dept_idNUMBER) 

BEGIN 

INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id); 

END; 

GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king; 

How can you prevent users having the execute privilege on the create_test_v procedure frominserting values into tables on which they do not have any privileges? 

A. Create the create_test procedure with definer's rights. 

B. Grant the execute privilege to users with grant option on the create_test procedure. 

C. Create the create_test procedure with invoker's rights. 

D. Create the create_test procedure as part of a package and grant users the execute privilege on the package. 

Answer:


Q25. Which three statements are true about the database instance startup after an instance failure? 

A. The RECO process recovers the uncommitted transactions at the next instance startup. 

B. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery. 

C. Uncommitted changes are rolled back to ensure transactional consistency. 

D. The SMON process automatically performs the database recovery. 

E. Media recovery is required to complete the database recovery. 

F. Changes committed before the failure, which were not written to the data files, are re-applied. 

Answer: A,C,D 


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


Q27. The environmental variable oracle_Base is set to /u01/app/oracleand oracle_home is set to /u01/app/oracle/product/12.1.0/db 1. 

You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database. 

NAMETYPEVALUE 

audit_file_deststring/u01/app/oracle/admin/eml2rep/adump 

background_dump_deststring 

core_dump_deststring 

db_create_file_deststring 

db_recovery_file_deststring/u01/app/oracle/fast_recovery_area 

diagnostic_deststring 

What is the location of the ADR base? 

A. It is set to/u01/app/oracle/product:/12.1.0/db_1/log. 

B. It is set to /u01/app/oracle/admin/enl2r&p/adump. 

C. It is set to /u01/app/oracle. 

D. It is set to/u01/app/oracle/flash_recovery_area. 

Answer:

Explanation: 

http://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm#ADMIN11008 The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down. The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows: If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE. If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log. 


Q28. You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. 

The statistics_level parameter isPDB modifiable. 

As the user sys, execute the following command on pdb2: 

SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE; 

Which statement is true about the result of this command? 

A. The statistics_level parameter is set to all when anyof the PDBs is reopened. 

B. The statistics_level parameter is set to all only for PDB2 when it is reopened. 

C. The statistics_level parameter is set to all when the root database is restarted. 

D. The statement is ignored because there is no SPFILE for a PDB. 

Answer:

73. Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? 

A. Database Resident Connection Pooling 

B. Oracle Suggested Backup Strategy 

C. Database Vault in ORACLE_HOME 

D. Nondefaultblocksizetablespaces 

E. Configure Label Security 

Answer: D,E 


Q29. Examinethe commands: 

SQL> ALTER SESSION SET RECYCLBIN = ON; 

Session altered. 

SQL> DROP TABLE emp; --(First EMP table) 

Total dropped. 

SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) ); 

Table created. 

You then execute multiple INSERT statements to insert rows into EMP table and drop the table again: SQL> DROP TABLE emp; -- (Second EMP table) 

Table dropped. 

SQL> FLASHBACK TABLE emp TO BEFORE DROP; 

Which statement is true about the FLASHBACK command? 

A. It recovers the structure, data, and indexes of the first emp table. 

B. It recovers only the structure of the second emp table. 

C. It returns an error because two tables with the same name exist in the recycle bin. 

D. It recovers the structure, data, and indexes of the second emp table. 

Answer:


Q30. Which two statements are true regarding the Oracle Data Pump export and import operations? 

A. You cannot export data from a remote database. 

B. You can rename tables during import. 

C. You can overwrite existing dump files during export. 

D. You can compress data but not metadata during export. 

Answer: A,B 

Reference:http://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_import.htm#BEHF FDCD