QUESTION: 13

Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):
SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123;
SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;
SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL;
SQL> REVOKE c##role1 FROM c##a_admin;
What is the result of the revoke command?

It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.
It fails and reports an error because the container=all clause is not used.
It executes successfully and the c##rocl1role is revoked from the c##a_adminuser in the root database and all the PDBs.
It fails and reports an error because the comtainer=currentclause is not used.

Answer(s): C

Show Answer Next Question

QUESTION: 14

Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?

The password for the encryption must be set up.
Oracle wallet for the encryption must be set up.
All the tablespacesin the database must be encrypted.
Oracle Database Vault must be enabled.

Answer(s): C

Reference:

http://docs.oracle.com/cd/E25054_01/backup.1111/e10642/rcmbckad.htm#CEGEJABH

Show Answer Next Question

QUESTION: 15

A database is running in archivelog mode. The database contains locally managed tablespaces.
Examine the RMAN command:
RMAN> BACKUP
AS COMPRESSED BACKUPSET
SECTION SIZE 1024M
DATABASE;
Which statement is true about the execution of the command?

The backup succeeds only if all the tablespaces are locally managed.
The backup succeeds only if the RMAN default device for backup is set to disk.
The backup fails because you cannot specify section size for a compressed backup.
The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB.

Answer(s): D

Show Answer Next Question

QUESTION: 16

In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?

The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
Setting the target tablespace to read-only after the segments are moved
The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used
Taking the target tablespace offline after the segments are moved
The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

Answer(s): A,B

Show Answer Next Question

Free Oracle 1Z0-067 Exam Questions (page: 5)

QUESTION: 13

QUESTION: 14

Reference:

QUESTION: 15

QUESTION: 16

1Z0-067 Exam Discussions & Posts