Oracle Database 12c: Installation and Administration: 1Z0-062

Examine the following command;

ALTER SYSTEM SET enable_ddl_logging = TRUE;

Which statement is true?

A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.

B. All DDL commands are logged in the alert log file.

C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.

D. Only DDL commands that resulted in the creation of new segments are logged.

E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

DAILY_ORDS_LST is created in locally managed tablespace ORDERS_TBS which uses automatic segment space management.

Which two are true? (Choose two.)

A. 80% of every data block in daily_ords_list is reserved for row inserts

B. 20% of each data block in the table is reserved for row updates

C. PCTFREE can help to minimize row chaining during inserts

D. PCTFREE can help reduce row migration during updates

E. PCTFREE eliminates row chaining during inserts

SMD is a bigfile tablespace.

The SH user receives this error while inserting data into the non-partitioned SALES table:

ERROR at line 1:

ORA-01653: unable to extend table SH.SALES by 128 in tablespace SMD.

Which three actions could correct the problem? (Choose three.)

A. shrinking segments in the SMD tablespace

B. adding a data file to the SMD tablespace

C. increasing the space quota for user SH on the SMD tablespace

D. setting the SMD tablespace datafile to autoextend

E. adding new rows for the table segment in a different tablespace