Chapter Quiz

Chapter Quiz

University

10 Qs

quiz-placeholder

Similar activities

แข่งขันcodingม.ปลาย

แข่งขันcodingม.ปลาย

12th Grade - University

15 Qs

DB-Quiz1

DB-Quiz1

University

10 Qs

Kiểm tra kiến thức về SQL

Kiểm tra kiến thức về SQL

11th Grade - University

15 Qs

Codean - JavaScript Variablel & Function

Codean - JavaScript Variablel & Function

University

15 Qs

Contadores y Acumuladores

Contadores y Acumuladores

University

10 Qs

Основы работы с СУБД

Основы работы с СУБД

University

10 Qs

Computer Programming I Finals

Computer Programming I Finals

University

11 Qs

EXAMEN CONVOCATORIA 1 BD1

EXAMEN CONVOCATORIA 1 BD1

University

12 Qs

Chapter Quiz

Chapter Quiz

Assessment

Quiz

Information Technology (IT)

University

Medium

Created by

Ronette Rabanal

Used 1+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is the correct syntax for an IF statement in PL/SQL?

IF condition THEN statement; END IF;

IF condition BEGIN statement; END;

IF condition THEN BEGIN statement; END IF;

IF condition THEN statement END;

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In PL/SQL, what would be the output if the following block is executed where v_num := 15?

DECLARE

v_num NUMBER := 15;

BEGIN

CASE

WHEN v_num > 10 THEN

DBMS_OUTPUT.PUT_LINE('Greater than 10');

WHEN v_num <= 10 THEN

DBMS_OUTPUT.PUT_LINE('Less than or equal to 10');

ELSE

DBMS_OUTPUT.PUT_LINE('Unknown');

END CASE;

END;

Greater than 10

Less than or equal to 10

Unknown

No output

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What will be the output of the following PL/SQL block?

DECLARE

v_num NUMBER := 1;

BEGIN

WHILE v_num <= 5 LOOP

DBMS_OUTPUT.PUT_LINE(v_num);

v_num := v_num + 1;

END LOOP;

END;

1 2 3 4 5

1 2 3 4

1 1 1 1 1

Error

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is the correct syntax for a FOR loop in PL/SQL?

FOR i IN 1 TO 10 LOOP ... END LOOP;

FOR i IN 1..10 LOOP ... END LOOP;

FOR i IN (1..10) LOOP ... END LOOP;

FOR i = 1 TO 10 LOOP ... END LOOP;

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the CONTINUE statement in a PL/SQL loop?

It terminates the loop.

It exits the current iteration of the loop and moves to the next iteration.

It restarts the loop.

It pauses the loop for a given time.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What will be the output of the following PL/SQL block?

DECLARE

v_num NUMBER := 0;

BEGIN

LOOP

v_num := v_num + 1;

EXIT WHEN v_num = 5;

END LOOP;

DBMS_OUTPUT.PUT_LINE(v_num);

END;

1

4

5

Infinite loop

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the %TYPE attribute in PL/SQL do?

It defines the data type of a variable as a reference to a column type in a table.

It defines the default value of a variable.

It defines the size of a variable.

It converts the variable to a BOOLEAN type.

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?