Certifications

PL SQL Mock Test Set-2

Quiz Timer

  1. Which Oracle access method is the fastest way for Oracle to retrieve a single row?
    A. Primary key access
    B. Access via unique index
    C. Table access by ROWID
    D. Full table scan

  2. Which of the following can be a valid column name?
    A. Column
    B. 1966_Invoices
    C. Catch_#22
    D. #Invoices

  3. Which command will delete all data from a table and will not write to the rollback segment?
    A. DROP
    B. DELETE
    C. CASCADE
    D. TRUNCATE

  4. Which character function can be used to return a specified portion of a character string?
    A. INSTR
    B. SUBSTRING
    C. SUBSTR
    D. POS

  5. The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associated index on EMPNO?
    A. select * from EMP where nvl(EMPNO, '00000') = '59384';
    B. select * from EMP where EMPNO = '59384';
    C. select EMPNO, LASTNAME from EMP where EMPNO = '59384';
    D. select 1 from EMP where EMPNO = '59834';

  6. When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
    A. System tablespace
    B. Users tablespace
    C. Default tablespace for the user
    D. Oracle will give an error

  7. Which character is used to continue a statement in SQL*Plus?
    A. *
    B. /
    C. -
    D. @

  8. 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;
    A. 03-JUL-00
    B. 10-JUL-00
    C. 12-JUL-00
    D. 11-JUL-00

  9. 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?
    A. 8
    B. 2
    C. 3
    D. 5

  10. Which of the following SQL functions can operate on any datatype?
    A. TO_CHAR
    B. LOWER
    C. LPAD
    D. CEIL

Submit Quiz
Vskills Practice Test © 2013
Powered By Vskills