Which two are true about shrinking a segment online? (Choose two.)

• A.It is not possible to shrink either indexes or Index Organized Tables (IOTs)
• B.To shrink a table it must have a UNIQUE KEY constraint
• C.To shrink a table it must have row movement enabled
• D.It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
• E.To shrink a table it must have a PRIMARY KEY constraint
• F.It always eliminates all migrated rows if any exist in the table

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about a self join? (Choose three.)

• A.The ON clause must be used
• B.The query must use two different aliases for the table
• C.It must be an equijoin
• D.It must be an inner join
• E.The ON clause can be used
• F.It can be an outer join

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the BOOKS table:

The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL,
NULL);
SAVEPOINT a;
DELETE FROM books;
ROLLBACK TO SAVEPOINT a;
ROLLBACK;
Which two statements are true? (Choose two.)

• A.The second ROLLBACK command undoes the insert
• B.The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row
• C.The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
• D.The second ROLLBACK command replays the delete
• E.The second ROLLBACK command does nothing

Comment: *

Name: *

Email: *

Verification: *

Which two are true about shrinking a segment online? (Choose two.)

• A.It is not possible to shrink either indexes or Index Organized Tables (IOTs)
• B.It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
• C.To shrink a table it must have a PRIMARY KEY constraint
• D.To shrink a table it must have a UNIQUE KEY constraint
• E.It always eliminates all migrated rows if any exist in the table
• F.To shrink a table it must have row movement enabled

Comment: *

Name: *

Email: *

Verification: *

Which three object types support deferred segment creation? (Choose three.)

• A.clustered tables
• B.external tables
• C.partitioned tables
• D.index organized tables
• E.temporary tables
• F.heap organized tables

Comment: *

Name: *

Email: *

Verification: *