0

programming languages Online Quiz - 125

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

In Java, to copy the contents of a to a new Foo object b

  1. Foo b = a;

  2. Foo b = a.clone();

  3. Foo b;b=a;

  4. -


Correct Option: B
  1. join conditions are not specified in a PROC SQL join.

  2. join conditions are not specified in a PROC SQL set operatio

  3. more than two tables are specified in a PROC SQL join.

  4. the keyword ALL is used with the OUTER UNION operator.


Correct Option: A

Which statement about the following PROC SQL query is false? proc sql; validate select name label=’Country’, rate label=’Literacy Rate’ from world.literacy where ’Asia’ = (select continent from world.continents where literacy.name = continents.country) order by 2;

  1. The query syntax is not valid.

  2. The outer query must pass values to the subquery before the subquery can return values to the outer query.

  3. PROC SQL will not execute this query when it is submitted.

  4. After the query is submitted, the SAS log will indicate whether the query has valid syntax.


Correct Option: A
  1. the tables being joined must contain the same number of columns.

  2. the tables must be sorted before they are joined

  3. the columns that are specified in a join condition in the WHERE clause must have the same data type.

  4. the columns that are specified in a join condition in the WHERE clause must have the same name.


Correct Option: C

A PROC SQL inner join can combine

  1. a maximum of 2 tables or in-line views, but multiple joins can be chained together.

  2. a maximum of 32 tables or 2 in-line views.

  3. a maximum of 32 tables, which includes any tables referenced by an in-line view.

  4. a maximum of 2 tables and 32 columns.


Correct Option: C

Which PROC SQL query will remove duplicate values of MemberType from the query output, so that only the unique values are listed?

  1. proc sql nodup; select membertype from sasuser.frequentflyers;

  2. proc sql; select distinct(membertype) as MemberType from sasuser.frequentflyers;

  3. proc sql; select unique membertype from sasuser.frequentflyers group by membertype;

  4. proc sql; select distinct membertype from sasuser.frequentflyers;


Correct Option: D
  1. ID Salary Bonus 123 70000 5000 456 80000 7000 978 55000 3500

  2. ID Salary Bonus 123 70000 5000 456 80000 7000 744 . 3500

  3. ID Salary Bonus 123 70000 5000 456 80000 7000 744 55000 3500

  4. ID Salary Bonus 123 70000 5000 456 80000 7000 978 55000 .


Correct Option: D
  1. Table aliases must be used when referencing identical table names from different libraries.

  2. Table aliases can be referenced by using the keyword AS.

  3. Table aliases (or full table names) must be used when referencing a column name that is the same in two or more tables.

  4. Table aliases must be used when using summary functions.


Correct Option: D
  1. WHERE address is missing

  2. WHERE address not exists

  3. WHERE address is null

  4. both a and c


Correct Option: D
  1. proc sql; select name, spent, 120-spent as calculated Balance from Company.Absences where balance <= 0;

  2. proc sql; select name, spent, 120-spent as Balance from Company.Absences where calculated balance <= 0;

  3. proc sql; select name, spent, 120-spent as Balance from Company.Absences where balance <= 0;

  4. proc sql; select name, spent, 120-spent as calculated Balance from Company.Absences where calculated balance <= 0;


Correct Option: B
  1. df

  2. def

  3. deef

  4. deeef

  5. all the above


Correct Option: E

To copy entire matched sequence

  1. $&

  2. $%

  3. $_

  4. $@

  5. $^


Correct Option: A

$input = “abdce” =~ tr/abc/123 print $input;

  1. 123

  2. 123ce

  3. Cant modify constant item in translation

  4. 12d3e

  5. None of the above


Correct Option: C

$string = “\uhello world!”; print $string; $string = “\Uhello world!”; print $string;

  1. Hello world HELLO WORLD.

  2. Hello World HELLO WORLD.

  3. Hello world HELLO world.

  4. hello world HELLO WORLD.


Correct Option: A
- Hide questions