CertsTopics Logo

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Changed 1z0-067 Exam Questions

Page: 2 / 10
Total 263 questions
Get 1z0-067 Full Access Download 1z0-067 PDF

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP Questions and Answers

Question 5

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands:

SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23;

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?

Options:

A.

It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.

B.

It is granted to the c##admin user only in the CDB.

C.

It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.

D.

It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

Question 6

ENCRYPT_TS is an encrypted tablespace that contains tables with data.

Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

Options:

A.

The data is decrypted during SORT and JOIN operations.

B.

The data remains encrypted when it is read into memory.

C.

The data remains encrypted when it is stored in the redo logs

D.

The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

Question 7

Which two are prerequisites for setting up Flashback Data Archive?

Options:

A.

Fast Recovery Area should be defined.

B.

Undo retention guarantee should be enabled.

C.

Supplemental logging should be enabled.

D.

Automatic Undo Management should be enabled.

E.

All users using Flashback Data Archive should have unlimited quota on the Flashback Data Archive tablespace.

F.

The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.

Question 8

Which three statements are true about Scheduler Windows? (Choose three.)

Options:

A.

Only one window can be open at one time.

B.

Consumer groups are associated with windows.

C.

Windows work with job classes to control resource allocation.

D.

A database service name must be provided during window creation.

E.

The Resource Manager can automatically start windowed jobs or change resource allocation among windowed jobs.

Page: 2 / 10
Total 263 questions
Get 1z0-067 Full Access Download 1z0-067 PDF