Question 1

The WHERE clause is always processed before the GROUP BY clause when both occur in a SELECT statement.

Accepted Answer

A) True 
 B)False

Question 2

DCL is used to update the database with new records.

Accepted Answer

A) True 
 B)False

Question 3

A view may not be updated directly if it contains:

Accepted Answer

A)  the distinct keyword. 
B)  derived columns and expressions in the select clause. 
C)  uses the group by or having clause. 
D)  all of the above. 
A)  the distinct keyword. 
B)  derived columns and expressions in the select clause. 
C)  uses the group by or having clause. 
D)  all of the above.

Question 4

The ________ is a set of commands used to maintain and query a database.

Accepted Answer

data manip

Question 5

What result set will the following query return?
Select item_no,description
From item
Where weight > 100 and weight < 200;

Accepted Answer

A)  The item_no and description for all items weighing less than 100 
B)  The item_no for all items weighing between 101 and 199 
C)  The item_no and description for all items weighing between 101 and 199 
D)  The item_no for all items weighing more than 200 
A)  The item_no and description for all items weighing less than 100 
B)  The item_no for all items weighing between 101 and 199 
C)  The item_no and description for all items weighing between 101 and 199 
D)  The item_no for all items weighing more than 200

Question 6

What does the following SQL statement do?
Update Product_T
Set Unit_Price = 775
Where Product_ID = 7

Accepted Answer

A)  Changes the price of a unit called Product_T to 7 
B)  Changes the unit price of Product 7 to 775 
C)  Changes the length of the Unit_Price field to 775 
D)  Updates the Product_T table to have a unit price of 775 
A)  Changes the price of a unit called Product_T to 7 
B)  Changes the unit price of Product 7 to 775 
C)  Changes the length of the Unit_Price field to 775 
D)  Updates the Product_T table to have a unit price of 775

Question 7

The DROP TABLE command causes tables to be ________,________,and ________ from the database.

Accepted Answer

removed,de

Question 8

The following query totals sales in state= 'MA' for each salesperson.
Select salesperson_id,sum(sales)
from salesperson
group by salesperson_id
having state = 'MA';

Accepted Answer

A) True 
 B)False

Question 9

The ________ SQL command defines a logical table from one or more tables.

Accepted Answer

The answer of The ________ SQL command defines a logical...

Question 10

When creating tables,it's important to decide which columns will allow null values before the table is created.

Accepted Answer

A) True 
 B)False

Question 11

A referential integrity constraint specifies that the existence of an attribute in one table depends upon the existence of a foreign key in the same or another table.

Accepted Answer

A) True 
 B)False

Question 12

A(n)________ is a set of schemas put together that represent a database description.

Accepted Answer

The answer of A(n)________ is a set of schemas put...

Question 13

Using aggregate functions will give a ________ answer.

Accepted Answer

The answer of Using aggregate functions will give a ________...

Question 14

The following two SQL statements will produce the same results.
Select last_name,first_name
from customer
where credit_limit > 99 and credit_limit < 10001;
Select last_name,first_name
from customer
where credit_limit between 100 and 10000;

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is the wildcard operator in SQL statements?

Accepted Answer

A)   
B)  * 
C)  = 
D)  & 
A)   
B)  * 
C)  = 
D)  &

Question 16

To get all the customers from Hawaii sorted together,which of the following would be used?

Accepted Answer

A)  Order By 
B)  Group By 
C)  Having 
D)  Sort 
A)  Order By 
B)  Group By 
C)  Having 
D)  Sort

Question 17

A single value returned from an SQL query that includes an aggregate function is called a(n):

Accepted Answer

A)  agate. 
B)  scalar aggregate. 
C)  vector aggregate. 
D)  summation. 
A)  agate. 
B)  scalar aggregate. 
C)  vector aggregate. 
D)  summation.

Question 18

The following query totals sales for each salesperson.
Select salesperson_id,sum(sales)
from salesperson
group by salesperson_id;

Accepted Answer

A) True 
 B)False

Question 19

The ________ is a set of commands used to define a database.

Accepted Answer

data defin

The WHERE clause is always processed before the GROUP BY clause when both occur in a SELECT statement.

DCL is used to update the database with new records.

A view may not be updated directly if it contains:

The ________ is a set of commands used to maintain and query a database.

What result set will the following query return? Select item_no,description From item Where weight > 100 and weight < 200;

What does the following SQL statement do? Update Product_T Set Unit_Price = 775 Where Product_ID = 7

The DROP TABLE command causes tables to be ,,and from the database.

The following query totals sales in state= 'MA' for each salesperson. Select salesperson_id,sum(sales) from salesperson group by salesperson_id having state = 'MA';

The ________ SQL command defines a logical table from one or more tables.

When creating tables,it's important to decide which columns will allow null values before the table is created.

A referential integrity constraint specifies that the existence of an attribute in one table depends upon the existence of a foreign key in the same or another table.

A(n)________ is a set of schemas put together that represent a database description.

Using aggregate functions will give a ________ answer.

The following two SQL statements will produce the same results. Select last_name,first_name from customer where credit_limit > 99 and credit_limit < 10001; Select last_name,first_name from customer where credit_limit between 100 and 10000;

Which of the following is the wildcard operator in SQL statements?

To get all the customers from Hawaii sorted together,which of the following would be used?

A single value returned from an SQL query that includes an aggregate function is called a(n):

The following query totals sales for each salesperson. Select salesperson_id,sum(sales) from salesperson group by salesperson_id;

The ________ is a set of commands used to define a database.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 6: Introduction to SQL

The WHERE clause is always processed before the GROUP BY clause when both occur in a SELECT statement.

DCL is used to update the database with new records.

A view may not be updated directly if it contains:

The ________ is a set of commands used to maintain and query a database.

What result set will the following query return? Select item_no,description From item Where weight > 100 and weight < 200;

What does the following SQL statement do? Update Product_T Set Unit_Price = 775 Where Product_ID = 7

The DROP TABLE command causes tables to be ________,________,and ________ from the database.

The following query totals sales in state= 'MA' for each salesperson. Select salesperson_id,sum(sales) from salesperson group by salesperson_id having state = 'MA';

The ________ SQL command defines a logical table from one or more tables.

When creating tables,it's important to decide which columns will allow null values before the table is created.

A referential integrity constraint specifies that the existence of an attribute in one table depends upon the existence of a foreign key in the same or another table.

A(n)________ is a set of schemas put together that represent a database description.

Using aggregate functions will give a ________ answer.

The following two SQL statements will produce the same results. Select last_name,first_name from customer where credit_limit > 99 and credit_limit < 10001; Select last_name,first_name from customer where credit_limit between 100 and 10000;

Which of the following is the wildcard operator in SQL statements?

To get all the customers from Hawaii sorted together,which of the following would be used?

A single value returned from an SQL query that includes an aggregate function is called a(n):

The following query totals sales for each salesperson. Select salesperson_id,sum(sales) from salesperson group by salesperson_id;

The ________ is a set of commands used to define a database.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

The DROP TABLE command causes tables to be ,,and from the database.