ExamDumpster

Free 1z0-063 sample questions

Test your 12c recovery skills with these free 1z0-063 sample questions, all with explained answers. They cover RMAN backups, Flashback and pluggable databases. The exam is retired, so use them as review alongside 1Z0-083.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 10 of 20 free sample questions.

Question 1Choose 3

Which three statements are true about the database instance startup after an instance failure? (Choose three.)

Question 2Choose 3

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

Question 3Choose one

You take regular backups ofone ofyour production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

Question 4Choose 2

Which two statements are true when row-archival management is enabled? (Choose two.)

Question 5Choose 3

One ofyour multitenant container databases (CDB) contains multiple pluggable databases (PDBs). You connect to CDB$ROOT as SYS and execute these commands successfully: SQL) CREATE USER C##ADMIN IDENTIFIED BY orcl123; SQL) CREATE ROLE C##CONNECT; SQL) GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; SQL) GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;Which three are true? (Choose three.)

Question 6Choose 2

Which two statements are true about a multitenant architecture? (Choose two.)

Question 7Choose one

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?

Question 8Choose 3

user_data is a non-encrypted tablespace containing tables with data. You must encrypt all data in this tablespace. Which three methods can do this? (Choose three.)

Question 9Choose 2

You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES: Which two statements are true? (Choose two.)

Question 10Choose 2

You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs DATAFILE Vproddb/data/adtbs.dbf SIZE 10G; The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table. Which two alter statements will achieve this? (Choose two.)

10 more free samples are waiting

Create a free account to unlock the whole 1z0-063 sample bank, or get full access to all 276 practice questions in the simulator.

Create account