Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

• A.The CURRENT_TIMESTAMP function returns data without time zone information
• B.A TIMESTAMP data type column contains information about year, month, and day
• C.The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• D.The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• E.A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about using SQL*Plus?

• A.It has its own commands that are separate from any SQL statements.
• B.It can run Recovery Manager (RMAN) commands.
• C.It can run scripts passed to it by a shell script.
• D.It can run scripts entered at the SQL prompt.
• E.It must be downloaded from the Oracle Technology Network (OTN).
• F.It has both command-line and graphical user interfaces (GUI).

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

• A.Column positions must be used in the ORDER BY clause
• B.Each SELECT statement in the compound query can have its own ORDER BY clause
• C.The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause
• D.Each SELECT statement in the compound query must have its own ORDER BY clause
• E.Only column names from the first SELECT statement in the compound query are recognized

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

Comment: *

Name: *

Email: *

Verification: *

You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBStablespace? (Choose two.)

• A.It must be bigger than the largest SMALLFILE tablespace
• B.Additional data files may not be added
• C.It will always have a 32K blocksize
• D.AUTOEXTEND is possible for the datafile
• E.It will be a dictionary-managed tablespace by default

Comment: *

Name: *

Email: *

Verification: *