1Z0-063 Practice Questions & Online Exam Preparation

Question 1 Multiple choice

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

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.

Show answer and explanation

Correct answers: B, C

Question 2 Multiple choice

You created a tablespace with this statement:

CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;

The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.

Which two alter statements will achieve this? (Choose two.)

A
ALTER TABLESPACE adtbs RESI2E 20G;
B
ALTER TABLESPACE adtbs ADD DATAFILE;
C
ALTER TABLESPACE adtbs AUTOEXTEND ON;
D
ALTER TABLESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
E
ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

Show answer and explanation

Correct answers: A, C

Explanation

http://www.techonthenet.com/oracle/tablespaces/alter_tablespace.php

Question 3 Single choice

Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.

You execute this command:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true?

A
The minimum size for the standard buffer cache is 100 MB.
B
The maximum size for the standard buffer cache is 100 MB.
C
The minimum space guaranteed in the buffer cache for any server process is 100 MB.
D
The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
E
The minimum size for all buffer caches is 100 MB.

Show answer and explanation

Correct answer: A

Question 4 Single choice

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded.
Sometimes, you are not able to connect to the database instance because it hangs.

How can you detect the cause of the degraded performance?

A
by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
B
by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
C
by using Active Session History (ASH) data and performing hang analysis
D
by running ADDM in diagnostic mode

Show answer and explanation

Correct answer: A

Question 5 Single choice

Examine the command:

Which statement is true about the execution of the command?

A
It fails because the log file parameter is not specified.
B
It fails because no absolute path is specified for the log file and dump file.
C
It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.
D
It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three.

Show answer and explanation

Correct answer: D

Question 6 Multiple choice

Examine the commands executed to monitor database operations:

$> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y');

Which two statements are true? (Choose two.)

A
Database operations will be monitored only when they consume a significant amount of resource.
B
Database operations for all sessions will be monitored.
C
Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL
and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
D
Only DML and DDL statements will be monitored for the session.
E
All subsequent statements in the session will be treated as one database operation and will be monitored.

Show answer and explanation

Correct answers: C, E

Explanation

C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC
+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.
Note:
* The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real-
time Database Operation Monitoring.
*(not B) BEGIN_OPERATION Function starts a composite database operation in the current session.
/ (E) FORCE_TRACKING - forces the composite database operation to be tracked when the operation starts. You can also use the string variable 'Y'. / (not A) NO_FORCE_TRACKING - the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable 'N'.

Question 7 Multiple choice

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;

Which two statements are true? (Choose two.)

A
An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
B
An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
C
The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
D
The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
E
A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.

Show answer and explanation

Correct answers: C, E

Question 8 Multiple choice

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? (Choose two.)

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 database is opened in read-write mode.

Show answer and explanation

Correct answers: A, E

Question 9 Single choice

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

Show answer and explanation

Correct answer: C

Question 10 Single choice

Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2, both of which are open. RMAN is connected to the
target pluggable database PDB2_1.

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Which statement is true about the execution of this command to back up the database?

A
All data files belonging to PDB2_1 are backed up and all archive log files are deleted.
B
All data files belonging to PDB2_1 are backed up along with the archive log files.
C
Only the data files belonging to pdb2_1 are backed up.
D
This command gives an error because archive log files can be backed up only when RMAN is connected to the root container database.

Show answer and explanation

Correct answer: B