Question 1

A major benefit of SQL as a standard is reduced training costs.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)  A listing of all drivers who made deliveries to state = 'MA', sorted by driver number 
B)  A listing of each driver who made deliveries to state = 'MA' as well as the number of deliveries that each driver has made to that state 
C)  A count of all of the deliveries made to state = 'MA' by all drivers 
D)  An error message will be generated 
A)  A listing of all drivers who made deliveries to state = 'MA', sorted by driver number 
B)  A listing of each driver who made deliveries to state = 'MA' as well as the number of deliveries that each driver has made to that state 
C)  A count of all of the deliveries made to state = 'MA' by all drivers 
D)  An error message will be generated

Question 3

What three clauses are contained in most SQL retrieval statements?

Accepted Answer

The SELECT clause, which lists the colum

Question 4

Which of the following is a technique for optimizing the internal performance of the relational data model?

Accepted Answer

A)  Avoiding indexes on secondary keys 
B)  Clustering data 
C)  Not reporting statistics to save machine resources 
D)  Using random index organizations 
A)  Avoiding indexes on secondary keys 
B)  Clustering data 
C)  Not reporting statistics to save machine resources 
D)  Using random index organizations

Question 5

The asterisk (*) wildcard designator can be used to select all fields from a table as well as in WHERE clauses when an exact match is not possible.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Any create command may be reversed by using a(n) ________ command.

Accepted Answer

A)  undo 
B)  drop 
C)  delete 
D)  unpack 
A)  undo 
B)  drop 
C)  delete 
D)  unpack

Question 8

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 9

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

Accepted Answer

Materialized views are just like dynamic

Question 10

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 11

Which of the following can produce scalar and vector aggregates?

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

The following two SQL statements will produce different results.
Select last_name, first_name
from customer
where state = 'MA' or state = 'NY' or state = 'NJ' or state = 'NH' or state = 'CT';
Select last_name, first_name
from customer
where state in ('MA','NY','NJ','NH','CT');

Accepted Answer

A) True 
 B)False

Question 16

Discuss when to use the GROUP BY clause.

Accepted Answer

The GROUP BY clause is useful when you h

Question 17

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

Accepted Answer

When preparing to create a table, one sh

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Given a table named store with 5 fields: store_id, address, city, state, zipcode, why would the following insert command not work? insert into store values ('234 Park Street')

Accepted Answer

A)  It would work just fine. 
B)  You must specify the fields to insert if you are only inserting some of the fields. 
C)  There is no table keyword. 
D)  Insert into should be INSERT to. 
A)  It would work just fine. 
B)  You must specify the fields to insert if you are only inserting some of the fields. 
C)  There is no table keyword. 
D)  Insert into should be INSERT to.

Question 20

Count(*) tallies only those rows that contain a value, while Count counts all rows.

Accepted Answer

A) True 
 B)False

A major benefit of SQL as a standard is reduced training costs.

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

What three clauses are contained in most SQL retrieval statements?

Which of the following is a technique for optimizing the internal performance of the relational data model?

The asterisk (*) wildcard designator can be used to select all fields from a table as well as in WHERE clauses when an exact match is not possible.

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;

Any create command may be reversed by using a(n) ________ command.

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

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

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

Which of the following can produce scalar and vector aggregates?

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

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

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

The following two SQL statements will produce different results. Select last_name, first_name from customer where state = 'MA' or state = 'NY' or state = 'NJ' or state = 'NH' or state = 'CT'; Select last_name, first_name from customer where state in ('MA','NY','NJ','NH','CT');

Discuss when to use the GROUP BY clause.

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

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

Given a table named store with 5 fields: store_id, address, city, state, zipcode, why would the following insert command not work? insert into store values ('234 Park Street')

Count(*) tallies only those rows that contain a value, while Count counts all rows.

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

A major benefit of SQL as a standard is reduced training costs.

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

What three clauses are contained in most SQL retrieval statements?

Which of the following is a technique for optimizing the internal performance of the relational data model?

The asterisk (*) wildcard designator can be used to select all fields from a table as well as in WHERE clauses when an exact match is not possible.

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;

Any create command may be reversed by using a(n) ________ command.

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

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

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

Which of the following can produce scalar and vector aggregates?

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

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

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

The following two SQL statements will produce different results. Select last_name, first_name from customer where state = 'MA' or state = 'NY' or state = 'NJ' or state = 'NH' or state = 'CT'; Select last_name, first_name from customer where state in ('MA','NY','NJ','NH','CT');

Discuss when to use the GROUP BY clause.

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

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

Given a table named store with 5 fields: store_id, address, city, state, zipcode, why would the following insert command not work? insert into store values ('234 Park Street')

Count(*) tallies only those rows that contain a value, while Count counts all rows.

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