Get real exam questions for 1Z0-063 Oracle Database 12c: Advanced Administration. 100% Free.
Q1. Which statement is true aboutthe 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 PDBlevel. C. The PDB does not close and the temp file is re-created automatically whenever the container datab
Q1. Which two statements are true about a common user? A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs. B. A common user with the create user privilege can createother common users, as well as local users. C. A common user can be granted only a common role. D. A common user can have a local schema in a PDB. E. A common user always uses the g
Q1. Which two statements are true regarding the Oracle Data Pump export and import operations? 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. View AnswerAnswer: A,B Reference:http://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_impo
Q1. Which two statements are true about tablespaces in multitenant container databases (CDBs)? 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 table
Q1. Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost. Examine the steps to recover the database: 1.Restore the control filesby using the RMAN restore controlfile command. 2.Mount the database. 3.Restore the data files by using the RMA
Q1. Yourdatabase supports an OLTP workload. Examine the output of the query: SQL> SSLECT target_mttr, estimated_mttr FROM v$instance_recovery Target_mttrestimated_mttr To ensure faster instance recovery, youset the fast_start_mttrjtargh:t initialization parameter to 30. What is the effect of this setting on the database? A. Automatic checkpoint tuning is disabled. B. The frequency of log
Q1. For which three pieces of information can you use the RMAN list command? A. stored scripts in the recovery catalog B. available archived redo log files C. backup sets and image copies that are obsolete D. backups of tablespaces E. backups that are marked obsolete according to the current retention policy View AnswerAnswer: A,B,D Reference:http://docs.oracle.com/cd/B19306_01/backup.102