Quiz 3

Descrição

College Stats 224 Quiz sobre Quiz 3, criado por James Blair em 12-03-2015.
James Blair
Quiz por James Blair, atualizado more than 1 year ago
James Blair
Criado por James Blair mais de 9 anos atrás
10
0

Resumo de Recurso

Questão 1

Questão
Which of the following statements regarding the ALTER TABLE statement is false?
Responda
  • a. It allows you to update column attributes.
  • b. It allows you to drop columns in your table.
  • c. It allows you to change a character column to a numeric column.
  • d. It allows you to add new columns in your table.

Questão 2

Questão
Which of the following is not a type of integrity constraint?
Responda
  • a. NULL
  • b. UNIQUE
  • c. PRIMARY KEY
  • d. CHECK

Questão 3

Questão
Which of the following PROC SQL steps gives bonuses (in points) to frequent-flyer program members as follows: a 50% bonus for members who traveled less than 10,000 miles a 100% bonus for members who traveled 10,000 miles or more?
Responda
  • a. proc sql; update work.frequentflyers set pointsearned=pointsearned* case when milestraveled < 10000 then pointsearned*1.5 when milestraveled >= 10000 then pointsearned*2 else pointsearned*1 end;
  • b. proc sql; update work.frequentflyers set pointsearned=pointsearned* case if milestraveled < 10000 then pointsearned*1.5 if milestraveled >= 10000 then pointsearned*2 else pointsearned*1 end;
  • c. proc sql; update work.frequentflyers set pointsearned=pointsearned* case when milestraveled < 10000 then 1.5 when milestraveled >= 10000 then 2 else 1 end;
  • d. proc sql; update work.frequentflyers set pointsearned=pointsearned* case if milestraveled < 10000 then 1.5 if milestraveled >= 10000 then 2 else 1 end;

Questão 4

Questão
Which of the following creates an empty table that contains the 2 columns FullName and Age?
Responda
  • a. proc sql; create work.names (FullName char(25), Age num);
  • b. proc sql; create table work.names set (FullName char(25), Age num);
  • c. proc sql; create table work.names (FullName char(25), Age num);
  • d. proc sql; create table work.names as (FullName char(25), Age num);

Questão 5

Questão
Which statement is false regarding the keyword CORRESPONDING?
Responda
  • a. It cannot be used with the keyword ALL.
  • b. When used in EXCEPT, INTERSECT, and UNION set operations, it removes any columns not found in both tables.
  • c. It overlays columns by name, not by position.
  • d. When used in OUTER UNION set operations, it causes same-named columns to be overlaid.

Questão 6

Questão
Using an index is not likely to optimize a PROC SQL query in which of the following situations?
Responda
  • a. The query contains an IN subquery that references the key column.
  • b. The query is an equijoin, and all the columns in the join expression are indexed in one of the tables being joined.
  • c. The key column is specified only in a SELECT clause.
  • d. The key column is specified in a WHERE clause expression that contains a comparison operator, the TRIM or SUBSTR function, the CONTAINS operator, or the LIKE operator.

Questão 7

Questão
Which of the following will create a composite index for the table Sasuser.Flightdelays? (Sasuser.Flightdelays contains the following columns: Date, FlightNumber, Origin, Destination, DelayCategory, DestinationType, DayOfWeek, and Delay.)
Responda
  • a. proc sql; create composite index places on sasuser.flightdelays (flightnumber, destination);
  • b. proc sql; create index on flightnumber,destination from sasuser.flightdelays (places);
  • c. proc sql; create index destination on sasuser.flightdelays(flightnumber, destination);
  • d. proc sql; create index places on sasuser.flightdelays (flightnumber, destination);

Questão 8

Questão
Which keyword must you add to your index definition in the CREATE INDEX statement to ensure that no duplicate values of the key column can exist?
Responda
  • a. KEY
  • b. UNIQUE
  • c. NODUPKEY
  • d. NODUPS

Questão 9

Questão
Which of the following is false regarding the IDXNAME= data set option?
Responda
  • a. The option allows you to create and name an index on the table.
  • b. The option directs SAS to use an index that you specify.
  • c. The specified index must be suitable by having at least its first or only column match a condition in the WHERE expression.
  • d. The specified index must exist.

Questão 10

Questão
In order for PROC SQL to perform an inner join,
Responda
  • a. the columns that are specified in a join condition in the WHERE clause must have the same data type.
  • b. the columns that are specified in a join condition in the WHERE clause must have the same name.
  • c. the tables being joined must contain the same number of columns.
  • d. the tables must be sorted before they are joined.

Semelhante

CRACKMAN_70
Terry Yan
CRACKMAN_70
静雯 周
ECO 351 - Business Statistics II - SAS Terminology
LemonKing
Study Guide 13 - Winter 2015
John Bench
Congruency Theorems
Alyxandria Hodgin
Stats 124 Final Review
James Blair
Selena gomez doğru yanlış testi
turunculai
Final Quiz 3
Madalyn Geuke
Quiz #3
rubenetulodii
Chapter 12: Combining SAS Data Sets
James Blair
SAS3 - Quiz1-Final
Xtine Ramos