Kopieren und bearbeiten

SAS3 - Quiz1-Final

Beschreibung

OT for sas3
Xtine Ramos
Quiz von Xtine Ramos, aktualisiert more than 1 year ago
Xtine Ramos
Erstellt von Xtine Ramos vor fast 8 Jahre
106
0
0

Zusammenfassung der Ressource

Frage 1

Frage
Which of the these ORDER BY clauses will display the results ordered by decreasing Salary and then by increasing Name?
Antworten
  • order by Salary desc, Name
  • order by descending Salary, Name
  • order by desc Salary, Name
  • order by desc Salary, ascending Name

Frage 2

Frage
You cannot use SAS formats and labels to customize PROC SQL output
Antworten
  • True
  • False

Frage 3

Frage
What column modifier is used to alter the appearance of the values in that column?
Antworten
  • FORMAT=
  • LABEL=
  • LABELX=
  • INFORMAT=

Frage 4

Frage
Which of the ff. is not true regarding PROC SQL?
Antworten
  • 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.

Frage 5

Frage
To eliminate duplicate rows in query results, which keyword should be used?
Antworten
  • DISTINCT
  • VALIDATE
  • SINGLE
  • NODUP

Frage 6

Frage
The ALL keyword is true only if the comparison is true for all returned values
Antworten
  • True
  • False

Frage 7

Frage
SQL uses set operators to combine tables horizontally
Antworten
  • True
  • False

Frage 8

Frage
SQL uses joins to combine tables vertically
Antworten
  • True
  • False

Frage 9

Frage
Full joins include all rows from both tables, even if there are no matching rows in either table
Antworten
  • True
  • False

Frage 10

Frage
To familiarize yourself with the columns in a table, which statement should be used:
Antworten
  • DESCRIBE
  • PROPERTY
  • CONTENT
  • FEATURES

Frage 11

Frage
Inner joins enables a maximum of 256 tables to be joined at the same time.
Antworten
  • True
  • False

Frage 12

Frage
SQL subqueries can return calues to be used in an outer query's FROM clause
Antworten
  • True
  • False

Frage 13

Frage
Which keyword is used to check the SELECT statement syntax?
Antworten
  • VALIDATE
  • NOERROR
  • CHECK
  • DETERMINE

Frage 14

Frage
A type of joins that returns only the matching rows
Antworten
  • INNER JOIN
  • OUTER JOIN
  • LEFT JOIN
  • RIGHT JOIN

Frage 15

Frage
A subquery can return several rows of data but must only return values from a single column
Antworten
  • True
  • False

Frage 16

Frage
Given the following SELECT statement, describe the incorrect syntax********************************************************SELECT a,b,c FROM tblx ORDER BY b WHERE tblx.a > 10;
Antworten
  • arrangement of clauses
  • missing comma
  • missing semi-colon
  • none of the above

Frage 17

Frage
It is created by placing a query expression in a FROM clause where a table name would normally be used
Antworten
  • IN LINE VIEW
  • subquery
  • virtual table
  • nested query

Frage 18

Frage
Correlated subqueries can be evaluated independently
Antworten
  • True
  • False

Frage 19

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

Frage 20

Frage
In a correlated subquery, the inner query provides information so that the subquery resolves successfully
Antworten
  • True
  • False

Frage 21

Frage
A condition that will evaluate to true if the subquery returns no data
Antworten
  • NOT EXIST
  • NOT IN
  • IN
  • EXIST

Frage 22

Frage
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.
Antworten
  • True
  • False

Frage 23

Frage
The COALESCE function returns the value of the first missing argument
Antworten
  • True
  • False

Frage 24

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

Frage 25

Frage
The COUNT function returns the number of columns returned by a query
Antworten
  • True
  • False

Frage 26

Frage
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
Antworten
  • True
  • False

Frage 27

Frage
Views often save space, because a view is usually quite small compared with the data that it accesses
Antworten
  • True
  • False

Frage 28

