Oracle Oracle Certifications 1Z0-074 Questions & Answers

• Question 11:

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

  A. It defers invalidating dependent cursor when possible.

  B. It cannot be used for bitmap index creation.

  C. The CURSOR_INVALIDATION parameter always overrides the deferred invalidation clause.

  D. It always overrides the CURSOR_INVALIDATION setting.

  E. It cannot be used for creating a secondary index on index organized tables

  Correct Answer: ACE

• Question 12:

  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.

  A. 1, 2, 3, 4, 5

  B. 2, 1, 4, 5, 3

  C. 2, 5, 1, 3, 4

  D. 1, 2, 4, 3, 5

  E. 2, 1, 5, 3, 4

  Correct Answer: C

  Reference: https://docs.oracle.com/database/121/DBSEG/tsdp.htm#DBSEG399

• Question 13:

  In which four situations does the RMAN DUPLICATE command use the "pull" method? (Choose four.)

  A. when the USING BACKUPSET clause is used

  B. when the SET ENCRYPTION clause is added before the DUPLICATE command

  C. when the SECTION SIZE clause is used

  D. when the number of auxiliary channels allocated is less than the number of target channels allocated

  E. when the USING COMPRESSED BACKUPSET clause is used

  F. when no auxiliary channels are allocated

  G. when IMAGE COPIES are used for the DUPLICATE operation

  Correct Answer: ACDE

  Reference: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV299

• Question 14:

  You log in to the ORCL database as SYSTEM and successfully execute these two blocks of code:

  

  The SCOTT user has the SELECT privilege on HR.EMP.

  Which statement is true about queries by non-DBA users with the SELECT privilege on HR.EMP?

  A. All their queries display blanks for LAST_NAME and the true contents of the SALARY column.

  B. Only SCOTT'S queries display the true contents of the SALARY column and blanks for LAST_NAME.

  C. All their queries display blanks for LAST_NAME and zeroes for SALARY.

  D. Only SCOTT'S queries display the true contents of the SALARY and LAST_NAME columns.

  E. Only SCOTT'S queries display zero for SALARY and the true contents of the LAST_NAME column.

  Correct Answer: A

• Question 15:

  Which method can be used to migrate from an on-premises Oracle Database 11g to Oracle Database 12c in the cloud if the on-premises platform is big-endian?

  A. Oracle Loader-type external tables

  B. remote cloning

  C. RMAN Transportable Tablespace with Data Pump for all tablespaces

  D. Data Pump Transportable Tablespace for all tablespaces

  E. Data Pump Conventional Export/Import

  Correct Answer: C

• Question 16:

  You create a refreshable copy PDB, PDB_COPY, from the PDB_ORG PDB by using the REFRESH

  MODE EVERY 5 MINUTES clause.

  What happens every five minutes?

  A. An automatic refresh is done provided PDB_COPY is closed; otherwise the refresh is differed and attempted again after five minutes.

  B. PDB_COPY is automatically closed provided there is no ongoing transaction in PDB_ORG and then reopened as read-only after the refresh is complete.

  C. PDB_COPY'S state is automatically changed to read-write and back to read-only after the refresh is complete.

  D. PDB_COPY'S state is automatically changed to read-only and then reopened as read-write after the refresh is complete.

  E. An automatic refresh is done provided PDB_COPY is in read-only mode; otherwise the refresh is deferred and attempted again after five minutes.

  Correct Answer: E

• Question 17:

  Which two are true about tables recovered by using the RMAN RECOVER TABLE command or the command itself, starting from Oracle Database 12c Release 2? (Choose two.)

  A. They may be recovered to a schema in a different PDB

  B. An AUXILIARY instance is started only if there is sufficient disk space

  C. They can be recovered by RMAN without an AUXILIARY instance

  D. They must be un-partitioned tables

  E. They may be recovered to a different schema in the same pluggable database (PDB)

  Correct Answer: BE

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/rcmrf/RECOVER.html#GUIDCA98040F-9865-4F4F-BAF2-91C518612E95

• Question 18:

  Examine these statements:

  

  Which statement is true?

  A. Statements 2 and 3 will validate the conversion

  B. Only statement 3 will validate the conversion

  C. Only statement 1 will validate the conversion

  D. Statement 1 will return an error

  E. All the statements will validate the conversion

  Correct Answer: B

• Question 19:

  Which two statements are true about FLEX ASM? (Choose two.)

  A. A database instance on any node can connect to an ASM instance on any node.

  B. A separate ASM network is required.

  C. It is impossible to connect to a database instance on one node if the database password file for the same database is corrupt on another node in the cluster.

  D. Database instances that depend on an ASM instance that is terminated fail over to a node that has a surviving ASM instance.

  E. Database instances that depend on an ASM instance that is terminated connect to a surviving ASM instance.

  Correct Answer: DE

• Question 20:

  In a Database Cloud Service (DBCS) environment, which pre-created user has sudo privileges to run certain root commands?

  A. grid

  B. oracle

  C. opc

  D. nobody

  E. oinstall

  Correct Answer: C

  Reference: https://docs.oracle.com/en/cloud/iaas/compute-iaas-cloud/stcsg/accessing-oracle-linuxinstance-using-ssh.html#GUID-D947E2CC-0D4C-43F4-B2A9- A517037D6C11