Question 1

The HAVING clause and the WHERE clause perform the same operation.

Accepted Answer

A) True 
 B)False  False

Question 2

To eliminate duplicate rows in a query,the ________ qualifier is used in the SQL Select command.

Accepted Answer

A)  alter 
B)  distinct 
C)  check 
D)  specific 
A)  alter 
B)  distinct 
C)  check 
D)  specific B

Question 3

A catalog is the structure that contains object descriptions created by a user.

Accepted Answer

A) True 
 B)False  False

Question 4

A ________ view is materialized when referenced.

Accepted Answer

A)  virtual 
B)  dynamic 
C)  materialized 
D)  base 
A)  virtual 
B)  dynamic 
C)  materialized 
D)  base

Question 5

What steps should be followed when preparing to create a table?

Accepted Answer

When preparing to create a table,one sho

Question 6

What result set will the following query return?
Select item_no
From order_v
Where quantity > 10;

Accepted Answer

A)  The item_no of all orders that had more than 10 items 
B)  The order_id of all orders that had more than one item 
C)  The order_id of all orders that had more than 10 items 
D)  The item_no of all orders that had 10 or more items 
A)  The item_no of all orders that had more than 10 items 
B)  The order_id of all orders that had more than one item 
C)  The order_id of all orders that had more than 10 items 
D)  The item_no of all orders that had 10 or more items

Question 7

Indexes are created in most RDBMSs to:

Accepted Answer

A)  provide a quicker way to store data. 
B)  decrease the amount of disk space utilized. 
C)  provide rapid random and sequential access to base-table data. 
D)  increase the cost of implementation. 
A)  provide a quicker way to store data. 
B)  decrease the amount of disk space utilized. 
C)  provide rapid random and sequential access to base-table data. 
D)  increase the cost of implementation.

Question 8

The DROP command deletes rows from a table individually or in groups.

Accepted Answer

A) True 
 B)False

Question 9

Some DBMS can handle graphic data types,as well as text and numbers.

Accepted Answer

A) True 
 B)False

Question 10

A database is maintained and queried using the data mapping language (DML).

Accepted Answer

A) True 
 B)False

Question 11

Applications can be moved from one machine to another when each machine uses SQL.

Accepted Answer

A) True 
 B)False

Question 12

What will be returned when the following SQL statement is executed?
Select driver_no,count(*)as num_deliveries
From deliveries
Group by driver_no;

Accepted Answer

A)  A listing of all drivers, sorted by driver number 
B)  A listing of each driver as well as the number of deliveries that he or she has made 
C)  A count of all of the deliveries made by all drivers 
D)  None of the above 
A)  A listing of all drivers, sorted by driver number 
B)  A listing of each driver as well as the number of deliveries that he or she has made 
C)  A count of all of the deliveries made by all drivers 
D)  None of the above

Question 13

The benefits of a standardized relational language include:

Accepted Answer

A)  application longevity. 
B)  reduced training costs. 
C)  cross-system communication. 
D)  all of the above. 
A)  application longevity. 
B)  reduced training costs. 
C)  cross-system communication. 
D)  all of the above.

Question 14

The ALTER TABLE command is used to change a table definition.

Accepted Answer

A) True 
 B)False

Question 15

Explain the three classes of SQL commands and when they would be used.

Accepted Answer

There are three classes or types of SQL

Question 16

Which of the following finds all groups meeting stated conditions?

Accepted Answer

A)  Select 
B)  Where 
C)  Having 
D)  Find 
A)  Select 
B)  Where 
C)  Having 
D)  Find

Question 17

What three clauses are contained in most SQL retrieval statements?

Accepted Answer

The select clause,which lists the column

Question 18

The content of dynamic views is generated when they are referenced.

Accepted Answer

A) True 
 B)False

Question 19

What is a materialized view and when would it be used?

Accepted Answer

Materialized views are just like dynamic

Question 20

Which of the following is true of the order in which SQL statements are evaluated?

Accepted Answer

A)  The select clause is always processed first. 
B)  The select clause is always processed last. 
C)  The select clause is processed before the order by clause. 
D)  The group by clause is processed before the where clause. 
A)  The select clause is always processed first. 
B)  The select clause is always processed last. 
C)  The select clause is processed before the order by clause. 
D)  The group by clause is processed before the where clause.

The HAVING clause and the WHERE clause perform the same operation.

To eliminate duplicate rows in a query,the ________ qualifier is used in the SQL Select command.

A catalog is the structure that contains object descriptions created by a user.

A ________ view is materialized when referenced.

What steps should be followed when preparing to create a table?

What result set will the following query return? Select item_no From order_v Where quantity > 10;

Indexes are created in most RDBMSs to:

The DROP command deletes rows from a table individually or in groups.

Some DBMS can handle graphic data types,as well as text and numbers.

A database is maintained and queried using the data mapping language (DML).

Applications can be moved from one machine to another when each machine uses SQL.

What will be returned when the following SQL statement is executed? Select driver_no,count(*)as num_deliveries From deliveries Group by driver_no;

The benefits of a standardized relational language include:

The ALTER TABLE command is used to change a table definition.

Explain the three classes of SQL commands and when they would be used.

Which of the following finds all groups meeting stated conditions?

What three clauses are contained in most SQL retrieval statements?

The content of dynamic views is generated when they are referenced.

What is a materialized view and when would it be used?

Which of the following is true of the order in which SQL statements are evaluated?

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 HAVING clause and the WHERE clause perform the same operation.

To eliminate duplicate rows in a query,the ________ qualifier is used in the SQL Select command.

A catalog is the structure that contains object descriptions created by a user.

A ________ view is materialized when referenced.

What steps should be followed when preparing to create a table?

What result set will the following query return? Select item_no From order_v Where quantity > 10;

Indexes are created in most RDBMSs to:

The DROP command deletes rows from a table individually or in groups.

Some DBMS can handle graphic data types,as well as text and numbers.

A database is maintained and queried using the data mapping language (DML).

Applications can be moved from one machine to another when each machine uses SQL.

What will be returned when the following SQL statement is executed? Select driver_no,count(*)as num_deliveries From deliveries Group by driver_no;

The benefits of a standardized relational language include:

The ALTER TABLE command is used to change a table definition.

Explain the three classes of SQL commands and when they would be used.

Which of the following finds all groups meeting stated conditions?

What three clauses are contained in most SQL retrieval statements?

The content of dynamic views is generated when they are referenced.

What is a materialized view and when would it be used?

Which of the following is true of the order in which SQL statements are evaluated?

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