Frage
To search for actual percent or underscore characters in your text using the LIKE operator, you must use an:
Antworten
  • ESCAPE CLAISE
  • FREE CLAUSE
  • LIKE CLAUSE
  • EXIT CLAUSE

Frage 29

Frage
SQL subqueries can return values to be used in an outer query's FROM clause
Antworten
  • True
  • False

Frage 30

Frage
What column modifier is used to alter the appearance of the values in that column?
Antworten
  • FORMAT=
  • LABELX=
  • LABEL=
  • INFORMAT=

Frage 31

Frage
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;
Antworten
  • exceeds use of comma
  • missing semi-colon
  • missing quote
  • missing comma

Frage 32

Frage
Which of the following is not a feature of SELECT statement
Antworten
  • queries to two tables
  • specifies an order for the data
  • selects data that meets certain conditions
  • formats the data

Frage 33

Frage
How many tables can be combines using a single inner join?
Antworten
  • 256
  • 10
  • 2
  • 5

Frage 34

Frage
The HAVING clause is processed before the GROUP BY clause and determines which groups will be displayed
Antworten
  • True
  • False

Frage 35

Frage
Which of the follwing statements is true when processing an inner join in PROC SQL
Antworten
  • 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

Frage 36

Frage
Outer joins can only be performed on two tables at a time
Antworten
  • True
  • False

Frage 37

Frage
Which of the following is not true regarding subqueries
Antworten
  • 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.

Frage 38

Frage
A query corresponds to a single SELECT statement within a DATA step
Antworten
  • True
  • False

Frage 39

Frage
The IN CLAUSE specifies the criteria in outer joins
Antworten
  • True
  • False

Frage 40

Frage
To create and populate a table with the rows from an SQL query, which of the following statement should be used:
Antworten
  • CREATE TABLE
  • CREATE QUERY
  • CREATE VIEW
  • CREATE POPULATE

Frage 41

Frage
The EQUAL operator does not accept any expression that resolves to more than a single value
Antworten
  • True
  • False

Frage 42

Frage
The WHERE clause is processed before a GROUP BY clause and determines which individual rows are available for grouping
Antworten
  • True
  • False

Frage 43

Frage
Which of the following WHERE clauses correctly selects rows with a Job_Code value that begins with a underscore?
Antworten
  • where Job_Code like '/_%' escape '/'
  • where Job_Code contains '_%'
  • where Job_Code like '%_' exit '/_'
  • where Job_Code like '_%'

Frage 44

Frage
Which of these DATA step statements is used to combine tables horizontally?
Antworten
  • MERGE
  • SET
  • JOINS
  • APPEND

Frage 45

Frage
In an ORDER BY clause, order the query results by specifying the following except for:
Antworten
  • 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

Frage 46

Frage
Correlated subqueries use very few resources and are inexpensive to execute
Antworten
  • True
  • False

Frage 47

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

Frage 48

Frage
A subquery can return severa rows of data but must only return values from a single column
Antworten
  • True
  • False

Frage 49

Frage
Left joins include all rows from the second table, even if there are no matching rows in the first table
Antworten
  • True
  • False

Frage 50

Frage
What column modifier is used to alter the appearance of the values in that column?
Antworten
  • FORMAT=
  • LABEL=
  • LABELX=
  • INFORMAT=
Zusammenfassung anzeigen Zusammenfassung ausblenden

Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.

ähnlicher Inhalt

CRACKMAN_70
Terry Yan
CRACKMAN_70
静雯 周
ECO 351 - Business Statistics II - SAS Terminology
LemonKing
COTA VS OTR
Syd Bauer
Congruency Theorems
Alyxandria Hodgin
Stats 124 Final Review
James Blair
Selena gomez doğru yanlış testi
turunculai
Chapter 12: Combining SAS Data Sets
James Blair
Old Testament
thomaswiggs
Old Testament
jeffersonja
Client Factors
Pratik P
Bibliothek durchsuchen