Jan 24, 2018 sample paper 2

Which of the following variable declarations is illegal?

This paper concentrates on the primary theme of Which of the following variable declarations is illegal? in which you have to explain and evaluate its intricate aspects in detail. In addition to this, this paper has been reviewed and purchased by most of the students hence; it has been rated 4.8 points on the scale of 5 points. Besides, the price of this paper starts from £ 45. For more details and full access to the paper, please refer to the site.

Question 1

Which of the following variable
declarations is illegal?

Question 1 options:

1)

lv_junk NUMBER(3);

2)

lv_junk NUMBER(3) NOT NULL;

3)

lv_junk NUMBER(3) := 11;

4)

lv_junk NUMBER(3) CONSTANT := 11;

Question 2

Which of the following is not a possible
value for a Boolean variable?

Question 2 options:

1) TRUE

2) FALSE

3) BLANK

4) NULL

Question 3

What type of variable can store only one
value?

Question 3 options:

1) local

2) scalar

3) simple

4) declared

Question 4

What keyword is used to check multiple
conditions with an IF statement?

Question 4 options:

1) ELSE IF

2) ELSEIF

3) ELSIF

4) ELSIFS

Question 5

What type of loop can be used if the loop
might not need to execute under certain circumstances?

Question 5 options:

1) FOR

2) WHILE

3) basic

4) All of the above

Question 6

How is the looping action of a basic loop
stopped?

Question 6 options:

1) It’s stopped when the condition in
the LOOP statement is FALSE.

2) This type of loop has a
predetermined number of loops to complete.

3) The condition in an EXIT WHEN
statement is FALSE.

4) The condition in an EXIT WHEN
statement is TRUE.

Question 7

When does a WHILE loop evaluate the
condition that determines whether the looping action continues?

Question 7 options:

1) at the beginning of the loop

2) somewhere inside the loop

3) at the end of the loop

4) all of the above

Question 8 (1 point

If you know the number of loop iterations
ahead of time, what type of loop should be used?

Question 8 options:

1) FOR

2) WHILE

3) basic

4) None of the above

Question 9

What commands can be used to end loop
execution? (Choose all that apply.)

Question 9 options:

1) CONTINUE

2) EXIT

3) EXIT WHEN

4) STOP

Question 10

Which programming constructs can use a
CONTINUE statement?

Question 10 options:

1) IF/THEN statements

2) loops

3) CASE statements

4) All of the above

Question 11

What are variables, and why are they
needed?

Question 12

Name the three main types of loop
structures in PL/SQL, and explain the difference in how each determines how
many times a loop iterates.

Question 12 options:

Question 13

What are the two types of decision
structures in PL/SQL?

Question 14 (1 point) Question 14 Unsaved

How can flowcharts assist developers?

Question 15

What happens when a CONSTANT option is set
in a variable declaration?


0% Plagiarism Guaranteed & Custom Written, Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

Order Now

STILL NOT CONVINCED?

We've produced some samples of what you can expect from our Academic Writing Service - these are created by our writers to show you the kind of high-quality work you'll receive. Take a look for yourself!

View Our Samples

corona virus stop
FLAT 25% OFF ON EVERY ORDER.Use "FLAT25" as your promo code during checkout