Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

The first part of an SQL query to be read is the ________ statement.

Accepted Answer

A)  SELECT 
B)  FROM 
C)  WHERE 
D)  ORDER BY 
A)  SELECT 
B)  FROM 
C)  WHERE 
D)  ORDER BY

Question 3

What are some of the advantages and disadvantages to an SQL standard?

Accepted Answer

Some of the advantages are:reduced train

Question 4

In an SQL statement, which of the following parts states the conditions for row selection?

Accepted Answer

A)  Select 
B)  From 
C)  Where 
D)  Group By 
A)  Select 
B)  From 
C)  Where 
D)  Group By

Question 5

Referential Integrity Constraints are generally established between:

Accepted Answer

A)  Referential and Integrity keys. 
B)  Primary and Secondary keys. 
C)  Primary and Foreign keys. 
D)  Foreign and Domestic keys. 
A)  Referential and Integrity keys. 
B)  Primary and Secondary keys. 
C)  Primary and Foreign keys. 
D)  Foreign and Domestic keys.

Question 6

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 7

Adding the DISTINCT keyword to a query eliminates duplicates.

Accepted Answer

A) True 
 B)False

Question 8

A view may not be updated directly if it contains:

Accepted Answer

A)  the SELECT clause. 
B)  the HAVING clause. 
C)  the FROM clause. 
D)  the WHERE clause. 
A)  the SELECT clause. 
B)  the HAVING clause. 
C)  the FROM clause. 
D)  the WHERE clause.

Question 9

The views are created by executing a CREATE VIEW SQL command.

Accepted Answer

A) True 
 B)False

Question 10

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 11

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)  An error message 
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)  An error message

Question 12

SQL originated from a project called System-S.

Accepted Answer

A) True 
 B)False

Question 13

The FROM clause is the first statement processed in an SQL command.

Accepted Answer

A) True 
 B)False

Question 14

An insert command does not need to have the fields listed.

Accepted Answer

A) True 
 B)False

Question 15

Discuss the pros and cons of using dynamic views.

Accepted Answer

A dynamic view is useful, since it provi

Question 16

The first in a series of steps to follow when creating a table is to:

Accepted Answer

A)  identify columns that must be unique. 
B)  identify each attribute and its characteristics. 
C)  create an index. 
D)  identify columns that must be null. 
A)  identify columns that must be unique. 
B)  identify each attribute and its characteristics. 
C)  create an index. 
D)  identify columns that must be null.

Question 17

When a GROUP BY clause is included in an SQL statement, only those columns with a single value for each group can be included.

Accepted Answer

A) True 
 B)False

Question 18

When creating a table, it is not important to consider foreign key-primary key mates.

Accepted Answer

A) True 
 B)False

Question 19

Materialized views are stored on disk and are never refreshed.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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

The first part of an SQL query to be read is the ________ statement.

What are some of the advantages and disadvantages to an SQL standard?

In an SQL statement, which of the following parts states the conditions for row selection?

Referential Integrity Constraints are generally established between:

A ________ view is materialized when referenced.

Adding the DISTINCT keyword to a query eliminates duplicates.

A view may not be updated directly if it contains:

The views are created by executing a CREATE VIEW SQL command.

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

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

SQL originated from a project called System-S.

The FROM clause is the first statement processed in an SQL command.

An insert command does not need to have the fields listed.

Discuss the pros and cons of using dynamic views.

The first in a series of steps to follow when creating a table is to:

When a GROUP BY clause is included in an SQL statement, only those columns with a single value for each group can be included.

When creating a table, it is not important to consider foreign key-primary key mates.

Materialized views are stored on disk and are never refreshed.

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 6: Introduction to SQL

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

The first part of an SQL query to be read is the ________ statement.

What are some of the advantages and disadvantages to an SQL standard?

In an SQL statement, which of the following parts states the conditions for row selection?

Referential Integrity Constraints are generally established between:

A ________ view is materialized when referenced.

Adding the DISTINCT keyword to a query eliminates duplicates.

A view may not be updated directly if it contains:

The views are created by executing a CREATE VIEW SQL command.

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

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

SQL originated from a project called System-S.

The FROM clause is the first statement processed in an SQL command.

An insert command does not need to have the fields listed.

Discuss the pros and cons of using dynamic views.

The first in a series of steps to follow when creating a table is to:

When a GROUP BY clause is included in an SQL statement, only those columns with a single value for each group can be included.

When creating a table, it is not important to consider foreign key-primary key mates.

Materialized views are stored on disk and are never refreshed.

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters