0

programming languages Online Quiz - 285

Description: programming languages Online Quiz - 285
Number of Questions: 20
Created by:
Tags: programming languages
Attempted 0/20 Correct 0 Score 0

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

  1. RAISE

  2. PRAGMA EXCEPTION_INIT

  3. OTHERS

  4. EXCEPTION


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; } }

  1. 1

  2. 1234

  3. 123

  4. 234


Correct Option: B

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

  1. abc

  2. xyz

  3. Compile time error

  4. None of these


Correct Option: C

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

  1. None of these

  2. Compile time error

  3. abc

  4. xyz


Correct Option: D

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

  1. 0

  2. Garbage value

  3. Compile time error

  4. 1


Correct Option: B
  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


Correct Option: B,C
  1. The program executes successfully and a temporary SAS data set is created

  2. The program executes successfully and a permanent SAS data set is created

  3. The program fails execution because the same SAS data set is referenced for both read and write operations

  4. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries


Correct Option: B

The following SAS program is submitted: data work.new; length word $7; amount = 7; if amount = 5 then word = 'CAT'; else if amount = 7 then word = 'DOG'; else word = 'NONE!!!'; amount = 5; run; Which one of the following represents the values of the AMOUNT and WORD variables?

  1. amount word ------ 5 DOG

  2. amount word ------ 5 CAT

  3. amount word ------ 7 DOG

  4. amount word ------ 7 ' ' (missing character value)


Correct Option: A
  1. It exists only for the duration of the DATA step.

  2. It is saved with the data set.

  3. It can be used in procedures.

  4. It can be the same as the name of a variable in the data set.


Correct Option: A

The following SAS program is submitted: data work.test; array agent{4} $ 12 sales1 – sales4; run; Which one of the following represents the variables that are contained in the output data set?

  1. SALES1, SALES2, SALES3, SALES4

  2. AGENTS1, AGENTS2, AGENTS3, AGENTS4

  3. None, the DATA step fails because the ARRAY statement can reference only numeric data

  4. None


Correct Option: A
  1. the data portion only

  2. the descriptor portion only

  3. the descriptor portion and the data portion

  4. neither the data portion nor the descriptor portion


Correct Option: A

The following SAS program is submitted using the raw data file as input: data work.homework; input name $ age height; if age LE 10; cards; John McCloskey 35 71 June Rosesette 10 43 TinekeJones 9 37 ; run; How many observations will the WORK.HOMEWORK data set contain?

  1. No data set is created as the program fails to execute due to errors

  2. 0

  3. 2

  4. 3


Correct Option: A

Which is not a Datawindow Buffer?

  1. Primary!

  2. Delete!

  3. Original!

  4. Sort!


Correct Option: D

Which will be the best method to handle DB transactions if number of connections are limited?

  1. SetTransObject()

  2. SetTrans()

  3. SetDBTrans()

  4. SetLimitTrans()


Correct Option: B
- Hide questions