Oracle 1z1-074 Actual Free Exam Questions & Community Discussion
Which two statements are true about the In-Memory (IM) column store? (Choose two.)
Correct Answer: C,F
Vote an answer
Examine these steps to create a Transparent Sensitive Data Protection (TSDP) policy with unified auditing to protect sensitive data in certain table columns:
* Create a TSDP policy and define the audit parameter for the audited columns.
* Create a TSDP sensitive type using DBMS_TSDP_MANAGE.ADD_SENSITIVE_TYPE.
* Associate the TSDP policy with the sensitive type by using
DBMS_TSDP_PROTECT.ASSOCIATE_POLICY.
* Enable the TSDP policy at the sensitive type level.
* Associate the column to be audited to the sensitive type by using
DBMS_TSDP_MANAGE.ADD_SENSITIVE_COLUMN.
Identify the steps in the correct sequence.
* Create a TSDP policy and define the audit parameter for the audited columns.
* Create a TSDP sensitive type using DBMS_TSDP_MANAGE.ADD_SENSITIVE_TYPE.
* Associate the TSDP policy with the sensitive type by using
DBMS_TSDP_PROTECT.ASSOCIATE_POLICY.
* Enable the TSDP policy at the sensitive type level.
* Associate the column to be audited to the sensitive type by using
DBMS_TSDP_MANAGE.ADD_SENSITIVE_COLUMN.
Identify the steps in the correct sequence.
Correct Answer: B
Vote an answer
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?
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?
Correct Answer: E
Vote an answer
Which two statements are true about a PDB lockdown profile? (Choose two.)
Correct Answer: A,D
Vote an answer
You plan to use Information Lifecycle Management (ILM) for the ORDERS table.
Which is true about Heat Map statistics when HEAT_MAP is ON?
Which is true about Heat Map statistics when HEAT_MAP is ON?
Correct Answer: B
Vote an answer
You want to partition the SALES table on the CITY and SALE_DATE columns.
Which three partitioning methods can you use? (Choose three.)
Which three partitioning methods can you use? (Choose three.)
Correct Answer: B,C,D
Vote an answer
HR.EMP.EMPLOYEE_ID is the primary key of the HR.EMP partitioned table, which contains 108 rows and resides in the EXAMPLE tablespace.
HR executes this command:
SQL> CREATE TABLE employees TABLESPACE users FOR EXCHANGE WITH TABLE hr.emp; Table created.
Which two statements are true? (Choose two.)
HR executes this command:
SQL> CREATE TABLE employees TABLESPACE users FOR EXCHANGE WITH TABLE hr.emp; Table created.
Which two statements are true? (Choose two.)
Correct Answer: A,E
Vote an answer
You execute this command in your database:
ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL;
How does this affect the creation of tablespaces?
ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL;
How does this affect the creation of tablespaces?
Correct Answer: B
Vote an answer
0
0
0
10