What are the two types of decision structures in sql

Assignment Help Computer Engineering

Reference no: EM131066872

Question 1 Which of the following variable declarations is illegal?
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?

1) TRUE
2) FALSE
3) BLANK
4) NULL

Question 3 What type of variable can store only one value?

1) local
2) scalar
3) simple
4) declared

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

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?

1) FOR
2) WHILE
3) basic
4) All of the above

Question 6 How is the looping action of a basic loop stopped?

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?

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 If you know the number of loop iterations ahead of time, what type of loop should be used?

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.)

1) CONTINUE
2) EXIT
3) EXIT WHEN
4) STOP

Question 10 Which programming constructs can use a CONTINUE statement?

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 13 What are the two types of decision structures in PL/SQL?

Question 14 How can flowcharts assist developers?

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

Reference no: EM131066872

Questions Cloud

Determine the molecular mass : Molecular masses can be determined through electroplating. Determine the molecular mass and identity of a +2 metal, X, that plates 46.3g of X in 6.75 hours at a current of 2 A.

What if f is a finite field like z/pz : What if F is a finite field like Z/pZ?

Constant temperature and volume : How many moles of carbon dioxide would have to be added at constant temperature and volume to increase the amount of carbon monoxide to 0.300 mol once equilibrium has been reestablished?

Prepare a complete statement of cash flows : Prepare a complete statement of cash flows for calendar-year 2011 using the indirect method.

What are the two types of decision structures in sql : What are the two types of decision structures in PL/SQL? How can flowcharts assist developers? What happens when a CONSTANT option is set in a variable declaration?

Experience serving as a direct supervisor to staff : Please describe your experience serving as a direct supervisor to staff (how many people and what was your role?). What are your strengths in this role? What are your weaknesses in this role?

Density of the aqueous polymer solution : What mass of this polymer was initially added to the osmometer? Pleases assume that the density of the aqueous polymer solution remains 1.00g/mL.

What is the probability that the server will be busy : What is the probability that the server will be busy?

Define law and its importance to the society : BLB500001 - Gulf Regional Legal Environment of Business - Discuss the concept of a conciliation and reconciliation committee as it applies to Oman with examples reflecting their success.

User Account

All Pages