Oracle 1Z0-063 Online Practice Questions and Exam Preparation

Oracle 1Z0-063 Online Questions & Answers

• Question 1:

  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.
  B. You can rename tables during import.
  C. You can overwrite existing dump files during export.

• Question 2:

  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;
  A. ALTER TABLESPACE adtbs RESI2E 20G;
  C. ALTER TABLESPACE adtbs AUTOEXTEND ON;

• Question 3:

  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.
  A. The minimum size for the standard buffer cache is 100 MB.

• Question 4:

  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
  A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis

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

• 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.
  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.
  E. All subsequent statements in the session will be treated as one database operation and will be monitored.

• Question 7:

  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.
  C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
  E. A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.

• Question 8:

  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.
  A. All redo log files are opened.
  E. Only the root database is opened in read-write mode.

• Question 9:

  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
  C. because the threaded architecture requires authentication using a password file before issuing a startup command

• Question 10:

  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.
  B. All data files belonging to PDB2_1 are backed up along with the archive log files.