In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

• A.T1, an index segment for the primary key, and a LOB segment only
• B.T1 and an index segment created for the primary key only
• C.T1, an index segment for the primary key, a LOB segment, and a lobindex segment
• D.T1 only
• E.no segments are created

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

Comment: *

Name: *

Email: *

Verification: *

You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') What is the result?

• A.It executes successfully but does not return any result
• B.It returns the date for the first Monday of the next month
• C.It generates an error
• D.It returns the date for the last Monday of the current month

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the rules of precedence for operators? (Choose two.)

• A.The concatenation operator | | is always evaluated before addition and subtraction in an expression
• B.NULLS influence the precedence of operators in an expression
• C.The + binary operator has the highest precedence in an expression in a SQL statement
• D.Arithmetic operators with equal precedence are evaluated from left to right within an expression
• E.Multiple parentheses can be used to override the default precedence of operators in an expression

Comment: *

Name: *

Email: *

Verification: *

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

• A.Employee 100 will have SALARY set to the same value as the SALARY of employee 200
• B.Employees 100 and 200 will have the same SALARY as before the update command
• C.Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
• D.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
• E.Employees 100 and 200 will have the same JOB_ID as before the update command
• F.Employee 200 will have SALARY set to the same value as the SALARY of employee 100

Comment: *

Name: *

Email: *

Verification: *