Oracle Oracle Database Application Development 1Z0-063 Questions & Answers

• Question 1:

  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;

  Correct Answer: AC

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

• Question 2:

  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.

  Correct Answer: BC

• Question 3:

  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

  Correct Answer: A

• Question 4:

  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.

  Correct Answer: A

• Question 5:

  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.

  Correct Answer: D

• Question 6:

  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.

  Correct Answer: CE

  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:

  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.

  Correct Answer: B

• Question 8:

  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

• Question 9:

  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.

  Correct Answer: AE

• Question 10:

  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.

  Correct Answer: CE