Skip to main content

1Z0-072 Real Exam Questions

Oracle Database 12cR2 Administration

87 questions available · Page 1 of 9

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Multiple choice

Which three are true about the Oracle Optimizer? (Choose three.)

  1. A

    It determines the optimal table join order and method.

  2. B

    It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.

  3. C

    It can optimize only SELECT statements.

  4. D

    It will only generate SQL Plan Directives specific to a given SQL statement.

  5. E

    It can re-optimize execution plans after previous executions detect suboptimal plans.

  6. F

    It updates stale object statistics in the Data Dictionary.

Show answer and explanation

Correct answers: A, B, C

Explanation

References:
https://docs.oracle.com/cd/B10500_01/server.920/a96533/optimops.htm

Question 2 Multiple choice

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

  1. A

    FLASHBACK QUERY

  2. B

    FLASHBACK DATABASE

  3. C

    FLASHBACK TRANSACTION

  4. D

    FLASHBACK TABLE TO SCN

  5. E

    FLASHBACK DROP

Show answer and explanation

Correct answers: D, E

Explanation

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

Question 3 Multiple choice

Which two are prerequisites for shrinking a table online?

  1. A

    It must have a unique key constraint.

  2. B

    It must not have any referential integrity constraints.

  3. C

    It must not have any DML triggers.

  4. D

    It must be in a tablespace that uses Automatic Segment Space Management (ASSM) .

  5. E

    It must have row movement enabled.

Show answer and explanation

Correct answers: A, B

Question 4 Single choice

The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE.

UNDOTBS2 is the active undo tablespace.

Examine these commands:

USER1 executes DML, which generates more than 2 MB of UNDO.

What is the result and why?

  1. A

    It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.

  2. B

    It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.

  3. C

    It suspends the transaction, which can be resumed by increasing USER1's quota on UNDOTBS2.

  4. D

    It returns an error because UNDOTBS2 has RETENTION GUARANTEE.

  5. E

    It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.

  6. F

    It returns an error because UNDOTBS2 is fixed size.

Show answer and explanation

Correct answer: F

Question 5 Multiple choice

Which two tasks can you perform by using DBCA for a new database?

  1. A

    Register it with an available Enterprise Manager Management server.

  2. B

    Configure a nonstandard block size.

  3. C

    Configure incremental backups.

  4. D

    Enable flashback.

  5. E

    Create user tablespaces.

Show answer and explanation

Correct answers: A, E

Question 6 Single choice

A database is configured to use automatic undo management with temporary undo enabled. An update is executed on a heap-organized table stored in the TBS1 tablespace.

Where is the undo stored?

  1. A

    in the SYSAUX tablespace

  2. B

    in the undo tablespace

  3. C

    in the redo logs

  4. D

    in rollback segments

  5. E

    in the temporary tablespace

Show answer and explanation

Correct answer: A

Question 7 Single choice

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?

  1. A

    COLUMN STORE COMPRESS FOR ARCHIVE HIGH

  2. B

    ROW STORE COMPRESS ADVANCED

  3. C

    COLUMN STORE COMPRESS FOR ARCHIVE LOW

  4. D

    ROW STORE COMPRESS BASIC

  5. E

    COLUMN STORE COMPRESS FOR QUERY LOW

Show answer and explanation

Correct answer: B

Explanation

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

Question 8 Single choice

When is a SID_LIST_<listener name> section required in a LISTENER.ORA file?

  1. A

    when the listener uses multiple port numbers for different database instances

  2. B

    when a static listener is used

  3. C

    when a dynamic listener is used

  4. D

    when multiple dynamic listeners are used

  5. E

    when the list of existing database services must be defined

Show answer and explanation

Correct answer: B

Explanation

You can use the SID_LIST section of the listener.ora to statically configure service information for the listener.

References:
https://docs.oracle.com/cd/B28359_01/network.111/b28317/listener.htm#NETRF300

Question 9 Multiple choice

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

  1. A

    It is a tablespace attribute.

  2. B

    It prevents FLASHBACK DATABASE operation failure.

  3. C

    It prevents out-of-space errors.

  4. D

    It prevents "Snapshot too old" errors.

  5. E

    It is a static parameter.

Show answer and explanation

Correct answers: A, B

Question 10 Multiple choice

Which three are true about Oracle Managed Files (OMF)? (Choose three.)

  1. A

    If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo
    logs and control files are placed in DB_CREATE_FILE_DEST by default.

  2. B

    If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.

  3. C

    If only DB_CREATE_FILE_DEST is specified, only the data files and temp files are OMF.

  4. D

    If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo
    logs and control files are placed in DB_RECOVERY_FILE_DEST by default.

  5. E

    If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, the data
    files and temp files are placed in DB_CREATE_ONLINE_LOG_DEST_1 by default.

  6. F

    If only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF.

Show answer and explanation

Correct answers: A, B, F