Question 1

To add new data to a table,use the ____ command.

Accepted Answer

A) ADDTO 
B) DELETE 
C) INSERT 
D) SELECT 
A) ADDTO 
B) DELETE 
C) INSERT 
D) SELECT C

Question 2

When a query involves a character field,such as CustomerName,you must enclose the value to which the field is being compared in percent symbols (%).

Accepted Answer

A) True 
 B)False  False

Question 3

The ____ function determines the largest value in a given column.

Accepted Answer

A) LGE 
B) LARGE 
C) MAX 
D) MAXIMUM 
A) LGE 
B) LARGE 
C) MAX 
D) MAXIMUM C

Question 4

In order to make changes to existing data in a table,you would use the ____ command.

Accepted Answer

A) DELETE 
B) CHANGE 
C) SELECT 
D) UPDATE 
A) DELETE 
B) CHANGE 
C) SELECT 
D) UPDATE

Question 5

The rules for naming tables and columns are the same in every version of SQL.

Accepted Answer

A) True 
 B)False

Question 6

You can save the results of a query as a table by including the ____ clause in the query.

Accepted Answer

A) INTO 
B) INSERT 
C) UPDATE 
D) DELETE 
A) INTO 
B) INSERT 
C) UPDATE 
D) DELETE

Question 7

Based on the code above,find the name of the student whose ID is 1167.

Accepted Answer

A) SELECT FirstName,LastName FROM Course WHERE StudentID='1167' ; 
B) SELECT FirstName,LastName FROM Part WHERE StudentID='1167' ; 
C) SELECT FirstName,LastName FROM Student WHERE StudentID='1167' ; 
D) SELECT FirstName,LastName FROM Customer WHERE StudentID='1167' ; 
A) SELECT FirstName,LastName FROM Course WHERE StudentID='1167' ; 
B) SELECT FirstName,LastName FROM Part WHERE StudentID='1167' ; 
C) SELECT FirstName,LastName FROM Student WHERE StudentID='1167' ; 
D) SELECT FirstName,LastName FROM Customer WHERE StudentID='1167' ;

Question 8

When a subquery is used,____ is(are) evaluated first.

Accepted Answer

A) the subquery query 
B) the outer query 
C) both a and b simultaneously 
D) whichever query is selected to execute first by the user 
A) the subquery query 
B) the outer query 
C) both a and b simultaneously 
D) whichever query is selected to execute first by the user

Question 9

The IN operator can be used instead or the OR operator in phrasing certain conditions.

Accepted Answer

A) True 
 B)False

Question 10

When you connect simple conditions using the ____________________ operator,the compound condition will be true whenever any of the simple conditions are true.

Accepted Answer

The answer of When you connect simple conditions using the...

Question 11

There are two versions of the "not equal to" operator:  and !=.

Accepted Answer

A) True 
 B)False

Question 12

When you need to sort data on two fields,the more important sort key is called the ____________________ sort key.

Accepted Answer

The answer of When you need to sort data on...

Question 13

You can use the GROUP BY clause and the ORDER BY clause in the same SELECT statement.

Accepted Answer

A) True 
 B)False

Question 14

When used after the word SELECT,the ____ symbol indicates that you want to include all fields in the query results in the order in which you described them to the DBMS when you created the table.

Accepted Answer

A) & 
B) * 
C) $ 
D) # 
A) & 
B) * 
C) $ 
D) #

Question 15

When you enter numbers in an SQL command,you do not type commas or dollar signs.

Accepted Answer

A) True 
 B)False

Question 16

To qualify a field name,precede the name of the field with the name of the table,followed by a(n) ____________________.

Accepted Answer

The answer of To qualify a field name,precede the name...

Question 17

Based on the code above,delete any row in the OrderLine table in which the part number is BV06.

Accepted Answer

