Question 1

​You can combine values in character fields.

Accepted Answer

A) True 
 B)False

Question 2

In SQL,you sort data using the ____________________ clause.​

Accepted Answer

The answer of In SQL,you sort data using the ____________________...

Question 3

A WHERE and a HAVING clause cannot be included in the same query.​

Accepted Answer

A) True 
 B)False

Question 4

Based on the code above,list the complete student table.​

Accepted Answer

A)  ​SELECT Student ; 
B)  ​SELECT "ampersand" FROM Student ; 
C)  ​SELECT * FROM Student ; 
D)  ​SELECT LastName, FirstName, Street, City, State, PostalCode FROM Student 
A)  ​SELECT Student ; 
B)  ​SELECT "ampersand" FROM Student ; 
C)  ​SELECT * FROM Student ; 
D)  ​SELECT LastName, FirstName, Street, City, State, PostalCode FROM Student

Question 5

The ____ clause can be used to create groups of records.​

Accepted Answer

A)  ​AGGREGATE 
B)  ​SORT BY 
C)  ​ORDER BY 
D)  ​GROUP BY 
A)  ​AGGREGATE 
B)  ​SORT BY 
C)  ​ORDER BY 
D)  ​GROUP BY

Question 6

Based on the code above,find how many items are in category TOY.​

Accepted Answer

A)  ​SELECT SUM(*) FROM Item WHERE Category='TOY' ; 
B)  ​SELECT COUNT(*) FROM Item WHERE Category='TOY' ; 
C)  ​SELECT COUNT FROM Item WHERE Category='TOY' ; 
D)  ​SELECT COUNT* FROM Item WHERE Category='TOY' ; 
A)  ​SELECT SUM(*) FROM Item WHERE Category='TOY' ; 
B)  ​SELECT COUNT(*) FROM Item WHERE Category='TOY' ; 
C)  ​SELECT COUNT FROM Item WHERE Category='TOY' ; 
D)  ​SELECT COUNT* FROM Item WHERE Category='TOY' ;

Question 7

Based on the code above,list the number and name of all customers that are either represented by sales rep 30 or that currently have orders on file,or both.​

Accepted Answer

A)  ​SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer ; 
B)  ​SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders WHERE Customer.CustomerNum=Orders.CustomerNum ; 
C)  ​SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' WHERE Customer.CustomerNum=Orders.CustomerNum ; 
D)  ​SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders ; 
A)  ​SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer ; 
B)  ​SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders WHERE Customer.CustomerNum=Orders.CustomerNum ; 
C)  ​SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' WHERE Customer.CustomerNum=Orders.CustomerNum ; 
D)  ​SELECT CustomerNum, CustomerName, FROM Customer WHERE RepNum='30' UNION SELECT Customer.CustomerNum, CustomerName, FROM Customer, Orders ;

Question 8

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)  ​ampersand 
C)  ​# 
D)  ​$ 
A)  ​* 
B)  ​ampersand 
C)  ​# 
D)  ​$

Question 9

When you use a name containing a space in Access SQL,you must ____.​

Accepted Answer

A)  ​enclose it in quotation marks 
B)  ​enclose it in square brackets 
C)  ​enclose it in asterisks 
D)  ​enclose it in question marks 
A)  ​enclose it in quotation marks 
B)  ​enclose it in square brackets 
C)  ​enclose it in asterisks 
D)  ​enclose it in question marks

Question 10

​The ____________________ data type stores integers,but uses less space than INTEGER.

Accepted Answer

The answer of ​The ____________________ data type stores integers,but uses...

Question 11

You use the SQL ____________________ command to create a table by describing its layout.​

Accepted Answer

The answer of You use the SQL ____________________ command to...

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

A field whose values you derive from existing fields is called a(n)____________________ field.​

Accepted Answer

computed
c

Question 14

​Many versions of SQL require you to end a command with a ____.

Accepted Answer

A)  ​comma (,) 
B)  ​period (.) 
C)  ​colon (:) 
D)  ​semicolon (;) 
A)  ​comma (,) 
B)  ​period (.) 
C)  ​colon (:) 
D)  ​semicolon (;)

Question 15

Based on the code above,list the number,name,credit limit,and balance for all customers with credit limits that exceed their balances.​

Accepted Answer

A)  ​SELECT CustomerNum, CustomerName FROM Customer WHERE CreditLimit>Balance ; 
B)  ​SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ; 
C)  ​SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE CreditLimit>Balance ; 
D)  ​SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer ; 
A)  ​SELECT CustomerNum, CustomerName FROM Customer WHERE CreditLimit>Balance ; 
B)  ​SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ; 
C)  ​SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE CreditLimit>Balance ; 
D)  ​SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer ;

You can combine values in character fields.

In SQL,you sort data using the ____________________ clause.

A WHERE and a HAVING clause cannot be included in the same query.

Based on the code above,list the complete student table.

The ____ clause can be used to create groups of records.

Based on the code above,find how many items are in category TOY.

Based on the code above,list the number and name of all customers that are either represented by sales rep 30 or that currently have orders on file,or both.

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 use a name containing a space in Access SQL,you must ____.

The ____________________ data type stores integers,but uses less space than INTEGER.

You use the SQL ____________________ command to create a table by describing its layout.

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

A field whose values you derive from existing fields is called a(n)____________________ field.

Many versions of SQL require you to end a command with a ____.

Based on the code above,list the number,name,credit limit,and balance for all customers with credit limits that exceed their balances.

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