Oracle Oracle Certifications 1Z0-074 Questions & Answers

• Question 21:

  You create and enable a unified audit policy on a database that has the default auditing configuration.

  

  The OE user, who has the DBA role, executes these statements.

  

  What is true about the SELECT statement and why?

  A. It is audited because unified auditing is disabled be default.

  B. It is audited because, by default, the database is in mixed auditing mode with default policies enabled.

  C. It is audited because, by default, all user activities in the database are audited.

  D. It is not audited because the table belongs to another schema.

  E. It is not audited because audit records are stored only when unified auditing is enabled in the database.

  Correct Answer: C

• Question 22:

  In a database on an Oracle Exadata Database machine, a DBA executes this command:

  SQL> exec DBMS_INMEMORY_ADMIN.ENABLE_FASTSTART (`fs_tbs');

  What is the result?

  A. All columns for all tables in the FS_TBS tablespace are loaded into the In-Memory column store.

  B. Any data in the In-Memory column store is copied in compressed columnar format to the FS_TBS tablespace.

  C. Any data in the In-Memory column store is copied in uncompressed columnar format to the FS_TBS tablespace.

  D. Any data in the In-Memory column store is copied in row major format to the FS_TBS tablespace.

  Correct Answer: A

  Reference: https://docslide.us/download/link/database-in-memory-guide-oracle-help-center-find-anyerrors-please-report-them

• Question 23:

  In your CDB, DEPTCDB, local undo is enabled. You successfully execute this command: FLASHBACK PLUGGABLE DATABASE hrpdb to SCN 424366;

  Which action must you perform next?

  A. Open HRPDB

  B. Take a backup of DEPTCDB

  C. Take a backup of HRPDB

  D. Open HRPDB with RESETLOGS

  E. Open DEPTCDB with RESETLOGS

  F. Open DEPTPDB

  Correct Answer: D

  Reference: http://dbaclass.com/article/performance-flashback-pluggable-databasepdb-oracle-12-2/

• Question 24:

  Your CDB is in ARCHIVELOG mode and has an application container with a container PDB. A backup

  exists for the CDB. When you connect to the container PDB and try to execute a query, you get an error

  that a SYSTEM data file is missing in the container PDB. You want to use the RMAN RESTORE

  DATABASE and RECOVER DATABASE commands to perform the recovery.

  Examine these actions:

  Connect to CDB$ROOT and execute SHUTDOWN ABORT and STARTUP MOUNT.

  Connect to the application container and execute SHUTDOWN ABORT.

  Connect to the application container and execute ALTER PLUGGABLE DATABASE CLOSE ABORT.

  Which option correctly lists the actions that you must execute before performing the recovery?

  A. 1 and 3

  B. 1 and 2

  C. only 2 D. only 3

  Correct Answer: A

• Question 25:

  Which two operations is the opc user authorized to perform in an Oracle Database Cloud environment? (Choose two.)

  A. Log in to the database deployment compute node.

  B. Run some commands as root.

  C. Run all commands as root.

  D. Only run all commands as oracle.

  E. Only run some commands as oracle.

  Correct Answer: AC

  Reference: https://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute/ creating_an_ssh_enabled_user/creating_an_ssh_enabled_user.html

• Question 26:

  The In-Memory compression level is set to MEMCOMPRESS FOR QUERY HIGH. For what purpose is this optimized?

  A. for parallel query performance only

  B. for query performance and space saving

  C. for query performance and space saving with greater bias toward space saving

  D. for query performance only

  E. for space saving only

  Correct Answer: B

  Reference: https://docs.oracle.com/database/121/REFRN/GUID-5772F775-2A3E-4BC8-AA03B8FF383BEE52.htm#REFRN10350

• Question 27:

  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

  Correct Answer: C

• Question 28:

  You want to partition the SALES table on the CITY and SALE_DATE columns.

  Which three partitioning methods can you use? (Choose three.)

  A. range

  B. interval

  C. hash

  D. list

  E. virtual column-based

  Correct Answer: ACD

  Reference: https://docs.oracle.com/database/121/VLDBG/GUID-6CE884AF-84A4-4E6A-A3EFDCCEBCAB2DB2.htm#VLDBG00202

• Question 29:

  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.

  Correct Answer: BE

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

• Question 30:

  Examine these commands executed in the cdb1 container database: Which statement is true about the c##USER1 account?

  

  A. It is locked for two days after the password expires.

  B. It is locked if the password is not changed within three weeks.

  C. It is locked for 90 minutes after four failed login attempts.

  D. It is locked after for consecutive failed login attempts.

  E. It is not affected by the profile because the user has the SYSDBA privilege.

  Correct Answer: D