Question 1

The tables used in a SELECT command are listed in the FROM clause.

Accepted Answer

A) True 
 B)False

Question 2

When tables are to be joined in an SQL SELECT statement, the join attributes from each table are set equal to each other in the FROM clause.

Accepted Answer

A) True 
 B)False

Question 3

In an SQL SELECT command, a SELECT clause with several attributes and the absence of a WHERE clause indicates a(n) ____.

Accepted Answer

A)  relational Select operation 
B)  relational Project operation 
C)  combination of relational Select and Project operations 
D)  combination of relational Select, Project, and Join operations 
E)  None of the above. 
A)  relational Select operation 
B)  relational Project operation 
C)  combination of relational Select and Project operations 
D)  combination of relational Select, Project, and Join operations 
E)  None of the above.

Question 4

All of the standard comparison operators can be use in the SQL SELECT command WHERE clause.

Accepted Answer

A) True 
 B)False

Question 5

The SQL command to delete a table is DELETE TABLE.

Accepted Answer

A) True 
 B)False

Question 6

A subquery can be used in place of a(n) ____.

Accepted Answer

A)  GROUP BY 
B)  ORDER BY 
C)  Count 
D)  join 
E)  HAVING 
A)  GROUP BY 
B)  ORDER BY 
C)  Count 
D)  join 
E)  HAVING

Question 7

The SQL SELECT GROUP BY clause is designed to ____.

Accepted Answer

A)  group together the rows of a table that have a common attribute value 
B)  group together the columns of a table that have a common attribute value 
C)  group together the attributes of a table that have a common domain of values 
D)  group together the attributes of a group of tables that have a common domain of values 
E)  None of the above. 
A)  group together the rows of a table that have a common attribute value 
B)  group together the columns of a table that have a common attribute value 
C)  group together the attributes of a table that have a common domain of values 
D)  group together the attributes of a group of tables that have a common domain of values 
E)  None of the above.

Question 8

All of the following are true regarding a join operation in an SQL SELECT command, except ____.

Accepted Answer

A)  it requires at least two tables to be specified in the FROM clause 
B)  it can involve the specification of more than two tables in the FROM clause 
C)  it requires corresponding join attributes to be set equal to each other in the WHERE clause 
D)  it can also involve relational Select and Project operations in the same SQL SELECT command 
E)  there will be at least two tables in the query output because at least two tables were involved in the join 
A)  it requires at least two tables to be specified in the FROM clause 
B)  it can involve the specification of more than two tables in the FROM clause 
C)  it requires corresponding join attributes to be set equal to each other in the WHERE clause 
D)  it can also involve relational Select and Project operations in the same SQL SELECT command 
E)  there will be at least two tables in the query output because at least two tables were involved in the join

Question 9

The OR operator in the SQL SELECT command WHERE clause means one or the other, but not both.

Accepted Answer

A) True 
 B)False

Question 10

A plan for the steps to take to respond to a relational query is called a(n) ____.

Accepted Answer

A)  retrieval path 
B)  access path 
C)  acquisition path 
D)  data path 
E)  indexed path 
A)  retrieval path 
B)  access path 
C)  acquisition path 
D)  data path 
E)  indexed path

Question 11

The only way to retrieve all of the fields of a table with an SQL SELECT command is to list them all in the SELECT clause.

Accepted Answer

A) True 
 B)False

The tables used in a SELECT command are listed in the FROM clause.

When tables are to be joined in an SQL SELECT statement, the join attributes from each table are set equal to each other in the FROM clause.

In an SQL SELECT command, a SELECT clause with several attributes and the absence of a WHERE clause indicates a(n) ____.

All of the standard comparison operators can be use in the SQL SELECT command WHERE clause.

The SQL command to delete a table is DELETE TABLE.

A subquery can be used in place of a(n) ____.

The SQL SELECT GROUP BY clause is designed to ____.

All of the following are true regarding a join operation in an SQL SELECT command, except ____.

The OR operator in the SQL SELECT command WHERE clause means one or the other, but not both.

A plan for the steps to take to respond to a relational query is called a(n) ____.

The only way to retrieve all of the fields of a table with an SQL SELECT command is to list them all in the SELECT clause.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters

Exam 4: Relational Data Retrieval: SQL

The tables used in a SELECT command are listed in the FROM clause.

When tables are to be joined in an SQL SELECT statement, the join attributes from each table are set equal to each other in the FROM clause.

In an SQL SELECT command, a SELECT clause with several attributes and the absence of a WHERE clause indicates a(n) ____.

All of the standard comparison operators can be use in the SQL SELECT command WHERE clause.

The SQL command to delete a table is DELETE TABLE.

A subquery can be used in place of a(n) ____.

The SQL SELECT GROUP BY clause is designed to ____.

All of the following are true regarding a join operation in an SQL SELECT command, except ____.

The OR operator in the SQL SELECT command WHERE clause means one or the other, but not both.

A plan for the steps to take to respond to a relational query is called a(n) ____.

The only way to retrieve all of the fields of a table with an SQL SELECT command is to list them all in the SELECT clause.

Data: the New Corporate Resource

Data Modeling

The Database Management System Concept

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters