Tag: programming languages

Questions Related to programming languages

You create the following PL/SQL block: DECLARE var1 CONSTANT NUMBER := 50; var2 NUMBER := 0; BEGIN SELECT acctno INTO var2 FROM bank_acct WHERE name = 'JORDAN'; var1 :=var2 + 2000; END; Which of the following lines in this block of PL/SQL code will produce an error?

technology programming languages

  1. var2 NUMBER := 0;

  2. INTO var2

  3. WHERE name = 'JORDAN';

  4. var1 :=var2 + 2000;

  5. There are no errors in this PL/SQL block

Show answer
Correct Option: D

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) var2 NUMBER := 0; - This line is correct. It declares a variable var2 of type NUMBER and initializes it with a value of 0. There is no error in this line.

Option B) INTO var2 - This line is correct. It is part of the SELECT statement and specifies that the result of the SELECT query should be stored in the variable var2. There is no error in this line.

Option C) WHERE name = 'JORDAN'; - This line is correct. It is part of the SELECT statement and specifies the condition for the WHERE clause. It filters the rows based on the value of the name column equal to 'JORDAN'. There is no error in this line.

Option D) var1 :=var2 + 2000; - This line will produce an error. The variable var1 is declared as a constant using the CONSTANT keyword. Constants cannot be assigned new values once they are declared. Therefore, trying to assign a new value to var1 will result in an error.

Option E) There are no errors in this PL/SQL block - This option is incorrect. As explained above, the line var1 :=var2 + 2000; will produce an error. Therefore, there is an error in this PL/SQL block.

The correct answer is D. This line (var1 :=var2 + 2000;) will produce an error because var1 is declared as a constant and cannot be assigned a new value.

What statements must be used in order to raise a user-defined exception in PL/SQL?
technology programming languages

  1. RAISE

  2. PRAGMA EXCEPTION_INIT

  3. OTHERS

  4. EXCEPTION

Show answer
Correct Option: A,D

What will be the output of the following: void main() { int i; for(i=1;i<=4;i++) { printf("%d",i); continue; } }
technology programming languages

  1. 1

  2. 1234

  3. 123

  4. 234

Show answer
Correct Option: B

What will be the output of the following: void main() { float a=0.7; if(a<0.7) printf("c++"); else printf("c"); }
technology programming languages

  1. c++

  2. c

  3. Compile time error

  4. None of these

Show answer
Correct Option: A

What will be the output of the following: void main() { char * const ptr="abc"; ptr="xyz"; printf("%s",ptr); }
technology programming languages

  1. abc

  2. xyz

  3. Compile time error

  4. None of these

Show answer
Correct Option: C

What will be the output of the following: void main() { char const *ptr="abc"; ptr="xyz"; printf("%s",ptr); }
technology programming languages

  1. None of these

  2. Compile time error

  3. abc

  4. xyz

Show answer
Correct Option: D

What will be the output of the following: void main() { register int a; printf("%d",a); }
technology programming languages

  1. 0

  2. Garbage value

  3. Compile time error

  4. 1

Show answer
Correct Option: B

What is the use of the double trailing "@@" in an input statement?
technology programming languages

  1. loads a new record into the input buffer if an end-of-record is found in the current record

  2. holds the current data line in the buffer for another input statement to process

  3. can be used to read multiple observations from a single data line

  4. is a syntax error

Show answer
Correct Option: B,C

The following SAS program is submitted: data work.month; date = put('13mar2000'd,ddmmyy10.); run; Which one of the following represents the type and length of the variable DATE in the output data set?
technology programming languages

  1. numeric, 8 bytes

  2. numeric, 10 bytes

  3. character, 8 bytes

  4. character, 10 bytes

Show answer
Correct Option: D

A raw data file is listed below: --------10-------20-------30 1901 2 1905 1 1910 6 1925 . 1941 1 The following SAS program is submitted and references the raw data file above: data coins; infile 'file-specification'; input year quantity; run; Which one of the following completes the program and produces a non-missing value for the variable TOTQUANTITY in the last observation of the output data set?

technology programming languages

  1. totquantity = sum(totquantity + quantity);

  2. totquantity + quantity;

  3. totquantity 0; sum totquantity;

  4. retain totquantity 0; totquantity = totquantity + quantity;

Show answer
Correct Option: B

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) totquantity = sum(totquantity + quantity);

  • This option is incorrect because the sum function is unnecessary in this context. The sum function is typically used to calculate the sum of multiple variables, but here we only need to add the quantity to the existing value of totquantity.

Option B) totquantity + quantity;

  • This option is correct because it adds the quantity to the existing value of totquantity. By using the "+" operator, the value of totquantity will be updated correctly.

Option C) totquantity 0; sum totquantity;

  • This option is incorrect because it has a syntax error. It seems that the code is trying to assign a value of 0 to totquantity, but the correct syntax should be "totquantity = 0;" instead of "totquantity 0;". Additionally, the "sum" statement is unnecessary in this context.

Option D) retain totquantity 0; totquantity = totquantity + quantity;

  • This option is incorrect because it uses the retain statement, which is not necessary in this case. The retain statement is used to retain the value of a variable across iterations of the data step, but here we don't need to retain the value of totquantity.

The correct answer is B) totquantity + quantity. This option is correct because it adds the quantity to the existing value of totquantity, producing the desired result.