Oracle Oracle Certifications 1Z0-072 Questions & Answers

• Question 21:

  Which two are true about RETENTION GUARANTEE? (Choose two.)

  A. It is a tablespace attribute.

  B. It prevents FLASHBACK DATABASE operation failure.

  C. It prevents out-of-space errors.

  D. It prevents "Snapshot too old" errors.

  E. It is a static parameter.

  Correct Answer: AB

• Question 22:

  In your database, you create a user, HR, and then execute this command:

  

  Which three actions can HR perform? (Choose three.)

  A. Grant the CREATE SESSION privilege without ADMIN OPTION to other users.

  B. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.

  C. Execute DML statements in the HR schema.

  D. Log in to the database instance.

  E. Revoke the CREATE SESSION privilege from other users.

  F. Execute DDL statements in the HR schema.

  Correct Answer: BDE

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9013.htm

• Question 23:

  You execute this command:

  

  Which two statements are true about the SALES tablespace? (Choose two.)

  A. The FREELISTS and FREELIST GROUPS parameters are used to manage extent allocation.

  B. It is read-only by default.

  C. DML operations performed on objects in this tablespace are not logged by default.

  D. It uses the default blocksize used at database creation.

  E. It is a locally managed tablespace.

  F. It is offline by default.

  Correct Answer: AD

• Question 24:

  Which is true about security rules on a compute node?

  A. The port used for HTTPS connections is enabled by default based on a predefined security rule.

  B. A security rule can restrict IP addresses that can connect to a database instance on a compute node.

  C. A new database deployment on a compute node automatically enables a set of predefined security rules.

  D. New security rules can be defined to use only the TCP protocol but multiple port numbers.

  E. A compute node port can be enabled only if it is associated with an existing security rule.

  Correct Answer: C

• Question 25:

  The DATA tablespace uses Automatic Segment Space Management.

  Examine this query and its output:

  

  A block in EMP is 90% full.

  At what percentage of free space will INSERT operations into the block again be possible?

  A. 10%

  B. 25%

  C. 50%

  D. 75%

  E. 90%

  Correct Answer: A

  Reference: https://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch3.htm

• Question 26:

  Examine this extract from the show parameters command: How are SGA and PGA memory managed by an instance using these parameter settings?

  

  A. SGA memory is manually managed and PGA memory is managed by using Automated SQL Execution Memory Management.

  B. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is managed by using Automated SQL Execution Memory Management.

  C. SGA and PGA memory are managed by using Automatic Memory Management (AMM).

  D. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is manually managed.

  E. SGA and PGA memory are manually managed.

  Correct Answer: C

• Question 27:

  You want to use table compression suitable for OLTP that will:

  1.

  Compress rows for all DML statements on that table

  2.

  Minimize the overheads associated with compression.

  Which compression option is best suited for this?

  A. COLUMN STORE COMPRESS FOR ARCHIVE HIGH

  B. ROW STORE COMPRESS ADVANCED

  C. COLUMN STORE COMPRESS FOR ARCHIVE LOW

  D. ROW STORE COMPRESS BASIC

  E. COLUMN STORE COMPRESS FOR QUERY LOW

  Correct Answer: B

  Reference: https://www.oracle.com/technetwork/database/options/compression/advanced-compressionwp-12c-1896128.pdf%20(6)

• Question 28:

  Which two are true about direct path load?

  A. It enforces only primary key, unique, and not NULL, constraints.

  B. DML statements may occur on tables being loaded.

  C. It fires insert triggers, if any.

  D. It writes only to blocks above the high-water mark.

  E. It uses the database buffer cache.

  Correct Answer: BC

• Question 29:

  Which two can you use to recover a dropped table? (Choose two.)

  A. FLASHBACK QUERY

  B. FLASHBACK DATABASE

  C. FLASHBACK TRANSACTION

  D. FLASHBACK TABLE TO SCN

  E. FLASHBACK DROP

  Correct Answer: DE

  Reference: https://docs.oracle.com/database/121/ADMQS/GUID-1DE547D1-3AF0-4269-8BAA4C298EC05905.htm#GUID-1DE547D1-3AF0-4269-8BAA-4C298EC05905

• Question 30:

  In the ORCL database, DEFERRED_SEGMENT_CREATION is FALSE.

  Examine this command:

  

  Which table segments are created?

  A. T1 and an index segment created for the primary key only

  B. T1, an index segment for the primary key, a LOB segment, and lobindex segment

  C. T1 only

  D. T1, an index segment for the primary key, and a LOB segment only

  Correct Answer: D