Deck 2: Introduction to Structured Query Language SQL

Question 1

SQL is not a complete programming language.Rather it is a data sublanguage.

Answer 1

True

Question 2

SQL can only query a single table.

Answer 2

False

Question 3

SQL was developed by IBM in the late 1970s.

Answer 3

True

Question 4

SQL stands for Standard Query Language.

Question 5

SQL includes a data definition language,a data manipulation language,and SQL/Persistent stored modules.

Question 6

The American National Standards Institute (ANSI)maintains the standards for SQL.

Question 7

The columns to be obtained by an SQL command are listed after the FROM keyword.

Question 8

The SQL keyword SELECT is used to specify the columns to be listed in the query results.

Question 9

The SQL keyword FROM is used to specify the table to be used.

Question 10

The SQL WHERE clause contains the condition that specifies which rows are to be selected.

Question 11

To remove duplicate rows from the result of a query,specify the SQL DISTINCT keyword.

Question 12

SQL is only a data manipulation language (DML).

Question 13

SQL statements end with a colon.

Question 14

To obtain all columns,use an asterisk (*)wildcard character instead of listing all the column names.

Question 15

SQL,although very popular,has never become a national standard.

Question 16

SQL commands can be embedded in application programs.

Question 17

The result of an SQL SELECT operation can contain duplicate rows.

Question 18

In addition to being a data sublanguage,SQL is also a programming language,like Java or C#.

Question 19

The SQL keyword WHERE is used to specify the table(s)that contain(s)the data to be retrieved.

Question 20

To have SQL automatically eliminate duplicate rows from a result,use the keyword DISTINCT with the FROM keyword.

Question 21

A WHERE clause can contain only one condition.

Question 22

To sort the rows of the result table,the ORDER BY clause is specified.

Question 23

An asterisk (*)following the SELECT verb means that all columns are to be displayed.

Question 24

The condition in WHERE clauses can refer to a set of values by using the IN operator.

Question 25

The SQL built-in function MOST obtains the largest value in a numeric column.

Question 26

The WHERE clause contains the condition that specifies which columns are to be selected.

Question 27

When two conditions must both be true for the rows to be selected,the conditions are separated by the SQL AND keyword.

Question 28

The SQL wildcard character "#" indicates a single,unspecified character in a specific location in an SQL query.

Question 29

To refer to a set of values in a condition,the values are placed inside parenthesis ( )and separated by commas.

Question 30

The Microsoft Access wildcard character "*" (asterisk)indicates a sequence of one or more unspecified characters in a Microsoft Access SQL query.

Question 31

The Microsoft Access wildcard character "_" (underscore)indicates a single,unspecified character in a specific location in a Microsoft Access SQL query.

Question 32

The SQL built-in function ADDUP totals values in numeric columns.

Question 33

The rows of the result table can be sorted by the values in one or more columns.

Question 34

The SQL wildcard character "%" represents a series of one or more unspecified characters.

Question 35

To exclude one or more values using a condition,the SQL OUT keyword must be used.

Question 36

Columns can be sorted in descending sequence by using the SQL DESC keyword.

Question 37

Sorting is specified by the use of the SORT BY phrase.

Question 38

The SQL keyword LIKE is used in SQL expressions to select on partial values.

Question 39

To refer to a set of values needed for a condition,use the SQL IN operator.

Question 40

The SQL built-in function AVG computes the average of values in numeric columns.

Question 41

The clause SELECT COUNT (*)results in a table with a single row and a single column.

Question 42

Only two tables can be queried by using a subquery.

Question 43

The SQL built-in function MIN obtains the smallest value in a numeric column.

Question 44

A WHERE clause can contain another SELECT statement enclosed in parentheses.

Question 45

The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

Question 46

The names of tables to be joined in an SQL query are listed in the FROM clause.

Question 47

When making an SQL query,we are using SQL as a(n)________.

A)DDL
B)DML
C)embedded language
D)SET
E)WHERE

Question 48

Two or more tables are joined by giving the table names in the WHERE clause and specifying the equality of the respective column names as a condition in the GROUP BY clause.

Question 49

The built-in function SUM can be used with any column.

Question 50

Arithmetic in SQL statements is limited to the operations provided by the built-in functions.

Question 51

In an SQL query,a join operation is achieved by specifying the equality of the respective column names as a condition in the WHERE clause.

Question 52

While many subqueries can be alternatively written as joins,correlated subqueries do work that cannot be duplicated as a join.

Question 53

The SQL built-in function COUNT computes the number of rows in a query.

Question 54

Every subquery can be alternatively expressed by a join.

Question 55

