Question 1

In MySQL,the ____ is used as a wildcard to represent any collection of characters.

Accepted Answer

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

Question 2

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 3

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 4

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

Accepted Answer

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

Question 5

The HAVING clause is to groups what the WHERE clause is to rows.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

As you are working in MySQL,the most recent command you entered is stored in a special area of memory called the ____________________.

Accepted Answer

The answer of As you are working in MySQL,the most...

Question 8

SQL was developed under the name ____________________ at the IBM San Jose research facilities.

Accepted Answer

The answer of SQL was developed under the name ____________________...

Question 9

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,CreditLimit,Balance FROM Customer ; 
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 FROM Customer WHERE CreditLimit>Balance ; 
A) SELECT CustomerNum,CustomerName,CreditLimit,Balance FROM Customer ; 
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 FROM Customer WHERE CreditLimit>Balance ;

Question 10

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 11

SQL has built-in functions,which are also called ____________________ functions.

Accepted Answer

The answer of SQL has built-in functions,which are also called...

Question 12

In SQL,you use the SORT BY clause to display results in a desired order.

Accepted Answer

A) True 
 B)False

Question 13

Based on the code above,list the number,name,and balance of all customers with balances greater than or equal to $1,000 and less than or equal to $5,000.

Accepted Answer

A) SELECT CustomerNum,CustomerName,Balance FROM Customer WHERE Balance BETWEEN 1000 AND 5000 ; 
B) SELECT CustomerNum,CustomerName,Balance FROM Customer WHERE Balance > 1000 ; 
C) SELECT CustomerName,Balance FROM Customer WHERE Balance BETWEEN 1000 AND 5000 ; 
D) SELECT CustomerNum,CustomerName FROM Customer WHERE Balance BETWEEN 1000 AND 5000 ; 
A) SELECT CustomerNum,CustomerName,Balance FROM Customer WHERE Balance BETWEEN 1000 AND 5000 ; 
B) SELECT CustomerNum,CustomerName,Balance FROM Customer WHERE Balance > 1000 ; 
C) SELECT CustomerName,Balance FROM Customer WHERE Balance BETWEEN 1000 AND 5000 ; 
D) SELECT CustomerNum,CustomerName FROM Customer WHERE Balance BETWEEN 1000 AND 5000 ;

Question 14

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

In MySQL,the ____ is used as a wildcard to represent any collection of characters.

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

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

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

The HAVING clause is to groups what the WHERE clause is to rows.

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

As you are working in MySQL,the most recent command you entered is stored in a special area of memory called the ____________________.

SQL was developed under the name ____________________ at the IBM San Jose research facilities.

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

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

SQL has built-in functions,which are also called ____________________ functions.

In SQL,you use the SORT BY clause to display results in a desired order.

Based on the code above,list the number,name,and balance of all customers with balances greater than or equal to $1,000 and less than or equal to $5,000.

The basic form of an SQL retrieval command is ____.

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

In MySQL,the ____ is used as a wildcard to represent any collection of characters.

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

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

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

The HAVING clause is to groups what the WHERE clause is to rows.

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

As you are working in MySQL,the most recent command you entered is stored in a special area of memory called the ____________________.

SQL was developed under the name ____________________ at the IBM San Jose research facilities.

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

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

SQL has built-in functions,which are also called ____________________ functions.

In SQL,you use the SORT BY clause to display results in a desired order.

Based on the code above,list the number,name,and balance of all customers with balances greater than or equal to $1,000 and less than or equal to $5,000.

The basic form of an SQL retrieval command is ____.

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