Oracle 1Z0-074 Online Practice Questions and Exam Preparation

Oracle 1Z0-074 Online Questions & Answers

• Question 1:

  Which three resources can be controlled or managed by using Oracle Database Resource Manager? (Choose three.)

  A. number of parallel queries issued by a consumer group
  B. maximum number of DML operations performed by a consumer group
  C. sessions that are blocking other sessions
  D. sessions that are not blocking other sessions
  E. UNDO quota for a consumer group
  A. number of parallel queries issued by a consumer group
  C. sessions that are blocking other sessions
  E. UNDO quota for a consumer group

• Question 2:

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

• Question 3:

  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
  A. The primary key constraints on T1 are dropped
  C. T1 is in the TBS_CMP tablespace
  E. T1 is in uncompressed format

• Question 4:

  Which two statements are true about clean restore points in a regular PDB? (Choose two.)

  A. They require a clone instance to be created when used in a PDB flashback operation
  B. They can be created for a PDB when connected to either the PDB or to the root
  C. They require backups to be restored when used in a PDB flashback operation
  D. They are created as guaranteed restore points
  E. They can be created only if shared undo is enabled
  F. They can be created only for a PDB in the mount state
  E. They can be created only if shared undo is enabled
  F. They can be created only for a PDB in the mount state

  ---

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/using-flasback-database-restore-points.html

• Question 5:

  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.
  A. All their queries display blanks for LAST_NAME and the true contents of the SALARY column.

• Question 6:

  In an Oracle 12c Release 2 database, USER1 has CREATE SESSION, CREATE PROCEDURE, and CREATE FUNCTION privileges. Examine these commands:

  

  SYS executes this command:

  SQL> SELECT add_num(1,2) FROM DUAL;

  What is the result?

  A. An error is returned
  B. The message "The result is 3" only is displayed
  C. TESTDBA is created with the SYSDBA privilege only
  D. Only "3" is displayed
  E. TESTDBA is created will the SYSDBA privilege and the message "The result is 3" is displayed
  C. TESTDBA is created with the SYSDBA privilege only

• Question 7:

  The COMPATIBLE parameter is set to 12.2.0.0.0.

  Which two statements are true about SQL identifier lengths? (Choose two.)

  A. Disk group, PDB, and tablespace names are limited to 30 bytes.
  B. Table names can be as long as 128 bytes.
  C. Database names can be as long as 30 bytes.
  D. Database link names can be as long as 30 bytes.
  E. Database names can be as long as 128 bytes.
  B. Table names can be as long as 128 bytes.
  E. Database names can be as long as 128 bytes.

  ---

  Reference: https://oracle-base.com/articles/12c/long-identifiers-12cr2

• Question 8:

  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)
  B. An AUXILIARY instance is started only if there is sufficient disk space
  E. They may be recovered to a different schema in the same pluggable database (PDB)

  ---

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

• Question 9:

  You execute this command in your database:

  ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL;

  How does this affect the creation of tablespaces?

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

  ---

  Reference: https://blogs.oracle.com/pshuff/database-options-advanced-security

• Question 10:

  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
  C. Grant SYSRAC to ops$user1.