SQL is a ________.

A)data sublanguage
B)product of IBM research
C)national standard
D)combination that include a data definition language and a data manipulation language
E)All of the above.

Question 56

When people use the term "join" they normally mean an "equijoin."

Question 57

A SELECT statement used in a WHERE clause is called a subquery.

Question 58

A nested SELECT statement (one that appears within the WHERE clause of another SQL statement)is called a subquery and must be enclosed in parentheses.

Question 59

In an SQL query,which SQL keyword actually creates the query?

A)EXISTS
B)FROM
C)SELECT
D)SET
E)WHERE

Question 60

An alternative to combining tables by a subquery is to use a join.

Question 61

Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the following would find all employees whose name begins with the letter "S" using standard SQL?

A)SELECT *
FROM EMPLOYEE
WHERE Name IN ['S'];
B)SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S';
C)SELECT *
FROM Name
WHERE EMPLOYEE LIKE 'S*';
D)SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
E)None of the above.

Question 62

In an SQL query,which SQL keyword must be used to remove duplicate rows from the result table?

A)DELETE
B)DISTINCT
C)NOT EXISTS
D)UNIQUE
E)KEY

Question 63

In an SQL query,which SQL keyword is used to sort the result table by the values in one or more columns?

A)GROUP BY
B)ORDER BY
C)SELECT
D)SORT BY
E)WHERE

Question 64

In an SQL query,which built-in function is used to compute the average value of numeric columns?

A)AVG
B)MEAN
C)MAX
D)MIN
E)SUM

Question 65

In an SQL query,which SQL keyword is used to join two conditions that both must be true for the rows to be selected?

A)AND
B)EXISTS
C)HAVING
D)IN
E)OR

Question 66

In an SQL query,which SQL keyword is used to state the condition that specifies which rows are to be selected?

A)EXISTS
B)FROM
C)SELECT
D)SET
E)WHERE

Question 67

Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the following would find all employees whose name begins with the letter "S" using Microsoft Access?

A)SELECT *
FROM EMPLOYEE
WHERE Name IN ['S'];
B)SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S';
C)SELECT *
FROM Name
WHERE EMPLOYEE LIKE 'S*';
D)SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';
E)None of the above.

Question 68

In an SQL query,which SQL keyword is used with GROUP BY to select groups meeting specified criteria?

A)AND
B)EXISTS
C)HAVING
D)IN
E)WHERE

Question 69

In an SQL query,which built-in function is used to total numeric columns?

A)AVG
B)COUNT
C)MAX
D)MEAN
E)SUM

Question 70

In an SQL query,which SQL keyword is used to determine if a column value is equal to any one of a set of values?

A)AND
B)EXISTS
C)HAVING
D)IN
E)OR

Question 71

In an SQL query,which of the following symbols is used by ANSI SQL to represent all the columns in a single table?

A)_ (underscore)
B)? (question mark)
C)* (asterisk)
D)% (percent)
E)# (pound)

Question 72

In an SQL query,which SQL keyword is used to specify the table(s)to be used?

A)EXISTS
B)FROM
C)SELECT
D)SET
E)WHERE

Question 73

In an SQL query,which of the following symbols is used by ANSI SQL to represent a single unspecified character?

A)_ (underscore)
B)? (question mark)
C)* (asterisk)
D)% (percent)
E)# (pound)

Question 74

In an SQL query,which of the following symbols is used by Microsoft Access to represent a single unspecified character?

A)_ (underscore)
B)? (question mark)
C)* (asterisk)
D)% (percent)
E)# (pound)

Question 75

In an SQL query,which built-in function is used to obtain the smallest value of numeric columns?

A)AVG
B)COUNT
C)MAX
D)MIN
E)SUM

Question 76

In an SQL query,which built-in function is used to obtain the largest value of numeric columns?

A)AVG
B)COUNT
C)MAX
D)MIN
E)SUM

Question 77

In an SQL query,which built-in function is used to compute the number of rows in a table?

A)AVG
B)COUNT
C)MAX
D)MIN
E)MEAN

Question 78

In an SQL query,the built-in functions SUM and AVG work with columns containing data of which of the following data types?

A)Integer
B)Numeric
C)Char
D)A and B
E)A,B and C

Question 79

In an SQL query,which SQL keyword is used with built-in functions to group together rows that have the same value in a specified column?

A)GROUP BY
B)ORDER BY
C)SELECT
D)SORT BY
E)DISTINCT SET

Question 80

In an SQL query,the built-in function COUNT works with columns containing data of which of the following data types?

A)Integer
B)Numeric
C)Char
D)A and B
E)A,B and C