Examine the command and its output: 

SQL>show parameter file 

NAME TYPE VALUE 

----------------------------------------------------------------------- 

db_create_file_dest string 

db_file_name_convert string 

db_files integer 200 

You verify that sufficient disk space is available and that no file currently exists in the ‘/u0l/app/oracle/oradata/cdb1/salesdb’ location. 

You plan to create a new pluggable database (PDB) by using the command: 

SQL>CREATE PLUGGABLE DATABASE SALESPDB 

ADMIN USER salesadm IDENTIFIED BY password ROLES=(dba) 

DEFAULT TABLESPACE sales 

DATAFILE '/u01/app/oracle/oradata/cdb1/salesdb/sales01.dbf’ SIZE 250M AUTOEXTEND 

ON 

FILE_NAME_CONVERT=(‘/u01/app/oracle/oradata/cdb1/pdbseed/', 

'/u01/app/oracle/oradata/cdb1/salesdb/') 

STORAGE(MAXSIZE 2G) 

PATH_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB'; 

Which statement is true?

You execute the commands: 

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 statement is true about the c##connect role? 

$expdp SYSTEM FULL=Y DUMPFILE=dpump_dir1:full1%U.dmp, dpump_dir2:full2% U.dmp, 

dpump_dir3:full3%U.dmp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull 

Which statement is true about the execution of the command?

One of the data files is corrupted and the current online redo log file is lost because of a media failure. You want to recover the data file. 

Examine the steps involved in the recovery process: 

1. Shut down the database instance. 

2. Start up the database instance in nomount state. 

3. Mount the database. 

4. Take the data file offline. 

5. Put the data file online. 

6. Restore the controlfile. 

7. Restore the database. 

8. Restore the data file. 

9. Open the database with the resetlogs option. 

10.Recover the database with the no redo option. 

11. Recover the data file with the no redo option. 

Identify the required steps in the correct order. 

SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1 

FILE_NAME_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/’) 

PATH_PREFIX= '/disk2/oracle/pdb2'; 

Which two statements are true? 

RMAN> BACKUP VALIDATE DATABASE; 

RMAN> RECOVER CORRUPTION LIST; 

Which task is performed by these commands? 

ASMCMD>md_backup /backup/ASM_backup 

In which three situations can you use the backup? 

SQL>STARTUP 

Which two statements are true about the successful execution of the command? 

You execute the command to create a common user: 

SQL> CREATE USER c##a_admin IDENTIFIED BY password DEFAULT TABLESPACE users QUOTA 100M ON users TEMPORARY TABLESPACE temp; 

Which statement is true about the execution of the command? 

What is the easiest way to perform capacity planning for consolidation? 

Which three actions would you take to improve backup performance? 

CREATE TABLE purchase_orders 

(po_id NUMBER(4), 

po_date TIMESTAMP, 

supplier_id NUMBER(6), 

po_total NUMBER(8,2), 

CONSTRAINT order_pk PRIMARY KEY(po_id)) 

PARTITION BY RANGE(po_date) 

(PARTITION Q1 VALUES LESS THAN (TO_DATE('01-apr-2007','dd-mon-yyyy')), 

PARTITION Q2 VALUES LESS THAN (TO_DATE('01-jul-2007','dd-mon-yyyy')), 

PARTITION Q3 VALUES LESS THAN (TO_DATE('01-oct-2007','dd-mon-yyyy')), 

PARTITION Q4 VALUES LESS THAN (TO_DATE('01-jan-2008','dd-mon-yyyy'))); 

CREATE TABLE purchase_order_items 

( po_id NUMBER(4) NOT NULL, 

product_id NUMBER(6) NOT NULL, 

unit_price NUMBER(8,2), 

quantity NUMBER(8), 

CONSTRAINT po_items_fk FOREIGN KEY(po_id) REFERENCES purchase_orders(po_id)) 

PARTITION BY REFERENCE (po_items_fk); 

Which two statements are true? 

1. Place all user-defined tablespaces in read-only mode on the source database. 

2. Use the RMAN convert command to convert data files to the target platform's endian format, if required. 

3. Perform a full transportable export on the source database with the parameters 

VERSI0N=I2, TRANSPORTABLE=ALWAYS, and FULL=Y. 

4. Transport the data files for all the user-defined tablespaces. 

5. Transport the export dump file to the target database. 

6. Perform an import on the target database by using the full, network_link, and 

transportable_datafiles parameters. 

7. Perform an import on the target database by using the full and transportable_datafiles parameters. 

Identify the required steps in the correct order. 

Examine the steps to recover this table from an RMAN backup: 

1. Determine which backup contains the table that needs to be recovered. 

2. Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified. 

3. Import the Data Pump export dump file into the auxiliary instance. 

4. Create a Data Pump export dump file that contains the recovered table on a target database. 

Identify the required steps in the correct order. 

Examine the initialization parameters you plan to set for your database instance. 

LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' 

LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/arch' 

LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch' 

L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/arch MANDATORY' 

Identify the statement that correctly describes these settings. 

Identify two prerequisites for the successful execution of this command.