Quiz Questions Over Oracle Software

20 Questions | Total Attempts: 135

SettingsSettingsSettings
Please wait...
Oracle Quizzes & Trivia

Based on oracle concepts


Questions and Answers
  • 1. 
    Databases overall structure is maintained in a file called
    • A. 

      Redolog file

    • B. 

      Data file

    • C. 

      Control file

    • D. 

      All of the above

  • 2. 
    It is very difficult to grant and manage common privileges needed by different groups of database users using the roles
    • A. 

      True

    • B. 

      False

  • 3. 
    Why is it better to use an INTEGRITY CONSTRAINT to validate data in a table than to use a STORED PROCEDURE ?
    • A. 

      Because an integrity constraint is automatically checked while data is inserted into or updated in a table while a stored procedure has to be specifically invoked

    • B. 

      Because the stored procedure occupies more space in the database than a integrity constraint definition

    • C. 

      Because a stored procedure creates more network traffic than a integrity constraint definition

    • D. 

      All

  • 4. 
    All datafiles related to a Tablespace are removed when the Tablespace is dropped
    • A. 

      True

    • B. 

      False

  • 5. 
    Size of Tablespace can be increased by
    • A. 

      Increasing the size of one of the Datafiles

    • B. 

      Adding one or more Datafiles

    • C. 

      Cannot be increased

    • D. 

      None of the above

  • 6. 
    Which of the following is NOT VALID is PL/SQL
    • A. 

      Bool boolean;

    • B. 

      Deptname dept.dname%type;

    • C. 

      NUM1, NUM2 number;

    • D. 

      Date1 date := sysdate ;

  • 7. 
    1. There are two schema users A & B User A grants select privilege to user B on tables User A grants execute privilege to user B on packages Now, on executing package from user B, Execute below code from User B to retrieve the record from the table of
               user A  Declare v_sid tab_user_A.column1%TYPE; v_pid tab_user_A.column2%TYPE; v_value tab_user_A.column3%TYPE; v_pname tab_user_A.column4%TYPE; v_cur package_user_A.Cursor1; Begin package_user_A.procedure_one(0,0,1,1,v_cur); dbms_output.put_line(v_value); End; Then output is
    • A. 

      1

    • B. 

      Error

    • C. 

      No privileges

    • D. 

      A must grant some more privileges

  • 8. 
    Is it not possible to use Transactional control statements in Database Triggers?
    • A. 

      True

    • B. 

      False

  • 9. 
    Which of the following is NOT VALID in PL/SQL ?
    • A. 

      Select ? into

    • B. 

      Update

    • C. 

      Create

    • D. 

      Delete

  • 10. 
    Which of the following is not correct about Cursor ?
    • A. 

      Cursor is a named Private SQL area

    • B. 

      Cursor is used for retrieving multiple rows

    • C. 

      SQL uses implicit Cursors to retrieve rows

    • D. 

      Cursor holds temporary results

  • 11. 
    Which of the following is not correct about a View ?
    • A. 

      Ocuupies data storage space

    • B. 

      To protect some of the columns of a table from other users

    • C. 

      To hide complexity of a query

    • D. 

      To hide complexity of a calculations

  • 12. 
    The table is  ORG_CHART          EMPLOYEE_ID                MANAGER_ID  JOB_ID ------------------ ----------- ---------- ----------     Kochhar                101        100 AD_VP     Faviet                 109      108 FI_ACCOUNT     Chen                   110        108 FI_ACCOUNT     Sciarra                  111        108 FI_ACCOUNT     Urman                  112        108 FI_ACCOUNT     Popp                     113       108 FI_ACCOUNT   Whalen                   200        101 AD_ASST   King                       100       116 AD_PRES   Mavris                    203        101 HR_REP   Baer                       204       101 PR_REP   Higgins                  205        101 AC_MGR     Gietz                   206      205 AC_ACCOUNT   De Haan                 102        100 AD_VP  Hunold                   103        102 IT_PROG The query is SELECT LPAD(' ',2*(LEVEL-1)) ||  org_chart, employee_id, manager_id, job_id     FROM employees     START WITH job_id = 'AD_PRES'     CONNECT BY PRIOR employee_id = manager_id AND LEVEL <= 2; What is the output?
    • A. 

      ORG_CHART EMPLOYEE_ID MANAGER_ID JOB_ID ------------------ ----------- ---------- ---------- Kochhar 101 100 AD_VP King 100 116 AD_PRES De Haan 102 100 AD_VP

    • B. 

      ORG_CHART EMPLOYEE_ID MANAGER_ID JOB_ID ------------------ ----------- ---------- ---------- King 100 116 AD_PRES Kochhar 101 100 AD_VP De Haan 102 100 AD_VP

    • C. 

      ORG_CHART EMPLOYEE_ID MANAGER_ID JOB_ID ------------------ ----------- ---------- ---------- De Haan 102 100 AD_VP King 100 116 AD_PRES Kochhar 101 100 AD_VP

    • D. 

      ORG_CHART EMPLOYEE_ID MANAGER_ID JOB_ID ------------------ ----------- ---------- ---------- Kochhar 101 100 AD_VP De Haan 102 100 AD_VP King 100 116 AD_PRES

  • 13. 
    What is a Built_in subprogram ?
    • A. 

      Library

    • B. 

      Stored procedure & Function

    • C. 

      Collection of Subprograms

    • D. 

      None of the above

  • 14. 
    Which prefixes are available to Oracle triggers?
    • A. 

      : new only

    • B. 

      :old only

    • C. 

      Both :new and :old

    • D. 

      Neither :new nor :old

  • 15. 
    The syntax for creating a view is
    • A. 

      CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW view [(alias)[,alias]…)] AS subquery [WITH CHECK OPTION [CONSTRAINT constraint]] [WITH READ ONLY [CONSTRAINT constraint]];

    • B. 

      CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW [(alias)[,alias]…)] AS subquery [WITH CHECK OPTION [CONSTRAINT constraint]] [WITH READ ONLY [CONSTRAINT constraint]];

    • C. 

      CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW view [(alias)[,alias]…)] AS subquery [WITH CHECK OPTION [CONSTRAINT constraint]] [WITH READ ONLY [CONSTRAINT constraint]]

    • D. 

      CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW [(alias)[,alias]…)] AS subquery [WITH CHECK OPTION [CONSTRAINT constraint]] [WITH READ ONLY [CONSTRAINT constraint]]

  • 16. 
    There is a table ddd(d date). Which of the given statement is correct?
    • A. 

      Insert into ddd values(to_date('2003/05/03 21:02:44'));

    • B. 

      Insert into ddd d values(to_date('2003/05/03 21:02:44', 'yyyy/mm/dd hh24:mi:ss'));

    • C. 

      Insert into ddd values(to_date('2003/05/03 21:02:44', 'yyyy/mm/dd hh:mi:ss'));

    • D. 

      None is correct

  • 17. 
    Consider that the following statements are executed. create table suppliers( supplier_id number, supplier_name varchar2(100)); insert into suppliers (supplier_id, supplier_name ) values ( 10565, null ); insert into suppliers (supplier_id, supplier_name ) values ( 10567, '' ); Then for the below query what will be the output? select * from suppliers where supplier_name = ' ';
    • A. 

      SUPPLIER_ID SUPPLIER_NAME 10567

    • B. 

      SUPPLIER_ID SUPPLIER_NAME 10565 10567

    • C. 

      No rows selected

    • D. 

      Error

  • 18. 
    For insertion of multiple rows into multiple tables which of the following is correct?
    • A. 

      INSERT ALL INTO suppliers (supplier_id, supplier_name) VALUES (1000, 'IBM') INTO suppliers (supplier_id, supplier_name) VALUES (2000, 'Microsoft') INTO customers (customer_id, customer_name, city) VALUES (999999, 'Anderson Construction', 'New York');

    • B. 

      INSERT ALL INTO suppliers (supplier_id, supplier_name) VALUES (1000, 'IBM') INTO suppliers (supplier_id, supplier_name) VALUES (2000, 'Microsoft') INTO customers (customer_id, customer_name, city) VALUES (999999, 'Anderson Construction', 'New York') SELECT * FROM dual;

    • C. 

      Both

    • D. 

      None

  • 19. 
    Does the view exist if the table is dropped from the database?
    • A. 

      True

    • B. 

      False

  • 20. 
    What will the below statement do? CREATE TABLE companies AS (SELECT * FROM suppliers WHERE 1=2);
    • A. 

      This would create a new table called suppliers that included all columns from the companies table, but no data from the companies table.

    • B. 

      This would create a new table called companies that included all columns from the suppliers table, with data from the suppliers table.

    • C. 

      This would create a new table called companies that included all columns from the suppliers table, but no data from the suppliers table.

    • D. 

      Error