Question 1

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 2

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

Accepted Answer

A)  ​INSERT 
B)  ​APPEND 
C)  ​ADDTO 
D)  ​SELECT 
A)  ​INSERT 
B)  ​APPEND 
C)  ​ADDTO 
D)  ​SELECT

Question 3

Preceding a condition by the NOT operator reverses the truth or falsity of the original condition.​

Accepted Answer

A) True 
 B)False

Question 4

Describe five data types that you will often encounter when working with databases.​

Accepted Answer

​
INTEGER: Stores integers,which are num

Question 5

The basic form of an SQL retrieval command is ____.​

Accepted Answer

A)  ​SELECT-WHERE-FROM 
B)  ​CREATE-SELECT-FROM 
C)  SELECT-WHERE​ 
D)  ​SELECT-FROM-WHERE 
A)  ​SELECT-WHERE-FROM 
B)  ​CREATE-SELECT-FROM 
C)  SELECT-WHERE​ 
D)  ​SELECT-FROM-WHERE

Question 6

Use the ____________________ data type for fields that contain letters and other special characters,and for fields that contain numbers that will not be used for arithmetic.​

Accepted Answer

The answer of Use the ____________________ data type for fields...

Question 7

Based on the code above,list the descriptions of all items that are located in Storehouse3 and for which there are more than 20 units on hand.​

Accepted Answer

A)  ​SELECT Description FROM Item WHERE Storehouse='3' AND OnHand>20 ; 
B)  ​SELECT Description FROM Item WHERE Storehouse='3' OR OnHand>20 ; 
C)  ​SELECT Description FROM Item WHERE Storehouse='3' ; 
D)  ​SELECT Description FROM Customer WHERE Storehouse='3' AND OnHand>20 ; 
A)  ​SELECT Description FROM Item WHERE Storehouse='3' AND OnHand>20 ; 
B)  ​SELECT Description FROM Item WHERE Storehouse='3' OR OnHand>20 ; 
C)  ​SELECT Description FROM Item WHERE Storehouse='3' ; 
D)  ​SELECT Description FROM Customer WHERE Storehouse='3' AND OnHand>20 ;

Question 8

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

Accepted Answer

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

Question 9

​In Access SQL,the ____ is used as a wildcard to represent any individual character.

Accepted Answer

A)  ​asterisks (*) 
B)  ​percent sign (%) 
C)  ​underscore (_) 
D)  ​question mark (?) 
A)  ​asterisks (*) 
B)  ​percent sign (%) 
C)  ​underscore (_) 
D)  ​question mark (?)

Question 10

The IN operator provides a concise way of phrasing certain conditions.​

Accepted Answer

A) True 
 B)False

Question 11

Based on the code above,list the number,name,street,and credit limit of all customers.Order the customers by name within descending credit limit.​

Accepted Answer

A)  ​SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer SORT BY CreditLimit DESC, CustomerName ; 
B)  ​SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer SORT BY CreditLimit ASC, CustomerName ; 
C)  ​SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ; 
D)  ​SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit ASC, CustomerName ; 
A)  ​SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer SORT BY CreditLimit DESC, CustomerName ; 
B)  ​SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer SORT BY CreditLimit ASC, CustomerName ; 
C)  ​SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ; 
D)  ​SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit ASC, CustomerName ;

Question 12

​Describe how to construct a detailed query in a step-by-step fashion.

Accepted Answer

To construct a detailed query in a step-

Question 13

You can use the SQL CREATE TABLE command to insert rows into a table.​

Accepted Answer

A) True 
 B)False

Question 14

Based on the code above,delete any row in the OrderLine table in which the item number is MT03.​

Accepted Answer

A)  ​DELETE FROM OrderLine WHERE ItemNum='MT03' ; 
B)  ​DELETE FROM OrderLine WHERE ItemNum=MT03; 
C)  ​DELETE FROM OrderLine WHERE ItemNum='MT03' 
D)  ​DELETE FROM OrderLine WHERE ItemNum='MT3' ; 
A)  ​DELETE FROM OrderLine WHERE ItemNum='MT03' ; 
B)  ​DELETE FROM OrderLine WHERE ItemNum=MT03; 
C)  ​DELETE FROM OrderLine WHERE ItemNum='MT03' 
D)  ​DELETE FROM OrderLine WHERE ItemNum='MT3' ;

Question 15

SQL uses commands to create tables,update tables,and retrieve data from tables.​

Accepted Answer

A) True 
 B)False

Question 16

In a SELECT statement,the WHERE clause is mandatory.​

Accepted Answer

A) True 
 B)False

Question 17

There is no difference between the COUNT function and the SUM function.​

