Download Oracle Database 12c-Advanced Administration.braindumps.1z0-063.1e.141q.vcex

Download Dump

File Info

Exam Oracle Database 12c: Advanced Administration
Number 1z0-063
File Name Oracle Database 12c-Advanced Administration.braindumps.1z0-063.1e.141q.vcex
Size 1.09 Mb
Posted December 22, 2018
Downloads 27

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.


With discount: 20%

Demo Questions

Question 1
Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost. 
Examine the steps to restore the SPFILE and the control file to mount the database:
Set DBID of the target database in RMAN. 
Start the database instance by using the startup force nomount command in RMAN. 
Restore the control files from the backup. 
Mount the database. 
Restore the SPFILE from the autobackup. 
Create a PFILE from the recovered SPFILE. 
Restart the instance in nomount state. 
Identify the required steps in the correct order.

  • A: 1, 2, 5, 3, 6, 4
  • B: 1, 2, 3, 5, 6, 4
  • C: 2, 1, 5, 7, 3, 4
  • D: 2, 1, 5, 6, 7, 4, 3

Question 2
After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:

PL/SQL procedure successfully completed. 
SQL> select number_value from redaction_values_for_type_full; 

After changing the value, you notice that FULL redaction continues to redact numeric data with a zero. 
What must you do to activate the new default value for numeric full redaction?

  • A: Re-enable redaction policies that use FULL data redaction.
  • B: Re-create redaction policies that use FULL data redaction.
  • C: Re-connect the sessions that access objects with redaction policies defined on them.
  • D: Flush the shared pool.
  • E: Restart the database instance.

Question 3
You want to create a guaranteed restore point for your database by executing the command:

Identify two prerequisites for the successful execution of this command. (Choose two.)

  • A: The database must be running in archivelog mode.
  • B: Flashback Database must be enabled.
  • C: Fast Recovery Area must be enabled.
  • D: The recyclebin must be enabled for the database.
  • E: Undo retention guarantee must be enabled.
  • F: A database backup must be taken.

Question 4
Your database has a table CUSTOMERS that contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS. 
Examine the commands executed and their output:


Why is it that only one update is listed by the Flashback Version Query?

  • A: Supplemental logging is not enabled for the database.
  • B: The undo data that existed for versions of rows before the change to the table structure is invalidated.
  • C: The DB_FLASHBACK_RETENTION_TARGET parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.
  • D: Undo retention guarantee is not enabled.
  • E: Flashback Data Archive is full after the first update statement.

Question 5
Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)? (Choose two.)

  • A: Use the DBMS_PDB package to plug the Oracle 11g database into the existing CDB as a PDB.
  • B: Use the CREATE DATABASE ... ENABLE PLUGGABLE DATABASE statement to create a PDB by copying data files from PDB$SEED and use data pump to load data from the Oracle 11g database into the newly created PDB.
  • C: Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.
  • D: Pre-create a PDB in CDB and use the NETWORK_LINK and PARALLEL parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.
  • E: Upgrade the Oracle 11g database to a 12c non-CDB and use the DBMS_PDB.DESCRIBE procedure to plug the database as a new PDB into the CDB.

Question 6
In which three scenarios is media recovery required? (Choose three.)

  • A: when a tablespace is accidentally dropped from a database
  • B: when archived redo log files are lost
  • C: when data files are lost
  • D: when one of the online redo log members is corrupted
  • E: when all control files are lost

Question 7
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old; 

Which statement is true?

  • A: The tablespace will be renamed but the data file headers will not be updated.
  • B: The statement will fail because you cannot rename an undo tablespace.
  • C: The tablespace will be renamed and all the changes will be logged in the alert log.
  • D: The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.
  • E: You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.

Question 8
Which two statements are true about dropping a pluggable database (PDB)? (Choose two.)

  • A: A PDB must be in mount state or it must be unplugged.
  • B: The data files associated with a PDB are automatically removed from disk.
  • C: A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.
  • D: A PDB must be in closed state.
  • E: The backups associated with a PDB are removed.
  • F: A PDB must have been opened at least once after creation.

Question 9
On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:
S>sqlldrhr/[email protected] table=employees 

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

  • A: It succeeds with default settings if the employees table exists in the hr schema.
  • B: It fails because no SQL*Loader data file location is specified.
  • C: It fails if the hr user does not have the create any directory privilege.
  • D: It fails because no SQL*Loader control file location is specified.
  • E: It succeeds and creates the employees table in the HR schema.

Question 10
Which three RMAN persistent settings can be set for a database? (Choose three.)

  • A: backup retention policy
  • B: default backup device type
  • C: default section size for backups
  • D: default destinations for backups
  • E: multiple backup device types for a single backup



You can buy ProfExam with a 20% discount..

Get Now!


Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen


Use VCE Exam Simulator to open VCE files