SQL SERVER 2000 QUIZ

file

report

form

table

XML

DML

DDL

HTML

Data Integrity

Normalization

All of these

Materialized Views

percent sign (%); underscore (_)

question mark (?); asterisk (*)

asterisk (*); percent sign (%)

underscore(_); question mark (?)

SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;

SELECT city, temperature, humidity, country FROM location;

SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city;

SELECT weather.city, temperature, humidity, country FROM weather, location;

as a wildcard.

to limit the columns displayed.

None of these

for ranges.

INSERT VALUES INTO student (

INSERT student VALUES (

INSERT INTO student VALUES (

INSERT VALUES (

False

True

SINGLE

UNIQUE

ONLY

DISTINCT

SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

None of These

SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;

SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;