Free 1Z0-063 Exam Dumps

Question 26

- (Exam Topic 2)
Which two statements are true regarding Oracle Data Pump? (Choose two.)

A. EXPDP and IMPDP are the client components of Oracle Data Pump.
B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.
E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

Correct Answer:AB

Question 27

- (Exam Topic 1)
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition: create table employees
(empno number, salary number, deptid number, name varchar2(100), period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)

A. The valid time columns employee_time_start and employee_time_end are automatically created.
B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIODFOR clauses.
C. The valid time columns are not populated by the Oracle Server automatically.
D. The valid time columns are visible by default when the table is described.
E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Correct Answer:ABC
A: To implement Temporal Validity(TV), 12c offers the option to have two date columns in that table which is having TV enabled using the new clause Period For in the Create Table for the newly created tables or in the Alter Table for the existing ones. The columns that are used can be defined while creating the table itself and will be used in the Period For clause or you can skip having them in the table’s definition in the case of which, the Period For clause would be creating them internally.

Question 28

- (Exam Topic 2)
As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?

A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.
B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
C. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.

Correct Answer:B

Question 29

- (Exam Topic 2)
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting? (Choose two.)

A. DATE
B. TIMESTAMP
C. INTERVAL YEAR TO MONTH
D. INTERVAL DAY TO SECOND
E. TIMESTAMP WITH LOCAL TIME ZONE

Correct Answer:BE

Question 30

- (Exam Topic 1)
You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database:
CONNECT /AS SYSDBA
ALTER SYSTEM SET THREADED_EXECUTION=TRUE SCOPE=SPFILE; SHUTDOWN IMMEDIATE
You then restart the instance and get an error: STARTUP
ORA-01031: insufficient privileges
Why does the startup command return the error shown?

A. because the threaded architecture requires exiting from sql*plus and reconnecting with sql*Plus / as sysdba before issuing a startup command
B. because the threaded architecture requires issuing a new connect / as sysdba from within sql*plus before issuing a startup command
C. because the threaded architecture requires authentication using a password file before issuing a startup command
D. because the threaded architecture requires connecting to the instance via a listener before issuing a startup command
E. because the threaded architecture requires restarting the listener before issuing a startup command

Correct Answer:C