1z1-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 Bixby's schema
• B.CUST_RECORDS table in Murdok's schema
• 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 the schema of Bixby and Rlayton

Which three statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.)

• A.It analyzes only the components and waits that are impacting database performance.
• B.It analyzes only those memory components of the database instance that are impacting performance.
• C.It determines SQL statements that are performing poorly.
• D.It analyzes the performance of the database instance based on the latest two AWR snapshots.
• E.It determines the segments on which waits are occurring when the database has a high number of buffer busy waits.
• F.It recommends implementing SQL profiles to generate better execution plans.

Which two are true about the ADR retention advisor in Oracle Database 12c Release 2? (Choose two.)

• A.ESTIMATE (SHORTP_POLICY = 192) estimates the space requirement based on the SHORTP_POLICY value of 192 minutes.
• B.ESTIMATE (SIZEP_POLICY = 209715200) estimates only the long retention policy.
• C.ESTIMATE (SIZEP_POLICY = 209715200) estimates the value of LONGP_POLICY.
• D.ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 2160) estimates the space requirement based on current ADR diagnostics file space usage.
• E.ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 8760) provides estimates that users can use to set SIZEP_POLICY.

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

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

You set the maximum size of the diagnostic collection repository by issuing this command as root.tfact1 set reposizeMB=5120 You then notice that the current repository size is 5 GB and that old files are not being purged.
Which statement is true?

• A.TFA does not collect new diagnostic data when the maximum repository size is reached.
• B.The tfact1 command fails because it can be set only by the Oracle software owner.
• C.TFA collects new diagnostic data but logs a warning message.
• D.TFA collects new diagnostic data if the Max Size of TFA Log parameter value is greater than 5 G
• E.TFA collects new diagnostic data while the repository directory's file system has free space.