Accepted Answer

A) True 
 B)False

Question 18

​Fields will appear in the query results in the order in which they are listed in the SELECT clause.

Accepted Answer

A) True 
 B)False

Question 19

To use a wildcard,include the ____ operator in the WHERE clause.​

Accepted Answer

A)  ​LIKE 
B)  ​AS 
C)  ​BETWEEN 
D)  ​UNION 
A)  ​LIKE 
B)  ​AS 
C)  ​BETWEEN 
D)  ​UNION

Question 20

The ____________________ of two tables is a table containing all rows that are in either the first table,the second table,or both.​

Accepted Answer

The answer of The ____________________ of two tables is a...

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

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

Preceding a condition by the NOT operator reverses the truth or falsity of the original condition.

Describe five data types that you will often encounter when working with databases.

The basic form of an SQL retrieval command is ____.

Use the ____________________ data type for fields that contain letters and other special characters,and for fields that contain numbers that will not be used for arithmetic.

Based on the code above,list the descriptions of all items that are located in Storehouse3 and for which there are more than 20 units on hand.

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

In Access SQL,the ____ is used as a wildcard to represent any individual character.

The IN operator provides a concise way of phrasing certain conditions.

Based on the code above,list the number,name,street,and credit limit of all customers.Order the customers by name within descending credit limit.

Describe how to construct a detailed query in a step-by-step fashion.

You can use the SQL CREATE TABLE command to insert rows into a table.

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

SQL uses commands to create tables,update tables,and retrieve data from tables.

In a SELECT statement,the WHERE clause is mandatory.

There is no difference between the COUNT function and the SUM function.

Fields will appear in the query results in the order in which they are listed in the SELECT clause.

To use a wildcard,include the ____ operator in the WHERE clause.

The ____________________ of two tables is a table containing all rows that are in either the first table,the second table,or both.

Introduction to Database Management

The Relational : Introduction, QBE, and Relational Algebra

The Relational : Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters

Exam 3: The Relational : SQL

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

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

Preceding a condition by the NOT operator reverses the truth or falsity of the original condition.​

Describe five data types that you will often encounter when working with databases.​

The basic form of an SQL retrieval command is ____.​

Use the ____________________ data type for fields that contain letters and other special characters,and for fields that contain numbers that will not be used for arithmetic.​

Based on the code above,list the descriptions of all items that are located in Storehouse3 and for which there are more than 20 units on hand.​

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

​In Access SQL,the ____ is used as a wildcard to represent any individual character.

The IN operator provides a concise way of phrasing certain conditions.​

Based on the code above,list the number,name,street,and credit limit of all customers.Order the customers by name within descending credit limit.​

​Describe how to construct a detailed query in a step-by-step fashion.

You can use the SQL CREATE TABLE command to insert rows into a table.​

Based on the code above,delete any row in the OrderLine table in which the item number is MT03.​

SQL uses commands to create tables,update tables,and retrieve data from tables.​

In a SELECT statement,the WHERE clause is mandatory.​

There is no difference between the COUNT function and the SUM function.​

​Fields will appear in the query results in the order in which they are listed in the SELECT clause.

To use a wildcard,include the ____ operator in the WHERE clause.​

The ____________________ of two tables is a table containing all rows that are in either the first table,the second table,or both.​

Introduction to Database Management

The Relational : Introduction, QBE, and Relational Algebra

The Relational : Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Dbms Functions

Database Administration

Database Management Approaches

Filters

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

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

Preceding a condition by the NOT operator reverses the truth or falsity of the original condition.

Describe five data types that you will often encounter when working with databases.

The basic form of an SQL retrieval command is ____.

Use the ____________________ data type for fields that contain letters and other special characters,and for fields that contain numbers that will not be used for arithmetic.

Based on the code above,list the descriptions of all items that are located in Storehouse3 and for which there are more than 20 units on hand.

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

In Access SQL,the ____ is used as a wildcard to represent any individual character.

The IN operator provides a concise way of phrasing certain conditions.

Based on the code above,list the number,name,street,and credit limit of all customers.Order the customers by name within descending credit limit.

Describe how to construct a detailed query in a step-by-step fashion.

You can use the SQL CREATE TABLE command to insert rows into a table.

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

SQL uses commands to create tables,update tables,and retrieve data from tables.

In a SELECT statement,the WHERE clause is mandatory.

There is no difference between the COUNT function and the SUM function.

Fields will appear in the query results in the order in which they are listed in the SELECT clause.

To use a wildcard,include the ____ operator in the WHERE clause.

The ____________________ of two tables is a table containing all rows that are in either the first table,the second table,or both.