1z0-074 試験問題を無料オンラインアクセス

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 the schema of Bixby, Rlayton, and Murdok
• B.CUST_RECORDS table in the schema of Bixby and Rlayton
• C.CUST_RECORDS table in Bixby's schema
• D.CUST_RECORDS table in Murdok's schema
• E.CUST_RECORDS table in Rlayton'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 not encrypted anywhere.
• B.User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in an on-premise database.
• C.TEMP and UNDO tablespaces are transparently encrypted with AES128 by default only in the cloud.
• D.TEMP and UNDO tablespaces are transparently encrypted with AES128 by default in an on-premise database.
• E.User tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are transparently encrypted with AES128 only in the cloud.

Which three tasks are performed automatically by Database Upgrade Assistant (DBUA) when the database to be upgraded is in archivelog mode and has the database flashback feature enabled? (Choose three.)

• A.It changes Oracle kernel parameters if required
• B.It automatically resets the COMPATIBLE parameter value to 12.0.0
• C.It drops all the invalid objects
• D.It creates a restore point to restore the database if the upgrade fails
• E.It modifies or creates new tablespaces as required
• F.It calls the catctl.pl script to perform the upgrade process in parallel

Which three statements are true about the deferred invalidation clause in DDL statements? (Choose three.)

• A.It cannot be used for bitmap index creation.
• B.It defers invalidating dependent cursor when possible.
• C.It cannot be used for creating a secondary index on index organized tables
• D.The CURSOR_INVALIDATION parameter always overrides the deferred invalidation clause.
• E.It always overrides the CURSOR_INVALIDATION setting.

You create a new application container, SALES_APP, with application PDBs, SALES1_PDB, and SALES2_PDB.
You want to install the NEW_APP application in SALES1_PDB and SALES2_PDB by using:

Where should you execute these statements?

• A.BEGIN/END INSTALL statements should be executed in the CDB root and the SYNC statement in the application root.
• B.BEGIN/END INSTALL statements should be executed in the application root and the SYNC statement in SALES1_PDB and SALES2_PDB.
• C.All the statements should be executed in the application root.
• D.All the statements should be executed in the SALES1_PDB and SALES2_PDB application containers.
• E.All the statements should be executed in the application seed.