Oracle 1Z0-063 Online Practice Questions and Exam Preparation

Oracle 1Z0-063 Online Questions & Answers

• Question 161:

  You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted. Identify two methods to recover the temp file with the least disruption to database availability. (Choose two.)

  A. Drop the TEMP tablespace, and then re-create it with new temp files.
  B. Restart the database instance to create the temp file automatically.
  C. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.
  D. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is corrupted.
  B. Restart the database instance to create the temp file automatically.
  C. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.

• Question 162:

  You take your database backups by using the RMAN media management interface (MMI).

  Which two are true about the use of the RMAN MMI? (Choose two.)

  A. You can use it to create image copies for entire file systems.
  B. You can use it to create image copies for database files.
  C. You can use it to create backup sets for database files.
  D. You can use it to create proxy copies for database files.
  E. You can use it to create proxy copies for entire file systems.
  B. You can use it to create image copies for database files.
  C. You can use it to create backup sets for database files.

• Question 163:

  You issued these commands for one of your databases:

  RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;

  RMAN> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING

  FILE `/mydir/rman_change_track.f';

  RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

  Which two are true? (Choose two.)

  A. The cumulative incremental level 1 database backup ignores the block change tracking file.
  B. Future cumulative incremental level 1 database backups will reference the block change tracking file.
  C. Future incremental level 0 database backups will reference the block change tracking file.
  D. The cumulative incremental level 1 database backup fails.
  E. The block change tracking file will be updated automatically after creation to refer to modified blocks contained in the incremental level 0 database backup.
  B. Future cumulative incremental level 1 database backups will reference the block change tracking file.
  E. The block change tracking file will be updated automatically after creation to refer to modified blocks contained in the incremental level 0 database backup.

• Question 164:

  Which two statements are true about tablespaces in multitenant container databases (CDBs)? (Choose two.)

  A. Default permanent tablespaces can be shared across pluggable databases (PDBs).
  B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.
  C. Each PDB can have its own default temporary tablespace.
  D. The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.
  E. The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.
  B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.
  C. Each PDB can have its own default temporary tablespace.

• Question 165:

  Which two operations are NOT performed by the DUPLICATE command in RMAN while duplicating a database that is open? (Choose two.)

  A. creating a control file for the duplicate database
  B. restoring target data files to the duplicate database
  C. performing complete recovery by using all available backups
  D. generating a new, unique database identifier (DBID) for the duplicate database
  E. copying online redo log files from the target database to the duplicate database
  C. performing complete recovery by using all available backups
  E. copying online redo log files from the target database to the duplicate database

• Question 166:

  You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges.

  The statistics_level parameter is PDB modifiable.

  As the user sys, execute the following command on pdb2:

  SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;

  Which statement is true about the result of this command?

  A. The statistics_level parameter is set to all when any of the PDBs is reopened.
  B. The statistics_level parameter is set to all only for PDB2 when it is reopened.
  C. The statistics_level parameter is set to all when the root database is restarted.
  D. The statement is ignored because there is no SPFILE for a PDB.
  B. The statistics_level parameter is set to all only for PDB2 when it is reopened.

• Question 167:

  Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start?

  A. from the last complete checkpoint position
  B. from the beginning of the current redo log file until the instance failure
  C. from the last committed transaction
  D. from the beginning of the current redo log file to the checkpoint position
  E. from the most recent incremental checkpoint
  E. from the most recent incremental checkpoint

• Question 168:

  As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database. Which step should you perform next to start the upgrade of the database?

  A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.
  B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
  C. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
  D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.
  B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.

• Question 169:

  You created a database with DBCA by using one of the Oracle supplied templates. Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

  A. USERS
  B. SYSTEM
  C. SYSAUX
  D. EXAMPLE
  B. SYSTEM

• Question 170:

  Examine the command and its output:

  SQL> DROP TABLE EMPLOYEE;

  SQL> SELECT object_name AS recycle_name, original_name, type

  FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE

  binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE

  You then successfully execute the command:

  SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;

  Which two statements are true? (Choose two.)

  A. It flashes back the employee table and all the constraints associated with the table.
  B. It automatically flashes back all the indexes on the employees table.
  C. It automatically flashes back any triggers defined on the table.
  D. It flashes back only the structure of the table and not the data.
  E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.
  A. It flashes back the employee table and all the constraints associated with the table.
  C. It automatically flashes back any triggers defined on the table.