A) DELETE FROM OrderLine WHERE PartNum='BV06' ; 
B) DELETE FROM OrderLine WHERE PartNum=BV06 ; 
C) DELETE FROM OrderLine WHERE PartNum='BV06' 
D) DELETE FROM OrderLine WHERE PartNum='BV6' ; 
A) DELETE FROM OrderLine WHERE PartNum='BV06' ; 
B) DELETE FROM OrderLine WHERE PartNum=BV06 ; 
C) DELETE FROM OrderLine WHERE PartNum='BV06' 
D) DELETE FROM OrderLine WHERE PartNum='BV6' ;

Question 18

By using the word ____________________ in a query after a computation,you can assign a name to the computed field.

Accepted Answer

The answer of By using the word ____________________ in a...

Question 19

In SQL,you join tables by entering the appropriate conditions in the WHERE clause.

Accepted Answer

A) True 
 B)False

Question 20

In MySQL,you use the ____________________ function to concatenate fields.

Accepted Answer

The answer of In MySQL,you use the ____________________ function to...

To add new data to a table,use the ____ command.

When a query involves a character field,such as CustomerName,you must enclose the value to which the field is being compared in percent symbols (%).

The ____ function determines the largest value in a given column.

In order to make changes to existing data in a table,you would use the ____ command.

The rules for naming tables and columns are the same in every version of SQL.

You can save the results of a query as a table by including the ____ clause in the query.

Based on the code above,find the name of the student whose ID is 1167.

When a subquery is used,____ is(are) evaluated first.

The IN operator can be used instead or the OR operator in phrasing certain conditions.

When you connect simple conditions using the ____________________ operator,the compound condition will be true whenever any of the simple conditions are true.

There are two versions of the "not equal to" operator: <> and !=.

When you need to sort data on two fields,the more important sort key is called the ____________________ sort key.

You can use the GROUP BY clause and the ORDER BY clause in the same SELECT statement.

When used after the word SELECT,the ____ symbol indicates that you want to include all fields in the query results in the order in which you described them to the DBMS when you created the table.

When you enter numbers in an SQL command,you do not type commas or dollar signs.

To qualify a field name,precede the name of the field with the name of the table,followed by a(n) ____________________.

Based on the code above,delete any row in the OrderLine table in which the part number is BV06.

By using the word ____________________ in a query after a computation,you can assign a name to the computed field.

In SQL,you join tables by entering the appropriate conditions in the WHERE clause.

In MySQL,you use the ____________________ function to concatenate fields.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters

Exam 3: The Relational Model 2: SQL

To add new data to a table,use the ____ command.

When a query involves a character field,such as CustomerName,you must enclose the value to which the field is being compared in percent symbols (%).

The ____ function determines the largest value in a given column.

In order to make changes to existing data in a table,you would use the ____ command.

The rules for naming tables and columns are the same in every version of SQL.

You can save the results of a query as a table by including the ____ clause in the query.

Based on the code above,find the name of the student whose ID is 1167.

When a subquery is used,____ is(are) evaluated first.

The IN operator can be used instead or the OR operator in phrasing certain conditions.

When you connect simple conditions using the ____________________ operator,the compound condition will be true whenever any of the simple conditions are true.

There are two versions of the "not equal to" operator: <> and !=.

When you need to sort data on two fields,the more important sort key is called the ____________________ sort key.

You can use the GROUP BY clause and the ORDER BY clause in the same SELECT statement.

When used after the word SELECT,the ____ symbol indicates that you want to include all fields in the query results in the order in which you described them to the DBMS when you created the table.

When you enter numbers in an SQL command,you do not type commas or dollar signs.

To qualify a field name,precede the name of the field with the name of the table,followed by a(n) ____________________.

Based on the code above,delete any row in the OrderLine table in which the part number is BV06.

By using the word ____________________ in a query after a computation,you can assign a name to the computed field.

In SQL,you join tables by entering the appropriate conditions in the WHERE clause.

In MySQL,you use the ____________________ function to concatenate fields.

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters