Online Access Free 1z0-074 Practice Test

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 Murdok's schema
• C.CUST_RECORDS table in Rlayton's schema
• D.CUST_RECORDS table in the schema of Bixby and Rlayton
• E.CUST_RECORDS table in Bixby's schema

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 (SHORTP_POLICY = 192, LONGP_POLICY = 2160) estimates the space requirement based on current ADR diagnostics file space usage.
• C.ESTIMATE (SIZEP_POLICY = 209715200) estimates only the long retention policy.
• D.ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 8760) provides estimates that users can use to set SIZEP_POLICY.
• E.ESTIMATE (SIZEP_POLICY = 209715200) estimates the value of LONGP_POLICY.

Which two statements are true about the In-Memory (IM) column store? (Choose two.)

• A.IM area size is not controlled by Oracle Automatic Memory Management
• B.IM area size can be increased or decreased dynamically
• C.It may be used for columns in Index Organized Tables (IOTs)
• D.It may be used for columns in clustered tables
• E.IM area size can be set at the CDB and PDB levels
• F.It is not used for partitioned tables

Which statement is true about Trace File Analyzer (TFA) Collector?

• A.If TFA is installed on any cluster node, it automatically collects diagnostic data on all other cluster nodes.
• B.It is used to collect diagnostic data only for ORA-600, ORA-7445, and ORA-4031 events.
• C.In Oracle 12c Release 2, TFA installation can be done only while executing root.sh.
• D.TFA collects diagnostic data only for Oracle 12c Release 2 databases or later versions.
• E.It can be used to collect diagnostic data for predefined events, and can be configured to automatically collect data for other events.

Which two statements are true about application containers? (Choose two.)

• A.The application root stores user-created common objects and Oracle-supplied common objects.
• B.User-created common objects are accessible from the CDB root.
• C.An application root can be unplugged from a CDB and plugged in to another CD
• D.A regular PDB can be plugged in to an application container provided it is an Oracle Database 12c Release 2 (12.2) PDB.
• E.An application PDB can belong to multiple application containers.
• F.Multiple application roots can be created in one container database.