This is a timed quiz.
You have 1 hour to complete the 50 questions in this quiz.
Which of the these ORDER BY clauses will display the results ordered by decreasing Salary and then by increasing Name?
order by Salary desc, Name
order by descending Salary, Name
order by desc Salary, Name
order by desc Salary, ascending 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?
FORMAT=
LABEL=
LABELX=
INFORMAT=
Which of the ff. is not true regarding PROC SQL?
PROC SQL is terminated with a RUN statement
Each statement is processed individually.
The PROC SQL statement does not need to be repeated with each query.
No PROC PRINT step is needed to view query results.
To eliminate duplicate rows in query results, which keyword should be used?
DISTINCT
VALIDATE
SINGLE
NODUP
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:
DESCRIBE
PROPERTY
CONTENT
FEATURES
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?
NOERROR
CHECK
DETERMINE
A type of joins that returns only the matching rows
INNER JOIN
OUTER JOIN
LEFT JOIN
RIGHT JOIN
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;
arrangement of clauses
missing comma
missing semi-colon
none of the above
It is created by placing a query expression in a FROM clause where a table name would normally be used
IN LINE VIEW
subquery
virtual table
nested query
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
A condition that will evaluate to true if the subquery returns no data
NOT EXIST
NOT IN
IN
EXIST
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.
The COALESCE function returns the value of the first missing argument
If the summary function specifies more than one column, the statistic is calculated for the row (using values from the listed columns)
The COUNT function returns the number of columns returned by a query
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
Views often save space, because a view is usually quite small compared with the data that it accesses
To search for actual percent or underscore characters in your text using the LIKE operator, you must use an:
ESCAPE CLAISE
FREE CLAUSE
LIKE CLAUSE
EXIT CLAUSE
SQL subqueries can return values to be used in an outer query's FROM clause
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;
exceeds use of comma
missing quote
Which of the following is not a feature of SELECT statement
queries to two tables
specifies an order for the data
selects data that meets certain conditions
formats the data
How many tables can be combines using a single inner join?
256
10
2
5
The HAVING clause is processed before the GROUP BY clause and determines which groups will be displayed
Which of the follwing statements is true when processing an inner join in PROC SQL
Builds the cartesian product of all tables listed and applies the WHERE clause to limit the rows returned
applies the WHERE clause to limit the rows returned then build the Cartesian product of all the tables listed and
builds the Cartesian product of all the tables listed and display the results
no need to build the Cartesian product of all the tables listed and applies the WHERE clause to limit the rows returned
Outer joins can only be performed on two tables at a time
Which of the following is not true regarding subqueries
Can return single row with multiple columns
return values to be used in the outer query’s WHERE or HAVING clause
can return single or multiple values
must return only a single column.
A query corresponds to a single SELECT statement within a DATA step
The IN CLAUSE specifies the criteria in outer joins
To create and populate a table with the rows from an SQL query, which of the following statement should be used:
CREATE TABLE
CREATE QUERY
CREATE VIEW
CREATE POPULATE
The EQUAL operator does not accept any expression that resolves to more than a single value
The WHERE clause is processed before a GROUP BY clause and determines which individual rows are available for grouping
Which of the following WHERE clauses correctly selects rows with a Job_Code value that begins with a underscore?
where Job_Code like '/_%' escape '/'
where Job_Code contains '_%'
where Job_Code like '%_' exit '/_'
where Job_Code like '_%'
Which of these DATA step statements is used to combine tables horizontally?
MERGE
SET
JOINS
APPEND
In an ORDER BY clause, order the query results by specifying the following except for:
a combination of any of the above, with individual items separated by semi-colon
an expression
a column name or a number representing the position of an item in the SELECT list
any column name from any table in the FROM clause, even if the column is not in the SELECT list
Correlated subqueries use very few resources and are inexpensive to execute
When using an askterisk for the select list, you can specify the FEEDBACK option to write the expanded SELECT statement to the SAS log
A subquery can return severa rows of data but must only return values from a single column
Left joins include all rows from the second table, even if there are no matching rows in the first table
