Oracle Oracle Database 1Z0-060 Questions & Answers

• Question 21:

  Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)

  A. The unplugged PDB can be plugged into the same multitenant container database (CDB).

  B. The unplugged PDB can be plugged into another CDB.

  C. The PDB must be open in read-only mode.

  D. The PDB data files are automatically removed from disk.

  E. The unplugged PDB becomes a non-CDB.

  F. The PDB must be closed.

  Correct Answer: ABF

  Reference: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/pdb/pdb_unplug_plug/ pdb_unplug_plug.html

• Question 22:

  Which two partitioning methods are suitable for a parent table when using reference partitioning in Oracle Database 12c? (Choose two.)

  A. interval partitioning

  B. list partitioning

  C. system partitioning

  D. hash partitioning

  E. range partitioning

  Correct Answer: DE

• Question 23:

  Your multitenant container database (CDB) is running in ARCHIVELOG mode.

  Examine this command and its output:

  

  You issue this command in RMAN:

  RMAN>BACKUP PLUGGABLE DATABASE "CDB$ROOT", pdb2_1;

  What is the outcome?

  A. The backup succeeds, but only the SYSTEM and SYSAUX tablespaces in the root container are backed up along with all the data files in PDB2_1.

  B. The backup fails because the root container cannot be backed up with PDB2_1.

  C. The backup succeeds and all the data files belonging to both the root container and PDB2_1 are backed up.

  D. The backup fails because PDB2_1 should be placed in the mount stage.

  Correct Answer: C

• Question 24:

  Which statement is true concerning compression during an Online Datafile Move?

  A. Only tables may be compressed during the Online Datafile Move.

  B. The DBA may choose which objects in the datafile to be moved get compressed.

  C. All objects in a data file to be moved will always to be compressed.

  D. Uncompressed data files may be moved online to compress the entire file with Hybrid Columnar Compression.

  E. If an object is already compressed in the source location, then the compression type for that object remains unchanged after the move.

  Correct Answer: A

• Question 25:

  In which two scenarios is an RMAN recovery catalog automatically resynchronized? (Choose two.)

  A. when a registered database is opened with the RESETLOGS option

  B. when a redo log is archived

  C. when backup metadata records are aged out of the control file based on the CONTROL_FILE_RECORD_KEEP_TIME parameter value

  D. when the backup retention policy configuration is changed for a registered database

  E. when a manual redo log switch is performed

  Correct Answer: AC

• Question 26:

  Your database is running in ARCHIVELOG mode. You back up the control file by executing ALTER DATABASE BACKUP CONTROL TO TRACE NORESETLOGS, whenever you make structural changes to the database. A media failure has damaged all the control files, but the online redo log files are intact. You issue a SHUTDOWN ABORT.

  How should you recover the control file to its default location?

  A. Restore the backup control file to all the locations specified in the CONTROL_FILES parameter file, start a new instance and mount the database, recover the database, and then open the database with the RESETLOGS option.

  B. Issue the STARTUP NOMOUNT command, restore the backup control file only to the default location, issue RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL, and open the database with the RESETLOGS option.

  C. Issue the STARTUP MOUNT command, restore the backup control file to all the locations specified in the CONTROL_FILES parameter file, and then issue RECOVER DATABASE USING BACKUP CONTROLFILE.

  D. Issue the STARTUP NOMOUNT command, re-create the control file manually by using the CREATE CONTROLFILE command, issue the RECOVER DATABASE command, and then issue the ALTER DATABASE OPEN command.

  Correct Answer: B

  Reference: https://docs.oracle.com/cd/E28271_01/backup.1111/e10642/osadvsce.htm

• Question 27:

  Which three statements are true about the use of the query result cache? (Choose three.)

  A. Results obtained from a query rewrite to a materialized view may be stored in the query result cache.

  B. Stale results may still be obtained from the query result cache, if the query session's query_rewrite_integrity parameter is set to stale_tolerated.

  C. Results obtained from a join between a table and a view may be stored in the query result cache.

  D. Results from distributed queries are never stored in the query result cache.

  E. Results may not be obtained from the query result cache, when the query_rewrite_enabled parameter is set to false.

  F. Results from remote queries may sometimes be stored in the query result cache.

  Correct Answer: ABE

• Question 28:

  You configure your database Instance to support shared server connections.

  Which two memory areas that are part of PGA are stored in SGA instead, for shared server connections?

  A. User session data

  B. Stack space

  C. Persistent area containing bind variable values that are supplied to a SQL statement at run time

  D. Location of the runtime area for DML and DDL Statements

  E. Location of a part of the runtime area for SELECT statements

  Correct Answer: AC

• Question 29:

  Your database uses Automatic Memory Management, and has the large pool configured.

  You issue the following command:

  SQL> ALTER SYSTEM SET SHARED_SERVERS = 5;

  Which statement is true about the shared server configuration?

  A. It is enabled only if the SHARED_SERVER_SESSIONS parameter is configured.

  B. It is enabled and the UGA is located in the large pool for connections that use the shared server configuration.

  C. It is enabled only if at least five dispatchers are configured.

  D. It is enabled and all the DBA and non-DBA sessions function in shared server mode.

  Correct Answer: A

  Reference: https://docs.oracle.com/cd/E71588_01/HTMIG/configuring-SHARED-SERVERSparameter.htm#HTMIG29492

• Question 30:

  You issue the following commands:

  

  The directories '/u0l/app/oracle/oradata/orcl' and '/u0l/app/oracle/mydata' exist.

  Which statement describes the outcome?

  A. The AUGUST_SALES tablespace is created with its data file in the DB_CREATE_FILE_DEST location and the TEMP101 tablespace is created with its temp file in the '/u01/app/oracle/mydata' location.

  B. The TEMP101 tablespace is created with its temp file in the DB_CREATE_FILE_DEST location and the AUGUST_SALES tablespace is created with its data file in the '/u01/app/oracle/mydata/ mysales.dbf' location.

  C. The two tablespaces are created with the data file and temp file in their respective locations as specified in the CREATE commands.

  D. Tablespace creation ignores the data file and temp file locations specified in the CREATE commands, and creates both the tablespaces in the DB_CREATE_FILE_DEST location.

  Correct Answer: C