What is the value of v

What is the value of v_flag

Assignment Help Basic Computer Science

Reference no: EM13241138

Q2. What is the value of v_flag when the following PL/SQL block is executed successfully? (I chose C)

DECLARE

v_flag BOOLEAN;

v_n NUMBER;

BEGIN

SELECT COUNT(*)

INTO v_n

FROM tab1;

v_flag := SQL%FOUND;

END;

A. The value is always FALSE.

B. The value is always NULL.

C. The value is always TRUE.

D. The value is FALSE if and only if the tab1 table is empty.

E. The value is TRUE if and only if the tab1 table is empty.

Reference no: EM13241138

Questions Cloud

Assume that the heights of 5 year old boys are normally : Assume that the heights of 5 year old boys are normally distribued with a mean of 100cm and a standard deviation of 60. What is the sampling distribution of the mean for a sample size of 900 and its confidence interval at the 99% level?

With a normal distribution of 50 and standard deviation : With a normal distribution of 50 and standard deviation of population =10, how do I figure out the score at the 40th percentile? How do figure out the % of scores falling above 70? How do figure out between what scores do the middle 50 percent of cas..

The examples of aspects of the romantic nature found : Give at least two concrete examples. The examples of aspects of the romantic nature found today need not be of art but may be found in some other aspect of culture, politics, etc. provide citations for your examples.

How do i determine if the difference between statistic : We have a "test" and a "control" group. We calculated a market share percentage for both groups, the test group was in a market that received advertising from our client, the control group was in a market that did not see advertising.

What is the value of v_flag : What is the value of v_flag when the following PL/SQL block is executed successfully?

State explicit null and alternate hypothesis : A telescpoe manufacturur wants its telescopes to have standard deviations in resolution to be significantly below 2 when focusing on objects 500 light-years away.

Discuss the the role mobile technologies : Discuss the the role mobile technologies can play in the launch of a new product

A telephone manufacturer want its telescope to have standard : A telephone manufacturer wants its telescope to have standard deviation in resolution to be significantly below 2 when focusing on object 500 light-years away.

Determine a sample size with confidence level : The central university has a student population of 60000. The university is interested in determining what proportion of them is in favour of a new grading system.

User Account

All Pages