Oracle Quizzer

15 Questions

Settings
Please wait...
Oracle SQL Quizzes & Trivia

ORACLE SQLORACLE PL/SQLORACLE DBA


Questions and Answers
  • 1. 
    • A. 

      Library Cache

    • B. 

      PGA

    • C. 

      SGA

    • D. 

      Shared Pool

    • E. 

      SQL Area

  • 2. 
    The DBA is creating a new user. Which of the following is NOT defined at user creation?
    • A. 

      Default role

    • B. 

      Default tablespace

    • C. 

      Profile

    • D. 

      Idle_time

  • 3. 
    Which character function can be used to return a specified portion of a character string?
    • A. 

      SUBSTR

    • B. 

      INSTR

    • C. 

      SUBSTRING

    • D. 

      POS

    • E. 

      SFIND

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

      Users tablespace

    • B. 

      System tablespace

    • C. 

      Default tablespace for the user

    • D. 

      Undefined

    • E. 

      Oracle will give an error

  • 5. 
    When should one back up a read-only tablespace?
    • A. 

      Immediately after placing the tablespace into read-only mode

    • B. 

      Prior to placing the tablespace into read-only mode

    • C. 

      Prior to creating a new tablespace

    • D. 

      Prior to altering the database structure

    • E. 

      During regular backup window

  • 6. 
    Which of the following contains the records of all transactions that occur in the database and plays an essential part in database recovery?
    • A. 

      Datafiles

    • B. 

      Redo log files

    • C. 

      Control files

    • D. 

      Parameter file

  • 7. 
    What is the best PCTINCREASE value for a Temporary tablespace?
    • A. 

      100

    • B. 

      80

    • C. 

      50

    • D. 

      10

    • E. 

      0

  • 8. 
    Which of the following actions is required to prevent row migration on a table?
    • A. 

      Increase PCTFREE

    • B. 

      Decrease PCTFREE

    • C. 

      Decrease PCTUSED

    • D. 

      Increase PCTUSED

    • E. 

      Increase database block size

  • 9. 
    Which Oracle access method is the fastest way for Oracle to retrieve a single row?
    • A. 

      Access via unique index

    • B. 

      Full table scan

    • C. 

      Primary key access

    • D. 

      Table access by ROWID

  • 10. 
    Select the VALID trigger type(s)?
    • A. 

      UPDATE row trigger

    • B. 

      DELETE row trigger

    • C. 

      INSERT row trigger

    • D. 

      AFTER statement trigger

    • E. 

      All of the above

  • 11. 
    In a PL/SQL block, a variable is declared as NUMBER without an initial value. What will its value be when it is first used in the executable section of the PL/SQL block?
    • A. 

      NULL

    • B. 

      0

    • C. 

      Results in a compilation error

    • D. 

      An exception will be raised

    • E. 

      None of the above

  • 12. 
    Which physical file contains the name and location of datafiles?
    • A. 

      Paramerter File

    • B. 

      Redo log file

    • C. 

      Control File

    • D. 

      Password File

    • E. 

      None of the above

  • 13. 
    What output will the follwing statement produce? Select NVL2(NULL,'NOT NULL', NULL) from dual;
    • A. 

      Function NVL2 is not defined

    • B. 

      NOT NULL

    • C. 

      NULL

    • D. 

      None of the above

  • 14. 
    The primary key on table CLIENTAB is the IDCLI column. Which of the following statements will not use the associated index on CLIENTAB?
    • A. 

      Select 1 from CLIENTAB where IDCLI = '59834';

    • B. 

      Select IDCLI, NAME from CLIENTAB where IDCLI = '59384';

    • C. 

      Select * from CLIENTAB where IDCLI= '59384';

    • D. 

      Select * from CLIENTAB where nvl(IDCLI, '00000') = '59384';

    • E. 

      None of the above

  • 15. 
    Which Oracle background process is responsible for coalescing free space?
    • A. 

      PMON

    • B. 

      LGWR

    • C. 

      SMON

    • D. 

      ARCH

    • E. 

      None of the above