Pl SQL Quizzes & Trivia

Top Trending Quizzes

Oracle SQL And Pl/SQL Practice Quiz For Developers

Oracle SQL And PL/SQL Practice Quiz For Developers

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?

SELECT * FROM emp WHERE empid = 493945;

SELECT empid FROM emp WHERE empid= 493945;

SELECT empid FROM emp;

SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;

Pl/SQL Grand Test

PL/SQL Grand Test

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?

SELECT CALC_PLAYER_AVG(PLAYER_ID) FROM PLAYER_BAT_STAT;

EXECUTE CALC_PLAYER_AVG(31);

CALC_PLAYER('RUTH');

CALC_PLAYER_AVG(31);

START CALC_PLAYER_AVG(31)

Pl/SQL Exam

PL/SQL Exam

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?

CASCADE_TRIGGER_CNT

OPEN_CURSORS

OPEN_TRIGGERS

OPEN_DB_TRIGGERS

Pl/SQL Questions Exam Quiz!

PL/SQL Questions Exam Quiz!

Multiple choice questions...

Questions: 10 | Attempts: 4229 | Last updated: Apr 20, 2022

Sample Question
How many tables may be included with a join?

One

Two

Three

All the above

Pl/SQL(1z0-147) Dumps

PL/SQL(1z0-147) Dumps

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?

A comma has been left after the STATS_EXIST_EXCEPTION exception.

The STATS_EXIST_EXCEPTION has not been declared as a number.

The STATS_EXIST_EXCEPTION has not been declared as an exception.

Only predefined exceptions are allowed in the EXCEPTION section.