Question 1

When the select clause in the create view statement contains the keyword DISTINCT,the view can be used to update data.

Accepted Answer

A) True 
 B)False

Question 2

What does the following SQL statement do?
Delete from Customer_T
Where state = 'HI';

Accepted Answer

A)  Deletes all records from customer_t where the state is equal to HI 
B)  Removes the customer_t table from the database 
C)  Deletes all records from the customer_t table 
D)  None of the above 
A)  Deletes all records from customer_t where the state is equal to HI 
B)  Removes the customer_t table from the database 
C)  Deletes all records from the customer_t table 
D)  None of the above

Question 3

DDL is typically used during which phases of the development process?

Accepted Answer

A)  Implementation 
B)  Physical design 
C)  Analysis 
D)  All of the above 
A)  Implementation 
B)  Physical design 
C)  Analysis 
D)  All of the above

Question 4

In order to update data in SQL,one must inform the DBMS which relation,columns,and rows are involved.

Accepted Answer

A) True 
 B)False

Question 5

Multiple values returned from an SQL query that includes an aggregate function are called:

Accepted Answer

A)  vector aggregates. 
B)  scalar aggregates. 
C)  agates. 
D)  summations. 
A)  vector aggregates. 
B)  scalar aggregates. 
C)  agates. 
D)  summations.

Question 6

Indexes are created in most RDBMS to provide rapid ________ and ________ access to base-table data.

Accepted Answer

The answer of Indexes are created in most RDBMS to...

Question 7

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

Accepted Answer

Some of the advantages are: reduced trai

Question 8

The DELETE TABLE DDL command is used to remove a table from the database.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following counts ONLY rows that contain a value?

Accepted Answer

A)  Count 
B)  Count(*) 
C)  Tally(*) 
D)  Checknum 
A)  Count 
B)  Count(*) 
C)  Tally(*) 
D)  Checknum

Question 10

What does the following SQL statement do?
Alter Table Customer_T
Add (Type Varchar (2));

Accepted Answer

A)  Alters the Customer_T table to accept Type 2 Varchars 
B)  Alters the Customer_T table to be a Type 2 Varchar 
C)  Alters the Customer_T table, and adds a field called "Type" 
D)  Alters the Customer_T table by adding a 2-byte field called "Varchar" 
A)  Alters the Customer_T table to accept Type 2 Varchars 
B)  Alters the Customer_T table to be a Type 2 Varchar 
C)  Alters the Customer_T table, and adds a field called "Type" 
D)  Alters the Customer_T table by adding a 2-byte field called "Varchar"

Question 11

What results will be produced by the following SQL query?
Select sum(standard_price)as total_price
From product_v
Where product_type = 'WOOD';

Accepted Answer

A)  The total price of all products that are of type wood 
B)  The total price of all products 
C)  The standard_price of the first wood product in the table 
D)  The standard_price of any wood product in the table 
A)  The total price of all products that are of type wood 
B)  The total price of all products 
C)  The standard_price of the first wood product in the table 
D)  The standard_price of any wood product in the table

Question 12

The ________ SQL command lists the columns from base tables or views to be projected into the command result table.

Accepted Answer

The answer of The ________ SQL command lists the columns...

Question 13

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

Accepted Answer

A)  A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries 
B)  A listing of all drivers 
C)  A listing of the number of deliveries greater than 2 
D)  A listing of all drivers who made more than 2 deliveries 
A)  A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries 
B)  A listing of all drivers 
C)  A listing of the number of deliveries greater than 2 
D)  A listing of all drivers who made more than 2 deliveries

Question 14

Implementation of a standard can never stifle creativity and innovation.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

One of the original purposes of the SQL standard was to provide a vehicle for portability of database definition and application modules between conforming DBMSs.

Accepted Answer

A) True 
 B)False

Question 17

If multiple Boolean operators are used in an SQL statement,NOT is evaluated first,then AND,then OR.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Discuss the pros and cons of using dynamic views

Accepted Answer

A dynamic view is useful,since it provid

Question 20

SQL originated from a project called System-S.

Accepted Answer

A) True 
 B)False

When the select clause in the create view statement contains the keyword DISTINCT,the view can be used to update data.

What does the following SQL statement do? Delete from Customer_T Where state = 'HI';

DDL is typically used during which phases of the development process?

In order to update data in SQL,one must inform the DBMS which relation,columns,and rows are involved.

Multiple values returned from an SQL query that includes an aggregate function are called:

Indexes are created in most RDBMS to provide rapid and access to base-table data.

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

The DELETE TABLE DDL command is used to remove a table from the database.

Which of the following counts ONLY rows that contain a value?

What does the following SQL statement do? Alter Table Customer_T Add (Type Varchar (2));

What results will be produced by the following SQL query? Select sum(standard_price)as total_price From product_v Where product_type = 'WOOD';

The ________ SQL command lists the columns from base tables or views to be projected into the command result table.

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

Implementation of a standard can never stifle creativity and innovation.

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

One of the original purposes of the SQL standard was to provide a vehicle for portability of database definition and application modules between conforming DBMSs.

If multiple Boolean operators are used in an SQL statement,NOT is evaluated first,then AND,then OR.

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

Discuss the pros and cons of using dynamic views

SQL originated from a project called System-S.

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

When the select clause in the create view statement contains the keyword DISTINCT,the view can be used to update data.

What does the following SQL statement do? Delete from Customer_T Where state = 'HI';

DDL is typically used during which phases of the development process?

In order to update data in SQL,one must inform the DBMS which relation,columns,and rows are involved.

Multiple values returned from an SQL query that includes an aggregate function are called:

Indexes are created in most RDBMS to provide rapid ________ and ________ access to base-table data.

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

The DELETE TABLE DDL command is used to remove a table from the database.

Which of the following counts ONLY rows that contain a value?

What does the following SQL statement do? Alter Table Customer_T Add (Type Varchar (2));

What results will be produced by the following SQL query? Select sum(standard_price)as total_price From product_v Where product_type = 'WOOD';

The ________ SQL command lists the columns from base tables or views to be projected into the command result table.

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

Implementation of a standard can never stifle creativity and innovation.

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

One of the original purposes of the SQL standard was to provide a vehicle for portability of database definition and application modules between conforming DBMSs.

If multiple Boolean operators are used in an SQL statement,NOT is evaluated first,then AND,then OR.

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

Discuss the pros and cons of using dynamic views

SQL originated from a project called System-S.

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

Indexes are created in most RDBMS to provide rapid and access to base-table data.

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