Question 1

In the SQL SELECT command, the search arguments that limit the rows involved in the query are specified in the ____ clause.

Accepted Answer

A)  SELECT 
B)  PROJECT 
C)  FROM 
D)  WHERE 
E)  RETRIEVE 
A)  SELECT 
B)  PROJECT 
C)  FROM 
D)  WHERE 
E)  RETRIEVE

Question 2

If several AND and OR operators appear in an SQL SELECT command WHERE clause and they are not separated by parentheses, all of the OR operations will be performed before any of the AND operations.

Accepted Answer

A) True 
 B)False

Question 3

When an SQL SELECT command has a subquery within it ____.

Accepted Answer

A)  the subquery is executed first 
B)  the subquery is executed last 
C)  there is just one SELECT clause in the entire command, including the subquery 
D)  all predicates in the subquery's WHERE clause are passed back to the main query 
E)  all predicates in the main query's WHERE clause are passed down to the subquery 
A)  the subquery is executed first 
B)  the subquery is executed last 
C)  there is just one SELECT clause in the entire command, including the subquery 
D)  all predicates in the subquery's WHERE clause are passed back to the main query 
E)  all predicates in the main query's WHERE clause are passed down to the subquery

Question 4

A basic SQL SELECT command is capable of retrieving a single column value from a single row of a table.

Accepted Answer

A) True 
 B)False

Question 5

The ORDER BY operator in the SQL SELECT command orders a query result's output rows by a set of attribute values.

Accepted Answer

A) True 
 B)False

Question 6

The DISTINCT operator in the SQL SELECT command removes duplicate rows from a query result.

Accepted Answer

A) True 
 B)False

Question 7

SQL incorporates features of both a data definition language and a data manipulation language.

Accepted Answer

A) True 
 B)False

Question 8

A subset of the columns and/or rows of a table is called a ____.

Accepted Answer

A)  logical view 
B)  virtual view 
C)  physical view 
D)  partial view 
E)  index view 
A)  logical view 
B)  virtual view 
C)  physical view 
D)  partial view 
E)  index view

Question 9

Only two tables can be joined in an SQL SELECT statement.

Accepted Answer

A) True 
 B)False

Question 10

Once a GROUP BY clause in an SQL SELECT command groups together rows based on common attribute values, a built-in function can produce a result for each group.

Accepted Answer

A) True 
 B)False

Question 11

SQL has commands that are capable of creating and dropping indexes on relational tables.

Accepted Answer

A) True 
 B)False

Question 12

The LIKE operator in the SQL SELECT command WHERE clause allows the use of wildcards to substitute for character strings.

Accepted Answer

A) True 
 B)False

Question 13

Typing SQL SELECT commands in at a keyboard and sending them directly to the relational DBMS for processing is referred to as ____.

Accepted Answer

A)  online mode 
B)  query mode 
C)  programming 
D)  embedded 
E)  retrieval mode 
A)  online mode 
B)  query mode 
C)  programming 
D)  embedded 
E)  retrieval mode

Question 14

All of the following are true about the use of AND and OR operators in an SQL SELECT command, except ____.

Accepted Answer

A)  AND has higher precedence than OR 
B)  AND and OR can be used together with any of the comparison operators 
C)  OR means one condition or the other or both 
D)  enclosing an AND or an OR operation in parentheses ensures that it will be performed before those outside of parentheses 
E)  either the AND or the OR operator may be used in a given SQL SELECT command, but not both 
A)  AND has higher precedence than OR 
B)  AND and OR can be used together with any of the comparison operators 
C)  OR means one condition or the other or both 
D)  enclosing an AND or an OR operation in parentheses ensures that it will be performed before those outside of parentheses 
E)  either the AND or the OR operator may be used in a given SQL SELECT command, but not both

Question 15

A relational query optimizer optimizes ____.

Accepted Answer

A)  the performance of a relational query 
B)  the performance of a relational catalog 
C)  a higher-level language program that has embedded SQL SELECT commands 
D)  the data normalization process 
E)  None of the above. 
A)  the performance of a relational query 
B)  the performance of a relational catalog 
C)  a higher-level language program that has embedded SQL SELECT commands 
D)  the data normalization process 
E)  None of the above.

Question 16

The SQL SELECT command is capable of executing ____.

Accepted Answer

A)  only relational Select operations 
B)  only relational Select and Project operations but not relational Join operations 
C)  relational Select, Project, and Join operations individually but not in combination 
D)  relational Select, Project, and Join operations individually or in combination 
E)  None of the above. 
A)  only relational Select operations 
B)  only relational Select and Project operations but not relational Join operations 
C)  relational Select, Project, and Join operations individually but not in combination 
D)  relational Select, Project, and Join operations individually or in combination 
E)  None of the above.

Question 17

In the SQL SELECT command embedded mode, the user types the command at a workstation and presses the Enter key. The command goes directly to the relational DBMS, which evaluates the query and processes it against the database.

