Ch 2 Quiz (Kroenke) (1)

Ch 2 Quiz (Kroenke) (1) - I

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
In an SQL query, which SQL keyword actually creates the query? b. SELECT In an SQL query, which SQL keyword is used to specify the table(s) to be used? a.  FROM In an SQL query, which SQL keyword must be used to remove duplicate rows from the result  table?       b.  DISTINCT When one SQL query is embedded in the WHERE clause of another SQL query, this is referred  to as a ________. b.  subquery In an SQL query, which SQL keyword is used with GROUP BY to select groups meeting  specified criteria? c. HAVING In an SQL query, which SQL keyword is used to state the condition that specifies which rows  are to be selected?
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
d. WHERE In an SQL query, which of the following symbols is used by ANSI SQL to represent all the  columns in a single table? c. * (asterisk) Given a table with the structure: EMPLOYEE (EmpNo , Name, Salary, HireDate), which of the 
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/28/2011 for the course IT 101 taught by Professor K during the Spring '11 term at Richmond.

Page1 / 5

Ch 2 Quiz (Kroenke) (1) - I

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online