Question 1

Based on the code above,list the number,name,and complete address of every customer located on a street that contains the letters "Oxford".​

Accepted Answer

A)  ​SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "?Oxford" ; 
B)  ​SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "%Oxford%" ; 
C)  ​SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "@Oxford@" ; 
D)  ​SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "Oxford" ; 
A)  ​SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "?Oxford" ; 
B)  ​SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "%Oxford%" ; 
C)  ​SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "@Oxford@" ; 
D)  ​SELECT CustomerNum, CustomerName, Street, City, State, PostalCode FROM Customer WHERE Street LIKE "Oxford" ;

Question 2

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

Accepted Answer

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

Question 3

​Words that are part of the SQL language are called ____________________.

Accepted Answer

The answer of ​Words that are part of the SQL...

Question 4

When you connect simple conditions using the AND operator,all the simple conditions must be false for the compound condition to be true.​

Accepted Answer

A) True 
 B)False

Question 5

What are some common restrictions placed on table and column names by DBMSs?​

Accepted Answer

Some common restrictions are: 1.The name

Question 6

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 7

Many versions of SQL other than Access use the ____________________ as a wildcard to represent any individual character.​

Accepted Answer

underscore

Question 8

The BETWEEN operator is an essential feature of SQL.​

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

Based on the code above,change the postal code of the student with ID 11433 to 14455.​

Accepted Answer

A)  ​UPDATE Student SET PostalCode='14455' ; 
B)  ​UPDATE Student SET PostalCode WHERE StudentID='11433' ; 
C)  ​UPDATE Student IN PostalCode='14455' WHERE StudentID='11433' ; 
D)  ​UPDATE Student SET PostalCode='14455' WHERE StudentID='11433' ; 
A)  ​UPDATE Student SET PostalCode='14455' ; 
B)  ​UPDATE Student SET PostalCode WHERE StudentID='11433' ; 
C)  ​UPDATE Student IN PostalCode='14455' WHERE StudentID='11433' ; 
D)  ​UPDATE Student SET PostalCode='14455' WHERE StudentID='11433' ;

Question 12

Instead of listing all the field names in the SELECT clause,you can use the @ symbol.​

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 * 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 * WHERE StudentID='1167' ; 
C)  ​SELECT FirstName, LastName FROM Student WHERE StudentID='1167' ; 
D)  ​SELECT FirstName, LastName FROM Customer WHERE StudentID='1167' ;

Question 15

A simple condition includes the field name,a comparison operator,and either another field name or a value.​

Accepted Answer

A) True 
 B)False

Question 16

When rows are grouped,one line of output is produced for each group.​

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

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

Question 18

In Access,you use the ____________________ operator to concatenate fields.​

Accepted Answer

The answer of In Access,you use the ____________________ operator to...

Question 19

Based on the code above,list the name of every student whose postal code is 10113.​

Accepted Answer

A)  ​SELECT FirstName, LastName WHERE PostalCode='10113' ; 
B)  ​SELECT FirstName, LastName FROM Student WHERE PostalCode='10113' ; 
C)  ​SELECT FirstName, LastName FROM Student WHERE PostalCode='10113' 
D)  ​SELECT * FROM Student WHERE PostalCode='10113' ; 
A)  ​SELECT FirstName, LastName WHERE PostalCode='10113' ; 
B)  ​SELECT FirstName, LastName FROM Student WHERE PostalCode='10113' ; 
C)  ​SELECT FirstName, LastName FROM Student WHERE PostalCode='10113' 
D)  ​SELECT * FROM Student WHERE PostalCode='10113' ;

Question 20

The two tables involved in a union must have the same structure,or be ____________________.​

Accepted Answer

The answer of The two tables involved in a union...

Based on the code above,list the number,name,and complete address of every customer located on a street that contains the letters "Oxford".

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

Words that are part of the SQL language are called ____________________.

When you connect simple conditions using the AND operator,all the simple conditions must be false for the compound condition to be true.

What are some common restrictions placed on table and column names by DBMSs?

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

Many versions of SQL other than Access use the ____________________ as a wildcard to represent any individual character.

The BETWEEN operator is an essential feature of SQL.

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

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

Based on the code above,change the postal code of the student with ID 11433 to 14455.

Instead of listing all the field names in the SELECT clause,you can use the @ symbol.

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

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

A simple condition includes the field name,a comparison operator,and either another field name or a value.

When rows are grouped,one line of output is produced for each group.

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

In Access,you use the ____________________ operator to concatenate fields.

Based on the code above,list the name of every student whose postal code is 10113.

The two tables involved in a union must have the same structure,or be ____________________.

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

Based on the code above,list the number,name,and complete address of every customer located on a street that contains the letters "Oxford".​

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

​Words that are part of the SQL language are called ____________________.

When you connect simple conditions using the AND operator,all the simple conditions must be false for the compound condition to be true.​

What are some common restrictions placed on table and column names by DBMSs?​

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

Many versions of SQL other than Access use the ____________________ as a wildcard to represent any individual character.​

The BETWEEN operator is an essential feature of SQL.​

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

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

Based on the code above,change the postal code of the student with ID 11433 to 14455.​

Instead of listing all the field names in the SELECT clause,you can use the @ symbol.​

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

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

A simple condition includes the field name,a comparison operator,and either another field name or a value.​

When rows are grouped,one line of output is produced for each group.​

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

In Access,you use the ____________________ operator to concatenate fields.​

Based on the code above,list the name of every student whose postal code is 10113.​

The two tables involved in a union must have the same structure,or be ____________________.​

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

Based on the code above,list the number,name,and complete address of every customer located on a street that contains the letters "Oxford".

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

Words that are part of the SQL language are called ____________________.

When you connect simple conditions using the AND operator,all the simple conditions must be false for the compound condition to be true.

What are some common restrictions placed on table and column names by DBMSs?

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

Many versions of SQL other than Access use the ____________________ as a wildcard to represent any individual character.

The BETWEEN operator is an essential feature of SQL.

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

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

Based on the code above,change the postal code of the student with ID 11433 to 14455.

Instead of listing all the field names in the SELECT clause,you can use the @ symbol.

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

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

A simple condition includes the field name,a comparison operator,and either another field name or a value.

When rows are grouped,one line of output is produced for each group.

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

In Access,you use the ____________________ operator to concatenate fields.

Based on the code above,list the name of every student whose postal code is 10113.

The two tables involved in a union must have the same structure,or be ____________________.