Oracle Oracle Certifications 1Z0-074 Questions & Answers

• Question 31:

  Which statement is true about policy expressions?

  A. A named policy expression is stored in the Data Masking format library.

  B. A named policy expression applied to a column in a redacted table overrides the default expression of its redaction policy.

  C. A redacted table can have only one policy expression defined on it.

  D. A policy expression can be applied to columns in different redacted tables.

  E. A named policy expression is stored in the Enterprise Manager Database Express repository.

  Correct Answer: C

• Question 32:

  A CDB, CDB1, has a LOCATIONS application container.

  NORTH_PDB and SOUTH_PDB are two application PDBs in LOCATIONS.

  Both application PDBs are synchronized with the application installed in the LOCATIONS root...

  In CDB2, you create a remote clone, LOC_R, of the LOCATIONS application root.

  You want to query data across the LOCATIONS application PDBs created in CDB1 and CDB2.

  How can you do this?

  A. by creating a proxy PDB in LOCATIONS_ROOT in CDB1, referencing LOC_R

  B. by creating a proxy PDB in CDB1 root, referencing LOC_R

  C. by using private database links created in CDB1 and CDB2

  D. by using public database links created in CDB1 and CDB2

  E. by creating a proxy PDB in CDB2 root, referencing LOC_R

  Correct Answer: E

• Question 33:

  U1.T1 is in a tablespace TBS_UNCMP which has no default compression and U1.T2 is in a tablespace,

  TBS_CMP with default compression for query low.

  You execute commands:

  

  Which three statements are true? (Choose three.)

  A. The primary key constraints on T1 are dropped

  B. T1 is in the TBS_UNCMP tablespace

  C. T1 is in the TBS_CMP tablespace

  D. T1 is in compressed format

  E. T1 is in uncompressed format

  F. All indexes on T1 remain valid

  Correct Answer: ACE

• Question 34:

  The EMP_CDB1 and EMP_CDB2 CDBs are in ARCHIVELOG mode.

  Oracle Managed Files is enabled in both CDBs.

  EMP_CDB1 has a PDB, EMP_PDB1.

  In EMP_CDB2, you log in as the SYS user.

  You plan to execute this statement:

  CREATE PLUGGABLE DATABASE emp_pdb2 FROM emp_pdb1@emp_link RELOCATE;

  Which two statements are true? (Choose two.)

  A. The AVAILABILITY MAX clause should be added to the command to ensure transaction consistency during the relocation process.

  B. SYSOPER privilege should be granted to the user defined in EMP_LINK and used to connect to the remote database.

  C. EMP_PDB2 should be opened in read-write mode to complete the relocation process.

  D. EMP_PDB1 should be dropped manually from EMP_CDB1 after executing the relocating command.

  E. EMP_LINK should exist as a public link in EMP_CDB1 and EMP_CDB2.

  F. Only EMP_PDB1 should be in local undo mode.

  Correct Answer: CE

• Question 35:

  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_EVAL MV because the QUERY_REWRITE_ENABLED setting permits rewrites on unverified constraints if the table is not stale

  B. from the SALES, CUSTOMERS, and PRODUCTS tables because QUERY_REWRITE_INTEGRITY is set to TRUSTED

  C. from the SALES, CUSTOMERS, and PRODUCTS tables because the column in the GROUP BY clause is different from the SALES_EVAL MV definition

  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_EVAL MV because the WHERE clause in the query and in the SALES_EVAL definition are the same

  Correct Answer: E

• Question 36:

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

  A. It may be used for columns in Index Organized Tables (IOTs)

  B. It may be used for columns in clustered tables

  C. IM area size is not controlled by Oracle Automatic Memory Management

  D. IM area size can be set at the CDB and PDB levels

  E. IM area size can be increased or decreased dynamically

  F. It is not used for partitioned tables

  Correct Answer: AE

• Question 37:

  You plan to use Information Lifecycle Management (ILM) for the ORDERS table.

  Which is true about Heat Map statistics when HEAT_MAP is ON?

  A. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSTEM tablespace.

  B. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSAUX tablespace.

  C. They are collected for all segments and are stored in the SYSAUX tablespace.

  D. They are collected for all segments and are stored in the SYSTEM tablespace.

  E. They are collected only for the ORDERS table if it has an associated ADO policy.

  Correct Answer: D

• Question 38:

  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.)

  A. Dependent objects of HR.EMP are automatically created for HR.EMPLOYEES.

  B. HR.EMP is moved to the USERS tablespace.

  C. The column names HR.EMP and HR.EMPLOYEES are identical.

  D. The HR.EMPLOYEES table has 108 records.

  E. HR.EMPLOYEES.EMPLOYEE_ID is the PRIMARY KEY of HR.EMPLOYEES

  F. The column order HR.EMP and HR.EMPLOYEES are identical

  Correct Answer: CF

• Question 39:

  You notice a large number of latch: cache buffers lru chain and latch: cache buffers chains wait events.

  Which four might be reasons for these? (Choose four.)

  A. The same small number of blocks are repeatedly accessed by different sessions simultaneously.

  B. The buffer cache is undersized.

  C. Cursors are closed explicitly after each execution.

  D. A large number of connected user sessions are idle.

  E. DBWR is not writing the dirty buffers fast enough.

  F. Blocks are ageing out of the buffer cache frequently.

  G. Too many sort operations are being performed.

  Correct Answer: AEFG

• Question 40:

  USER1 is an OS user with the password oracle and is only a member of the oinstall group. In the ORCL database, the OS_AUTHEN_PREFIX value is ops$.

  Examine these commands executed by the DBA:

  SQL> CREATE USER ops$user1 IDENTIFIED externally;

  SQL> GRANT create session TO ops$user1;

  How can USER1 be given the SYSRAC privilege?

  A. Make User1 a member of the OSDBA group in Linux or the ORA_%HOMENAME%_SYSDBA group in Windows only.

  B. Grant SYSRAC to user1.

  C. Grant SYSRAC to ops$user1.

  D. Make USER1 a member of the OSRACDBA group in Linux or the ORA_%HOMENAME%_SYSRAC group in Windows.

  E. Grant SYSDBA to ops$user1

  Correct Answer: C