Quiz 3

Descripción

College Stats 224 Test sobre Quiz 3, creado por James Blair el 12/03/2015.
James Blair
Test por James Blair, actualizado hace más de 1 año
James Blair
Creado por James Blair hace más de 9 años
10
0

Resumen del Recurso

Pregunta 1

Pregunta
Which of the following statements regarding the ALTER TABLE statement is false?
Respuesta
  • 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.

Pregunta 2

Pregunta
Which of the following is not a type of integrity constraint?
Respuesta
  • a. NULL
  • b. UNIQUE
  • c. PRIMARY KEY
  • d. CHECK

Pregunta 3

Pregunta
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?
Respuesta
  • 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;

Pregunta 4

Pregunta
Which of the following creates an empty table that contains the 2 columns FullName and Age?
Respuesta
  • 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);

Pregunta 5

Pregunta
Which statement is false regarding the keyword CORRESPONDING?
Respuesta
  • 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.

Pregunta 6

Pregunta
Using an index is not likely to optimize a PROC SQL query in which of the following situations?
Respuesta
  • 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.

Pregunta 7

Pregunta
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.)
Respuesta
  • 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);

Pregunta 8

Pregunta
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?
Respuesta
  • a. KEY
  • b. UNIQUE
  • c. NODUPKEY
  • d. NODUPS

Pregunta 9

Pregunta
Which of the following is false regarding the IDXNAME= data set option?
Respuesta
  • 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.

Pregunta 10

Pregunta
In order for PROC SQL to perform an inner join,
Respuesta
  • 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.
Mostrar resumen completo Ocultar resumen completo

Similar

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