Oracle Quiz Questions

Iterative Control: Nested Loops  1.  What statement allows you to exit the outer loop at Point A in the following block? DECLARE  v_out...

Iterative Control: While and For Loops         1.  Look at the following code fragment: i := 2; WHILE i < 3 LOOP    i := 4;    DBM...

Iterative Control: Basic Loops         1.  What will be displayed when this block is executed? DECLARE   v_count NUMBER := 10;   v_res...

Conditional Control: Case Statements  Section 1       1.  How must you end a CASE expression? (1) Points           END; (*)     ENDI...

Conditional Control: IF Statements  Section 1     1.  Name three types of control structures in PL/SQL. (Choose three)  (1) Points    ...

Retrieving Data in PL/SQL  Section 1       1.  Look at this PL/SQL block: DECLARE    v_count NUMBER; BEGIN    SELECT COUNT(*) INTO ...

Review of SQL DML Section 1       1.  When inserting a row into a table, the VALUES clause must include a value for every column of the...