Free Access Oracle.1z0-063.v2022-10-18.q151 Practice Test (Page 12)

Question 51

One of your container databases (CDBs) has five pluggable databases (PDBs).
COMMON_USER_PREFIXis C##.
These commands executed successfully while connected as SYSto CDB$ROOT:
SQL> CREATE USER c##dba_admin IDENTIFIED BY orcl123;
SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO c##role1 CONTAINER=ALL;
SQL> GRANT c##role1 TO c##dba_admin CONTAINER=ALL;
SQL> GRANT c##role1 to system CONTAINER=ALL;
Which three are true? (Choose three.)

A.The c##role1role will always have the same privileges in all current and future PDBs.

B.SYSTEMis able to create views in any PDB as a result of being granted the C##ROLE1role.

C.The C##DBA_ADMIN user is able to create views in any PDB as a result of being granted the C##ROLE1 role.

D.The C##DBA_ADMINuser is a local user in CDB$ROOTand PDB$SEED.

E.The C##DBA_ADMINuser is a local user in CDB$ROOT.

F.SYSTEMis able to create views in any PDB as a result of being a DBA user.

Question 52

Which two are prerequisites for performing Flashback Transaction? (Choose two.)

A.A supplemental log must be enabled for the primary key.

B.Row movement must be enabled.

C.The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.

D.Undo retention guarantee must be configured for the database.

E.Fast Recovery Area must be enabled for the database.

Question 53

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)?

A.tracking the most recent write time for each block in a table segment

B.tracking the most recent write time for a table segment in the sysauxtablespace

C.tracking the most recent read time for a table segment in the sysauxtablespace

D.tracking the most recent write time for a table segment in a user tablespace

E.tracking insert time by row for table rows

F.tracking the most recent read time for a table segment in a user tablespace

Question 54

Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):

Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?

A.The command succeeds and the common user c##admin can create a session and query the DBA_users view in cdb$root and all the PDBs.

B.The command fails and gives an error because object privileges cannot be granted to a common user.

C.The command succeeds and the common user c##admin can create a session in cdb$root and all the PDBs, but can only query the dba_users view in cdb$root.

D.The command fails because container is not set to current.

E.The command succeeds and the common user c##admin can create a session and query the DBA_users view only in cdb$root.

Question 55

Which two statements are true about a common user?

A.A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

B.A common user can have a local schema in a PDB.

C.A common user with the create user privilege can createother common users, as well as local users.

D.A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.

E.A common user can be granted only a common role.

Other Version: 3059Oracle.1z0-063.v2022-04-21.q171

Latest Upload: 110Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 156TheSecOpsGroup.CNSP.v2025-09-08.q20; 207CFAInstitute.ESG-Investing.v2025-09-08.q173; 155PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 144Salesforce.Data-Architect.v2025-09-05.q216; 136Adobe.AD0-E605.v2025-09-05.q50; 177Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 51

Question 52

Question 53

Question 54

Question 55

Download PDF File