Pluggable databases (PDBs). You are connected to cdb$root as the sysuser.

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?

ASMCMD>md_backup /backup/ASM_backup

In which three situations can you use the backup?

Contains multiple pluggable databases (PDBs), is started up by using the command:

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?

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_prlce 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?

The list of steps that might be used to accomplish this task:

(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.

RMAN backup to a specified point in time.

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.

Databases (PDB plans) in a multitenant container database (CDB)?