0

programming languages Online Quiz - 131

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

select flightnumber, date, destination, boarded + transferred + nonrevenue as Total from marchflights where total < 100; What will happen when this query is submitted ?

  1. Error: as mathematical computation is not allowed while using proc sql.

  2. ERROR: The following columns were not found in the contributing tables: total.

  3. Warning : the type of the variable total is not declared(character or numeric).But due to automatic conversion, some unexpected value is being populated in variable total.

  4. Error: variable total nor recognized(because there are two spelling - Total and total)


Correct Option: B
  1. proc sql; select membertype sum(milestraveled) as TotalMiles from frequentflyers group by membertype;

  2. proc sql; select membertype sum(milestraveled) as TotalMiles from frequentflyers order by membertype;

  3. proc sql; select membertype milestraveled sum(milestraveled) as TotalMiles from sasuser.frequentflyers group by membertype;

  4. proc sql; select membertype sum(milestraveled) from frequentflyers group by membertype;


Correct Option: A
  1. This restricts the number of rows (observations) in the output to 10.

  2. Tells the system to process first 10 observation from a SAS dataset

  3. Restricts the system to read 10 observations.

  4. None of the above.


Correct Option: A
  1. No

  2. Yes

  3. Customers can determine for themselves where they want to use exits

  4. None of the Above


Correct Option: B

Refer to the following Code. What is the value of sy-fdpos and sy-subrc after the search is executed? Data: mystring type c value 'ARAMCO'. Search mystring for 'X'

  1. sy-fdpos = 0 and sy-subrc = 0

  2. sy-fdpos = 0 and sy-subrc = 4

  3. sy-fdpos = 4 and sy-subrc = 0

  4. sy-fdpos = 4 and sy-subrc = 4


Correct Option: B

Which of the following is not a valid ABAP data statement?

  1. Data fielda(5) type c

  2. Data fielda(5) type n

  3. Data fielda(5) type t

  4. Data fielda(5) type x


Correct Option: C
  1. Do not have buffering in the technical attributes

  2. Add the BYPASSING BUFFER clause on the select statement

  3. Buffering can be turned off on the application server by the programmer using the ABAP Workbench

  4. None of the Above


Correct Option: B

What is the value of ZFIELDB after the last line of the following code is executed? Data: ZFIELDA(5) type c value 'ABCDE'. ZFIELDB(4) type c. ZFIELDA = ‘XX’. Clear ZFIELDA. ZFIELDB = ZFIELDA.

  1. ABCDE

  2. Spaces

  3. ABCD

  4. BCDE


Correct Option: B

When catching errors using the CATCH…ENDCATCH statement, where does the runtime error return code get placed?

  1. sy-subrc

  2. sy-fdpos

  3. error class

  4. system-exceptions


Correct Option: D

When is it better to buffer the table?

  1. When a table is read infrequently

  2. When a table is read frequently and the data seldom changes

  3. When a table is read frequently and the data is always changing

  4. When a table is linked to check tables


Correct Option: B

Which is not a valid option of the Write Statement?

  1. NO-GAP

  2. Input

  3. Centered

  4. Under

  5. No-Zero


Correct Option: B

An internal table icode contains the following entries: Field1 Field2 -------------- John 12345 Alice 23478 Sam 54321 john 50000 DATA: BEGIN OF ICODE OCCURS 0, FIELD1(5), FIELD2(5), END OF ICODE. READ TABLE ICODE WITH KEY FIELD1 = 'John' BINARY SEARCH. Why does executing the above code return a sy-subrc of 4?

  1. Icode-field2 must be a numeric field.

  2. The internal table has an incorrect structure.

  3. Both internal table fields must be used in the search.

  4. The internal table must be sorted first.

  5. 'John' should not be capitalized.


Correct Option: D

What is the fastest way to move one internal table to another internal table (assuming two tables of similar structure)? a) append lines of table1 to table2. b) loop at table1. Move: table1-field1 to table2-field1, table1-field2 to table2-field2. Append table2. Endloop. c) table2[] = table1[]. d) loop at table1. Move-corresponding table1 to table2. Endloop.

  1. a

  2. b

  3. c

  4. d


Correct Option: C
- Hide questions