Shortcut Navigation:

PL SQL Mock Quiz (Statement, Character, SQL)

Which Oracle access method is the fastest way for Oracle to retrieve a single row?

Which of the following can be a valid column name?

Which command will delete all data from a table and will not write to the rollback segment?

Which character function can be used to return a specified portion of a character string?

The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associated index on EMPNO?

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?

Which character is used to continue a statement in SQL*Plus?

Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;

To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?

Which of the following SQL functions can operate on any datatype?

Tagged as: sql