Question 1

Every SELECT statement returns a ________ when it executes.

Accepted Answer

The answer of Every SELECT statement returns a ________ when...

Question 2

Which of the following is a purpose of the SQL standard?

Accepted Answer

A)  To specify syntax and semantics of SQL data definition and manipulation 
B)  To specify minimal and complete standards, which permit different degrees of adoption in products 
C)  To define the data structures and basic operations for SQL databases 
D)  All of the above 
A)  To specify syntax and semantics of SQL data definition and manipulation 
B)  To specify minimal and complete standards, which permit different degrees of adoption in products 
C)  To define the data structures and basic operations for SQL databases 
D)  All of the above

Question 3

What were the original purposes of SQL and does SQL as we know it today live up to those standards?

Accepted Answer

The following were the original purposes

Question 4

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

Accepted Answer

A)  create table 
B)  alter table 
C)  create view 
D)  create relationship 
A)  create table 
B)  alter table 
C)  create view 
D)  create relationship

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

What are some of the standard SQL functions that can be used in the select clause?

Accepted Answer

The standard functions can be broken dow

Question 7

What result set is returned from the following query?
Select customer_name,telephone
From customers
Where city in ('Boston','New York','Denver');

Accepted Answer

A)  The customer_name and telephone of all customers 
B)  The customer_name and telephone of all customers living in either Boston, New York or Denver 
C)  The customer_name and telephone of all customers living in Boston and New York and Denver 
D)  The customer_name of all customers living in Boston, New York or Denver 
A)  The customer_name and telephone of all customers 
B)  The customer_name and telephone of all customers living in either Boston, New York or Denver 
C)  The customer_name and telephone of all customers living in Boston and New York and Denver 
D)  The customer_name of all customers living in Boston, New York or Denver

Question 8

The ORDER BY clause sorts the final results rows in ascending or descending order.

Accepted Answer

A) True 
 B)False

Question 9

The WHERE clause includes the conditions for row selection within a single table or view,and the conditions between tables or views for joining.

Accepted Answer

A) True 
 B)False

Question 10

What result will the following SQL statement produce?
Select Avg(standard_price)as average from product_v;

Accepted Answer

A)  The average of all products in product_v 
B)  The average standard_price of all products in product_v 
C)  The average price of all products 
D)  None of the above 
A)  The average of all products in product_v 
B)  The average standard_price of all products in product_v 
C)  The average price of all products 
D)  None of the above

Question 11

The comparison operators ________ and ________ are used to establish a range of values in SQL.

Accepted Answer

The answer of The comparison operators ________ and ________ are...

Question 12

SQL has been implemented only in the mainframe and midrange environments.

Accepted Answer

A) True 
 B)False

Question 13

Adding the DISTINCT keyword to a query eliminates duplicates.

Accepted Answer

A) True 
 B)False

Question 14

The structure that contains descriptions of objects created by a user,such as base tables and views is called a(n)________.

Accepted Answer

The answer of The structure that contains descriptions of objects...

Question 15

________ is a set of commands used to control a database,which includes security.

Accepted Answer

A)  DML 
B)  DDL 
C)  DCL 
D)  DPL 
A)  DML 
B)  DDL 
C)  DCL 
D)  DPL

Question 16

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 17

The SQL command used to populate tables is the INSERT command.

Accepted Answer

A) True 
 B)False

Question 18

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)  None of the above. 
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)  None of the above.

Question 19

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 20

When using an expression in SQL,expressions inside the ________ will be calculated first.

Accepted Answer

The answer of When using an expression in SQL,expressions inside...

Every SELECT statement returns a ________ when it executes.

Which of the following is a purpose of the SQL standard?

What were the original purposes of SQL and does SQL as we know it today live up to those standards?

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

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

What are some of the standard SQL functions that can be used in the select clause?

What result set is returned from the following query? Select customer_name,telephone From customers Where city in ('Boston','New York','Denver');

The ORDER BY clause sorts the final results rows in ascending or descending order.

The WHERE clause includes the conditions for row selection within a single table or view,and the conditions between tables or views for joining.

What result will the following SQL statement produce? Select Avg(standard_price)as average from product_v;

The comparison operators and are used to establish a range of values in SQL.

SQL has been implemented only in the mainframe and midrange environments.

Adding the DISTINCT keyword to a query eliminates duplicates.

The structure that contains descriptions of objects created by a user,such as base tables and views is called a(n)________.

________ is a set of commands used to control a database,which includes security.

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

The SQL command used to populate tables is the INSERT command.

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;

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');

When using an expression in SQL,expressions inside the ________ will be calculated first.

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

Every SELECT statement returns a ________ when it executes.

Which of the following is a purpose of the SQL standard?

What were the original purposes of SQL and does SQL as we know it today live up to those standards?

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

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

What are some of the standard SQL functions that can be used in the select clause?

What result set is returned from the following query? Select customer_name,telephone From customers Where city in ('Boston','New York','Denver');

The ORDER BY clause sorts the final results rows in ascending or descending order.

The WHERE clause includes the conditions for row selection within a single table or view,and the conditions between tables or views for joining.

What result will the following SQL statement produce? Select Avg(standard_price)as average from product_v;

The comparison operators ________ and ________ are used to establish a range of values in SQL.

SQL has been implemented only in the mainframe and midrange environments.

Adding the DISTINCT keyword to a query eliminates duplicates.

The structure that contains descriptions of objects created by a user,such as base tables and views is called a(n)________.

________ is a set of commands used to control a database,which includes security.

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

The SQL command used to populate tables is the INSERT command.

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;

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');

When using an expression in SQL,expressions inside the ________ will be calculated first.

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 comparison operators and are used to establish a range of values in SQL.