SAS3 - Quiz1-Final

1

Which of the these ORDER BY clauses will display the results ordered by decreasing Salary and then by increasing Name?

1

You cannot use SAS formats and labels to customize PROC SQL output

1

What column modifier is used to alter the appearance of the values in that column?

1

Which of the ff. is not true regarding PROC SQL?

1

To eliminate duplicate rows in query results, which keyword should be used?

1

The ALL keyword is true only if the comparison is true for all returned values

1

SQL uses set operators to combine tables horizontally

1

SQL uses joins to combine tables vertically

1

Full joins include all rows from both tables, even if there are no matching rows in either table

1

To familiarize yourself with the columns in a table, which statement should be used:

1

Inner joins enables a maximum of 256 tables to be joined at the same time.

1

SQL subqueries can return calues to be used in an outer query's FROM clause

1

Which keyword is used to check the SELECT statement syntax?

1

A type of joins that returns only the matching rows

1

A subquery can return several rows of data but must only return values from a single column

1

Given the following SELECT statement, describe the incorrect syntax********************************************************SELECT a,b,c FROM tblx ORDER BY b WHERE tblx.a > 10;

1

It is created by placing a query expression in a FROM clause where a table name would normally be used

1

Correlated subqueries can be evaluated independently

1

If a summary function specifies only one column name, the statistic is calculated down the columb (across rows)

1

In a correlated subquery, the inner query provides information so that the subquery resolves successfully

1

A condition that will evaluate to true if the subquery returns no data

1

When a SELECT list contains both a column created by a summary function and a column that is not summarized, by default, the summarized data is appended to each row of the original data table (remerged) in order to produce the output.

1

The COALESCE function returns the value of the first missing argument

1

If the summary function specifies more than one column, the statistic is calculated for the row (using values from the listed columns)

1

The COUNT function returns the number of columns returned by a query

1

If you specify the ANY keyword before a subquery, the comparison is true if it is false for any of the values that the subquery returns

1

Views often save space, because a view is usually quite small compared with the data that it accesses

1

To search for actual percent or underscore characters in your text using the LIKE operator, you must use an:

1

SQL subqueries can return values to be used in an outer query's FROM clause

1

What column modifier is used to alter the appearance of the values in that column?

1

Find the incorrect syntax on the ff. select statement:**********************proc sql; SELECT Employee_ID, Employee_Gender, Salary, from orion.Employee_Payroll where Employee_Gender='F' order by Salary desc; quit;

1

Which of the following is not a feature of SELECT statement

1

How many tables can be combines using a single inner join?

1

The HAVING clause is processed before the GROUP BY clause and determines which groups will be displayed

1

Which of the follwing statements is true when processing an inner join in PROC SQL

1

Outer joins can only be performed on two tables at a time

1

Which of the following is not true regarding subqueries

1

A query corresponds to a single SELECT statement within a DATA step

1

The IN CLAUSE specifies the criteria in outer joins

1

To create and populate a table with the rows from an SQL query, which of the following statement should be used:

1

The EQUAL operator does not accept any expression that resolves to more than a single value

1

The WHERE clause is processed before a GROUP BY clause and determines which individual rows are available for grouping

1

Which of the following WHERE clauses correctly selects rows with a Job_Code value that begins with a underscore?

1

Which of these DATA step statements is used to combine tables horizontally?

1

In an ORDER BY clause, order the query results by specifying the following except for:

1

Correlated subqueries use very few resources and are inexpensive to execute

1

When using an askterisk for the select list, you can specify the FEEDBACK option to write the expanded SELECT statement to the SAS log

1

A subquery can return severa rows of data but must only return values from a single column

1

Left joins include all rows from the second table, even if there are no matching rows in the first table

1

What column modifier is used to alter the appearance of the values in that column?

OT for sas3

SAS3 - Quiz1-Final

Which of the these ORDER BY clauses will display the results ordered by decreasing Salary and then by increasing Name?

You cannot use SAS formats and labels to customize PROC SQL output

What column modifier is used to alter the appearance of the values in that column?

Which of the ff. is not true regarding PROC SQL?

To eliminate duplicate rows in query results, which keyword should be used?

The ALL keyword is true only if the comparison is true for all returned values

SQL uses set operators to combine tables horizontally

SQL uses joins to combine tables vertically

Full joins include all rows from both tables, even if there are no matching rows in either table

To familiarize yourself with the columns in a table, which statement should be used:

Inner joins enables a maximum of 256 tables to be joined at the same time.

SQL subqueries can return calues to be used in an outer query's FROM clause

Which keyword is used to check the SELECT statement syntax?

A type of joins that returns only the matching rows

A subquery can return several rows of data but must only return values from a single column

Given the following SELECT statement, describe the incorrect syntax********************************************************SELECT a,b,c FROM tblx ORDER BY b WHERE tblx.a > 10;

It is created by placing a query expression in a FROM clause where a table name would normally be used

Correlated subqueries can be evaluated independently

If a summary function specifies only one column name, the statistic is calculated down the columb (across rows)

In a correlated subquery, the inner query provides information so that the subquery resolves successfully