Online Access Free 1Z1-060 Practice Test

Identify two valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

• A.Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.
• B.Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB.
• C.Use the DBMS_PDB package to clone an existing PDB.
• D.Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.
• E.Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.

To complete the online redefinition procedure, you execute the following command; EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE(`SH', `SALES',
`INT_SALES', 600);
What is the significance of the dml_lock_timeout period of 600 seconds in the preceding command?

• A.It specifies the number of seconds the procedure waits for its required locks before it ends gracefully.
• B.All pending DML statements on the SALES_INT table must be committed 600 seconds before the procedure ends gracefully.
• C.All pending DML statements on the SALES table must be committed 600 seconds before the procedure ends gracefully.
• D.All pending DML statements on the SALES table will wait for 600 seconds before the procedure ends gracefully.

To implement Automatic Management (AMM), you set the following parameters:

When you try to start the database instance with these parameter settings, you receive the following error message:

Identify the reason the instance failed to start.

• A.The STATISTICS_LEVEL parameter is set to BASIC.
• B.The PGA_AGGREGATE_TARGET parameter is set to zero.
• C.The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.
• D.Both the SGA_TARGET and MEMORY_TARGET parameters are set.

In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:

Which two statements are true?

• A.The C # # ROLE1 role is created in the root database and all the PDBs.
• B.Privileges are granted to the C##A_ADMIN user only in the root database.
• C.The statement for granting a role to a user fails because the CONTAINER clause is not used.
• D.Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
• E.The C # # ROLE1 role is created only in the root database because the container clause is not used.

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to Issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?

• A.Place the root container in the nomount stage.
• B.Place the root container in ARHCHIVELOG mode.
• C.Ensure that HR_PDB is open.
• D.Take the user data tablespace offline.