Oracle Database Administration I (1z0-082) Practice Test

Questions # 41:

Examine this command:

SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT

Which two statements are true?

The high-water mark (HWM) of orders is adjusted.

Only queries are allowed on ORDERS while the shrink is executing.

Queries and DML statements are allowed on ORDERS while the shrink is executing.

The shrink operation causes rows to be moved to empty space starting from the beginning of the orders segment.

Dependent indexes become UNUSABLE.

The shrink operation causes rows to be moved to empty space starting toward the end of the orders segment.

Questions # 42:

Examine the description of the SALES1 table:

Question # 42

SALES2 is a table with the same description as SALES1.

Some sales data is duplicated in both tables.

You want to display the rows from the SALES1 table which are not present in the SALES2 table.

Which set operator generates the required output?

Pass the Oracle Database 19c 1z0-082 Questions and answers with ExamsMirror