QUESTION: 45

A table is created with the following DDL:

CREATE TABLE Test (
Column1 CHAR(2) NOT NULL)
UNIQUE PRIMARY INDEX(Column1);

The data inserted into Column1 looks like the following:
Column1
50
35
79

Which query will have optimal performance, given the data inserted into Column1?

SELECT Column1 FROM Test WHERE Column1=35;
SELECT Column1 FROM Test WHERE Column1='35';
SELECT Column1 FROM Test WHERE Column1(INTEGER)=35;
SELECT Column1 FROM Test WHERE CAST(Column1 AS INTEGER)=35;

Answer(s): C

Reveal Solution Next Question

QUESTION: 46

The stores table contains the following data:

store_id city state
----------- ------------------------- -----
1 Big Sur CA
2 Monterey CA
3 Napa CA
4 Oceanside CA
5 Rancho Bernardo CA
6 Sonoma CA
7 Algiers Point LA
8 New Orleans LA
9 Charlotte NC
10 North Wilkesboro NC
11 Midway UT
12 Moab UT
13 Park City UT
14 Springdale UT
15 Charleston WV
16 White Sulfur Springs WV

Given the following SQL statement:
SELECT city
, state
, SAMPLEID
FROM stores
SAMPLE WITH REPLACEMENT
WHEN state = 'UT' THEN 4, 2
WHEN state = 'WV' THEN 2, 1
ELSE 10, 5 END ORDER BY 3;

How many rows are returned?