Accepted Answer

A) True 
 B)False

Question 18

A data definition language (DDL) ____.

Accepted Answer

A)  is the same as a data manipulation language 
B)  is limited to defining the size and type of attributes 
C)  specifies what tables will be in the database, what attributes will be in the tables, and which attributes will be indexed 
D)  specifies the programming language statements that will be used to access the data in a relational database 
E)  specifies the operating system parameters that will permit the relational DBMS to function within its environment 
A)  is the same as a data manipulation language 
B)  is limited to defining the size and type of attributes 
C)  specifies what tables will be in the database, what attributes will be in the tables, and which attributes will be indexed 
D)  specifies the programming language statements that will be used to access the data in a relational database 
E)  specifies the operating system parameters that will permit the relational DBMS to function within its environment

Question 19

In a relational database, a logical view ____.

Accepted Answer

A)  is a physical duplicate of part of a table 
B)  is a physical duplicate of all of a table 
C)  is created with the SQL CREATE TABLE command 
D)  must be built over a single table, i.e. it cannot involve joined tables 
E)  None of the above. 
A)  is a physical duplicate of part of a table 
B)  is a physical duplicate of all of a table 
C)  is created with the SQL CREATE TABLE command 
D)  must be built over a single table, i.e. it cannot involve joined tables 
E)  None of the above.

Question 20

In the SQL SELECT command, the attributes to be retrieved are specified in the ____ clause.

Accepted Answer

A)  SELECT 
B)  PROJECT 
C)  FROM 
D)  WHERE 
E)  RETRIEVE 
A)  SELECT 
B)  PROJECT 
C)  FROM 
D)  WHERE 
E)  RETRIEVE

In the SQL SELECT command, the search arguments that limit the rows involved in the query are specified in the ____ clause.

If several AND and OR operators appear in an SQL SELECT command WHERE clause and they are not separated by parentheses, all of the OR operations will be performed before any of the AND operations.

When an SQL SELECT command has a subquery within it ____.

A basic SQL SELECT command is capable of retrieving a single column value from a single row of a table.

The ORDER BY operator in the SQL SELECT command orders a query result's output rows by a set of attribute values.

The DISTINCT operator in the SQL SELECT command removes duplicate rows from a query result.

SQL incorporates features of both a data definition language and a data manipulation language.

A subset of the columns and/or rows of a table is called a ____.

Only two tables can be joined in an SQL SELECT statement.

Once a GROUP BY clause in an SQL SELECT command groups together rows based on common attribute values, a built-in function can produce a result for each group.

SQL has commands that are capable of creating and dropping indexes on relational tables.

The LIKE operator in the SQL SELECT command WHERE clause allows the use of wildcards to substitute for character strings.

Typing SQL SELECT commands in at a keyboard and sending them directly to the relational DBMS for processing is referred to as ____.

All of the following are true about the use of AND and OR operators in an SQL SELECT command, except ____.

A relational query optimizer optimizes ____.

The SQL SELECT command is capable of executing ____.

In the SQL SELECT command embedded mode, the user types the command at a workstation and presses the Enter key. The command goes directly to the relational DBMS, which evaluates the query and processes it against the database.

A data definition language (DDL) ____.

In a relational database, a logical view ____.

In the SQL SELECT command, the attributes to be retrieved are specified in the ____ 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

In the SQL SELECT command, the search arguments that limit the rows involved in the query are specified in the ____ clause.

If several AND and OR operators appear in an SQL SELECT command WHERE clause and they are not separated by parentheses, all of the OR operations will be performed before any of the AND operations.

When an SQL SELECT command has a subquery within it ____.

A basic SQL SELECT command is capable of retrieving a single column value from a single row of a table.

The ORDER BY operator in the SQL SELECT command orders a query result's output rows by a set of attribute values.

The DISTINCT operator in the SQL SELECT command removes duplicate rows from a query result.

SQL incorporates features of both a data definition language and a data manipulation language.

A subset of the columns and/or rows of a table is called a ____.

Only two tables can be joined in an SQL SELECT statement.

Once a GROUP BY clause in an SQL SELECT command groups together rows based on common attribute values, a built-in function can produce a result for each group.

SQL has commands that are capable of creating and dropping indexes on relational tables.

The LIKE operator in the SQL SELECT command WHERE clause allows the use of wildcards to substitute for character strings.

Typing SQL SELECT commands in at a keyboard and sending them directly to the relational DBMS for processing is referred to as ____.

All of the following are true about the use of AND and OR operators in an SQL SELECT command, except ____.

A relational query optimizer optimizes ____.

The SQL SELECT command is capable of executing ____.

In the SQL SELECT command embedded mode, the user types the command at a workstation and presses the Enter key. The command goes directly to the relational DBMS, which evaluates the query and processes it against the database.

A data definition language (DDL) ____.

In a relational database, a logical view ____.

In the SQL SELECT command, the attributes to be retrieved are specified in the ____ 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