In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

• A.It succeeds and the generated undo is stored in SYSTEM.
• B.It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace
  'UNDOTBS1' ".
• C.It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
• D.It succeeds and the generated undo is stored in SYSAUX.
• E.It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

Comment: *

Name: *

Email: *

Verification: *

Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items
GROUP BY order_id;
Which two statements are true?

• A.Statement 2 may return multiple rows of output.
• B.Statement 2 returns only one row of output.
• C.Both the statements give the same output.
• D.Statement 1 returns only one row of output.
• E.Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.

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.Employees 100 and 200 will have the same JOB_ID as before the update command
• B.Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
• C.Employee 100 will have SALARY set to the same value as the SALARY of employee 200
• D.Employees 100 and 200 will have the same SALARY as before the update command
• E.Employee 200 will have SALARY set to the same value as the SALARY of employee 100
• F.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

• A.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• B.GLOBAL TEMPORARY TABLE space allocation occurs at session start.
• C.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
• D.A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• E.A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
• F.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

Comment: *

Name: *

Email: *

Verification: *

What is true about non-equijoin statement performance? (Choose two.)

• A.Table aliases can improve performance
• B.The join syntax used makes no difference to performance
• C.The BETWEEN condition always performs better than using the >= and <= conditions
• D.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
• E.The BETWEEN condition always performs less well than using the >= and <= conditions

Comment: *

Name: *

Email: *

Verification: *