Which three statements are true about inner and outer joins? (Choose three.)

• A.A full outer join returns matched and unmatched rows
• B.An inner join returns matched rows
• C.Outer joins can only be used between two tables per query
• D.A full outer join must use Oracle syntax
• E.Outer joins can be used when there are multiple join conditions on two tables
• F.A left or right outer join returns only unmatched rows

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 first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row
• B.The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
• C.The second ROLLBACK command replays the delete
• D.The second ROLLBACK command does nothing
• E.The second ROLLBACK command undoes the insert

Comment: *

Name: *

Email: *

Verification: *

You want to use table compression suitable for OLTP that will:
Compress rows for all DML statements on that table
Minimize the overheads associated with compression
Which compression option is best suited for this?

• A.COLUMN STORE COMPRESS FOR QUERY LOW
• B.ROW STORE COMPRESS BASIC
• C.COLUMN STORE COMPRESS FOR ARCHIVE LOW
• D.COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• E.ROW STORE COMPRESS ADVANCED

Comment: *

Name: *

Email: *

Verification: *

Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

• A.It overwrites data in EMP with data in EMP.DAT
• B.It appends data from EMP.DAT to EMP
• C.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
• D.It uses the database buffer cache to load data
• E.It generates a sql script that it uses to load data from EMP.DAT to EMP

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

• A.VSTABLESPACE displays information that is contained in the controlfile about tablespaces
• B.Tablespace free space can be viewed in VSTABLESPACE
• C.VSTABLESPACE displays information about tablespaces contained in the data dictionary
• D.A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened
• E.Tablespace free space can be viewed in DBA_TABLESPACES

Comment: *

Name: *

Email: *

Verification: *