Advertisement
Advertisement
Advertisement

Pl SQL Quizzes & Trivia

Top Trending Quizzes

Oracle SQL and PL/SQL Practice Quiz For Developers. It consists of 30 basic to advanced programming questions to assist you in your practicing session. All the best as you go down to tackle these questions.  

Questions: 35  |  Attempts: 15764   |  Last updated: Mar 22, 2022
  • Sample Question
    Which of the following statements contains an error?
    Radio Button
    Radio Button
    Radio Button
    Radio Button

This is a sample PL/SQL test

Questions: 42  |  Attempts: 4270   |  Last updated: Mar 22, 2022
  • Sample Question
    Examine this function:   CREATE OR REPLACE FUNCTION CALC_PLAYER_AVG (V_ID in PLAYER_BAT_STAT.PLAYER_ID%TYPE) RETURN NUMBER IS V_AVG NUMBER; BEGIN SELECT HITS / AT_BATS INTO V_AVG FROM PLAYER_BAT_STAT WHERE PLAYER_ID = V_ID; RETURN (V_AVG); END;   Which statement will successfully invoke this function in SQL *Plus?
    Radio Button
    Radio Button
    Radio Button
    Radio Button
    Radio Button

Try your best.. :)

Questions: 36  |  Attempts: 3164   |  Last updated: Mar 22, 2022
  • Sample Question
    The number of cascading triggers is limited by which data base initialization parameter?
    Radio Button
    Radio Button
    Radio Button
    Radio Button

Multiple choice questions...

Questions: 10  |  Attempts: 4229   |  Last updated: Apr 20, 2022
  • Sample Question
    How many tables may be included with a join?
    Radio Button
    Radio Button
    Radio Button
    Radio Button



Questions: 149  |  Attempts: 3220   |  Last updated: Mar 22, 2022
  • Sample Question
    Examine this procedure: CREATE OR REPLACE PROCEDURE  DELETE_PLAYER(V_IDIN NUMBER) IS BEGIN DELETE FROM PLAYER WHERE ID =  V_ID EXCEPTION WHEN STATS_EXI TS_EXCEPTI ON THEN DBMS_OUTPUT.  PUT_LINE(Cannotdeletethisplayer, childrecordsexistin PLAYER_BAT_STAT table);END;  What prevents this procedure from being created successfully? 
    Radio Button
    Radio Button
    Radio Button
    Radio Button
Recent Quizzes
Advertisement
Advertisement