Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 91:

  Examine the output:

  SQL > ARCHIVE LOG LIST Database log mode Archive Mode Automatic archival Enabled Archive Destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 376 Next log sequence to archive 378 Current log sequence 378

  Which three types of files are automatically placed in the fast recovery area? (Choose three.)

  A. Flashback data archives (FDA)

  B. Archived redo log files

  C. Control file autobackups

  D. Server parameter file (SPFILE)

  E. Recovery Manager (RMAN) backup pieces

  Correct Answer: BCE

  Reference: http://docs.oracle.com/cd/E11882_01/backup.112/e10642/glossary.htm#BRADV526

• Question 92:

  In a database supporting an OLTP workload, tables are frequently updated on both key and non-key columns.

  Reports are also generated by joining multiple tables.

  Which table organization or type would provide the best performance for this hybrid workload?

  A. heap table with a primary key index

  B. external table

  C. hash clustered table

  D. global temporary table

  E. index clustered table

  Correct Answer: E

• Question 93:

  In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.

  What precaution must you take for the read-only tablespaces before performing an incomplete recovery?

  A. All the read-only tablespaces should be taken offline.

  B. All the read-only tablespaces should be restored separately.

  C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.

  D. All the read-only tablespaces should be made online with logging disabled.

  Correct Answer: A

• Question 94:

  Examine the RMAN commands executed in your database:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

  RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET;

  RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

  You issue the command:

  RMAN> BACKUP DATABASE;

  Which two statements are true about the command? (Choose two.)

  A. It performs a log switch.

  B. It creates compressed backup sets by using binary compression by default.

  C. It backs up only the used blocks in data files.

  D. It backs up data files, the control file, and the server parameter file.

  E. It creates a backup of only the control file whenever the database undergoes a structural change.

  Correct Answer: CD

• Question 95:

  Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

  A. The PDB is closed and the temp file is re-created automatically when the PDB is opened.

  B. The PDB is closed and requires media recovery at the PDB level.

  C. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.

  D. The PDB does not close and starts by using the default temporary tablespace defined for the CD.

  Correct Answer: C

• Question 96:

  You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

  

  Which statement is true about the execution of the last command?

  A. It succeeds and displays all the tablespaces that belong to the root database.

  B. It fails and returns an error because a connection is not made by using the sysdba privilege.

  C. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.

  D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.

  Correct Answer: C

• Question 97:

  Examine the RMAN command: Which statement is true about the command?

  

  A. It creates compressed backup sets.

  B. It uses asynchronous I/O for the backup.

  C. It uses parallelization for the backup set.

  D. It uses multisection backup.

  Correct Answer: C

  stands for Serial Backup Tape.

  Configuring Parallel Channels for Disk and SBT Devices

  The number of channels available for a device type when you run a command determines whether RMAN

  reads or writes in parallel. As a rule, the number of channels used in executing a command should match

  the number of devices accessed.

  For tape backups, allocate one channel for each tape drive.

  References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 56

• Question 98:

  You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases

  (PDBs). As the sys user on cdb$root, you execute the commands:

  SQL> CREATE USER C##ADMIN IDENTIFIED BY orcl123;

  SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL;

  SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;

  Which two statements are true about the c##admin user that is created in all PDBs? (Choose two.)

  A. It can create only local users in all the PDBs.

  B. It has a common schema for all the PDBs.

  C. It can create common users only when it is logged in to the CDB.

  D. It can create only local users in the CDB.

  E. It can be granted only common roles in the PDBs.

  Correct Answer: AC

• Question 99:

  View the SPFILE parameter settings in the Exhibit.

  

  You issue this command and get errors:

  SQL> startup ORA-00824:cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information

  Why did the instance fail to start?

  A. because pga_aggregate_target is not set

  B. because statistics_level is set to basic

  C. because memory_target and memory_max_target cannot be equal

  D. because sga_target and memory_target are both set

  Correct Answer: B

• Question 100:

  Which three requirements must be met before a tablespace can be transported across different platforms? (Choose three.)

  A. Both the source and target databases must use the same character set.

  B. The platforms of both the source and target databases must have the same endian format.

  C. The compatible parameter value must be the same in the source and target databases.

  D. The minimum compatibility level for both the source and target databases must be 10.0.0.

  E. The tablespace to be transported must be in read-only mode.

  Correct Answer: ADE