Oracle Test

10 Questions

Settings
Please wait...
Oracle Test

Questions and Answers
  • 1. 
    What does the method extend(n,i) do?
    • A. 

      Append n elements and sets each to the same value as the I th element

    • B. 

      It can be used to build generic and reusable code

    • C. 

      Add a single null element at ith position

    • D. 

      .add n null elements at ith position

    • E. 

      Appends n elements and sets each to a null value.

  • 2. 
    .which of the following statements are true about dynamic sql?(choose 3)
    • A. 

      It contain ddl statements

    • B. 

      .it contains sql statements that are constructed and executed at run time

    • C. 

      It can be usedd to bulid generic and reusable code

    • D. 

      To execute dynamic sql,the syntax is dynamic sql,where sql_string is the string containing the sql code

    • E. 

      It can contain only dml statements

  • 3. 
    Consider the ffollowing code snippet: Declare Count number:=0; Begin For j in reverse 3..1 loop Count:=j; End loop; End;
    • A. 

      1

    • B. 

      0

    • C. 

      Null

    • D. 

      2

    • E. 

      3

  • 4. 
    In pl/sql,boolean data type is an example of
    • A. 

      lob data type

    • B. 

      Composite data type

    • C. 

      Scalar data type

    • D. 

      Reference data

  • 5. 
    Examine the description of the employees table: EMP_ID NUMBER (4) NOT NULL LAST_NAME VARCHAR2 (30) NOT NULL FIRST_NAME VARCHAR2 (30) DEPT_ID NUMBER (2) JOB_CAT VARCHAR (30) SALARY NUMBER (8, 2) Which of the following SQL statements shows the department ID, minimum salary, and maximum salary paid in that department: only if the minimum salary is less than 2000 and maximum salary is more than 5000?
    • A. 

      . SELECT dept_id: MIN (salary), MAX (salary) FROM employees WHERE MIN(salary) 2000 AND MAX (salary) > 5000

    • B. 

      SELECT dept_id: MIN (salary); MAX (salary) FROM employees GROUP BY dept_id HAVING MIN(salary) C 2000 AND MAX (salary) > 5000

    • C. 

      SELECT dept_id: MIN (salary): MAX (salary) FROM employees WHERE MIN (salary) c 2000 AND MAX (salary) > 5000 GROUP BY dept_id

    • D. 

      . SELECT dept_id: MIN(salary), MAX(salary) FROM employees HAVING MIN (salary) c 2000 AND MAX (salary) > 5000

  • 6. 
    Consider the following code snippet: Declare i number := 10; j number; begin if i = 10 then j else - Fill in code end if; end; For the condition i is not equal to 10; which of the following code can be filled in the above code snippet?
    • A. 

      Else end if;

    • B. 

      Else end if;

    • C. 

      Else NULL; end if;

    • D. 

      Else …… end if;

  • 7. 
    Which of the following Query FlashBack feature of Oracle lOg helps you to retrieve metadata and historical data for a specific time interval?
    • A. 

      Oracle Flashback version Query

    • B. 

      Oracle Flashback Query

    • C. 

      Oracle Flashback Transaction Query

    • D. 

      DBMS_Flashback Package

  • 8. 
    Consider the following SQL query: SELECT employee_id, lasCname, manager_id 114 FROm employees CONNECT BY PRIOR employee_id = manaqer jd; Which of the following is correct about the above SQL query?
    • A. 

      The above query is an example of a Subquery.

    • B. 

      The above query is an example of a Nested Query.

    • C. 

      The above query is an example of a Hierarchical Query.

    • D. 

      The above query is an example of a Correlated query.

  • 9. 
    Which of the following is example of SYSOPER privilege type
    • A. 

      Alter database

    • B. 

      Commit

    • C. 

      Recover database

    • D. 

      Create database

  • 10. 
    Consider the following code segment create or replace trigger contentID --Line 1 for each row --Line 2 before insert on webcontent --Line 3 begin --Line 4 Select contentseq.nextval into :new.ID from dual: --Line 5 end : the above coding when executed results in error which line produces error here
    • A. 

      Line 3&5

    • B. 

      Line 2

    • C. 

      Line 5

    • D. 

      Line 1&4