Online Access Free 1z0-074 Practice Test

Your CDB has a PDB, EMP_PDB.
You successfully execute these commands as the SYSTEM USER in CDB$ROOT:

Which two statements are true about C##USR1? (Choose two.)

• A.It can connect only to the root.
• B.It can connect to EMP_PDB and view the data only in tables created by common users.
• C.It is a local user.
• D.It is a common user.
• E.It can connect to EMP_PDB but cannot view the data in any table in it.

QUERY_REWRITE_INTEGRITY and QUERY_REWRITE_ENABLED are set to TRUSTED and TRUE respectively in an Oracle 12c Release 2 database.
You create the SALES_EVAL real-time materialized view (MV) on the SALES, CUSTOMERS, and PRODUCTS tables, which supports COMPLETE REFRESH by executing these statements.

There is a constraint on the PRODUCTS table with ENABLE, NOVALIDATE, and RELY attributes.
No updates have been done to SALES, CUSTOMERS, or PRODUCTS since the MV was created.
From where are rows returned and why?

• A.from the SALES, CUSTOMERS, and PRODUCTS tables because QUERY_REWRITE_INTEGRITY is set to TRUSTED
• B.from the SALES_EVAL MV because the WHERE clause in the query and in the SALES_EVAL definition are the same
• C.from the SALES_EVAL MV because the QUERY_REWRITE_ENABLED setting permits rewrites on unverified constraints if the table is not stale
• D.from the SALES, CUSTOMERS, and PRODUCTS tables because the columns used in the SELECT list are different from the SALES_EVAL MV definition
• E.from the SALES, CUSTOMERS, and PRODUCTS tables because the column in the GROUP BY clause is different from the SALES_EVAL MV definition

Identify four prerequisites for issuing the RMAN RECOVER TABLE command starting from ORACLE Database 12c Release 2.

• A.The COMPATIBLE parameter must be set to 12.0 or greater.
• B.RMAN must use a recovery catalog.
• C.FLASHBACK DATABASE must be enabled.
• D.An export dump file of the table must be available.
• E.There must be sufficient space to start the auxiliary instance.
• F.The database must be in the READ WRITE state.
• G.RMAN can recover the table only from a backupset.
• H.The database must be in ARCHIVELOG mode.

Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schema.
BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with invoker's right.
BIXBY grants the execute permission on UPDATE_CUST to the RLAYTON user.
When RLAYTON executes the UPDATE_CUST procedure, which table does the procedure attempt to update?

• A.CUST_RECORDS table in Murdok's schema
• B.CUST_RECORDS table in the schema of Bixby and Rlayton
• C.CUST_RECORDS table in Rlayton's schema
• D.CUST_RECORDS table in the schema of Bixby, Rlayton, and Murdok
• E.CUST_RECORDS table in Bixby's schema

You execute this command in your database:
ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL;
How does this affect the creation of tablespaces?

• A.User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in the cloud.
• B.TEMP and UNDO tablespaces are transparently encrypted with AES128 by default only in the cloud.
• C.TEMP and UNDO tablespaces are transparently encrypted with AES128 by default in an on-premise database.
• D.User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are not encrypted anywhere.
• E.User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in an on-premise database.