Question 1

In an SQL query,which SQL keyword must be used to remove duplicate rows from the result table?

Accepted Answer

A) DELETE 
B) DISTINCT 
C) NOT EXISTS 
D) UNIQUE 
E) KEY 
A) DELETE 
B) DISTINCT 
C) NOT EXISTS 
D) UNIQUE 
E) KEY B

Question 2

In an SQL query,which SQL keyword is used to specify the column names to be used in a join?

Accepted Answer

A) FROM 
B) HAVING 
C) JOIN 
D) SELECT 
E) WHERE 
A) FROM 
B) HAVING 
C) JOIN 
D) SELECT 
E) WHERE E

Question 3

The SQL keyword FROM is used to specify the table to be used.

Accepted Answer

A) True 
 B)False  True

Question 4

SQL commands can be embedded in application programs.

Accepted Answer

A) True 
 B)False

Question 5

An asterisk (*)following the SELECT verb means that all columns are to be displayed.

Accepted Answer

A) True 
 B)False

Question 6

Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the following would find all employees whose name begins with the letter "S" using standard SQL?

Accepted Answer

A) SELECT *
FROM EMPLOYEE
WHERE Name IN ['S']; 
B) SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S'; 
C) SELECT *
FROM Name
WHERE EMPLOYEE LIKE 'S*'; 
D) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%'; 
E) None of the above. 
A) SELECT *
FROM EMPLOYEE
WHERE Name IN ['S']; 
B) SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S'; 
C) SELECT *
FROM Name
WHERE EMPLOYEE LIKE 'S*'; 
D) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%'; 
E) None of the above.

Question 7

In an SQL query,which SQL keyword is used to implement a subquery?

Accepted Answer

A) GROUP BY 
B) HAVING 
C) ORDER BY 
D) SELECT 
E) SORT BY 
A) GROUP BY 
B) HAVING 
C) ORDER BY 
D) SELECT 
E) SORT BY

Question 8

SQL stands for Standard Query Language.

Accepted Answer

A) True 
 B)False

Question 9

Based on the tables below,which of the following ANSI SQL commands would return the average customer balance grouped by SalesRepNo? GENERAL SALES DATABASE:
SALESREP
 
CUSTOMER

Accepted Answer

A) SELECT AVG (Balance)
FROM CUSTOMER
WHERE SalesRepNo; 
B) SELECT AVG (Balance)
FROM CUSTOMER
GROUP BY SalesRepNo; 
C) SELECT AVG (Balance)
FROM CUSTOMER,SALESREP
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo; 
D) SELECT AVG (Balance)
FROM CUSTOMER
ORDER BY SalesRepNo; 
E) SELECT AVG (Balanc
E) 
FROM CUSTOMER,SALESREP
WHERE CUSTOMER.SalesRepNo = CUSTOMER.SalesRepNo
HAVING SalesRepNo; 
A) SELECT AVG (Balance)
FROM CUSTOMER
WHERE SalesRepNo; 
B) SELECT AVG (Balance)
FROM CUSTOMER
GROUP BY SalesRepNo; 
C) SELECT AVG (Balance)
FROM CUSTOMER,SALESREP
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo; 
D) SELECT AVG (Balance)
FROM CUSTOMER
ORDER BY SalesRepNo; 
E) SELECT AVG (Balanc
E) 
FROM CUSTOMER,SALESREP
WHERE CUSTOMER.SalesRepNo = CUSTOMER.SalesRepNo
HAVING SalesRepNo;

Question 10

The Microsoft Access wildcard character "*" (asterisk)indicates a sequence of one or more unspecified characters in a Microsoft Access SQL query.

Accepted Answer

A) True 
 B)False

Question 11

In an SQL query,which of the following symbols is used by ANSI SQL to represent a single unspecified character?

Accepted Answer

A) _ (underscore) 
B) (?) (question mark) 
C) * (asterisk) 
D) % (percent) 
E) # (pound) 
A) _ (underscore) 
B) (?) (question mark) 
C) * (asterisk) 
D) % (percent) 
E) # (pound)

Question 12

SQL,although very popular,has never become a national standard.

Accepted Answer

A) True 
 B)False

Question 13

The clause SELECT COUNT (*)results in a table with a single row and a single column.

Accepted Answer

A) True 
 B)False

Question 14

To have SQL automatically eliminate duplicate rows from a result,use the keyword DISTINCT with the FROM keyword.

Accepted Answer

A) True 
 B)False

Question 15

Based on the tables below,which of the following commands in ANSI SQL would return only the name of the sales representative and the name of the customer for each customer that has a balance greater than 400? GENERAL SALES DATABASE:
SALESREP
 
CUSTOMER

Accepted Answer

A) SELECT *
FROM SALESREP,CUSTOMER
WHERE Balance > 400; 
B) SELECT DISTINCT RepName,CustName
FROM SALESREP,CUSTOMER
WHERE Balance > 400; 
C) SELECT *
FROM SALESREP,CUSTOMER
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo
AND Balance > 400; 
D) SELECT RepName,CustName
FROM SALESREP,CUSTOMER
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo
AND Balance > 400; 
E) SELECT RepName,CustName
FROM SALESREP,CUSTOMER
WHERE Balance > 400
GROUP BY SalesRepNo; 
A) SELECT *
FROM SALESREP,CUSTOMER
WHERE Balance > 400; 
B) SELECT DISTINCT RepName,CustName
FROM SALESREP,CUSTOMER
WHERE Balance > 400; 
C) SELECT *
FROM SALESREP,CUSTOMER
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo
AND Balance > 400; 
D) SELECT RepName,CustName
FROM SALESREP,CUSTOMER
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo
AND Balance > 400; 
E) SELECT RepName,CustName
FROM SALESREP,CUSTOMER
WHERE Balance > 400
GROUP BY SalesRepNo;

Question 16

The rows of the result table can be sorted by the values in one or more columns.

Accepted Answer

A) True 
 B)False

Question 17

When one SQL query is embedded in another SQL query,the first SQL query can still contain an SQL ________ clause.

Accepted Answer

A) FROM THE 
B) WHERE THE 
C) ORDER BY 
D) GROUP BY 
E) C and D 
A) FROM THE 
B) WHERE THE 
C) ORDER BY 
D) GROUP BY 
E) C and D

Question 18

A nested SELECT statement (one that appears within the WHERE clause of another SQL statement)is called a subquery and must be enclosed in parentheses.

Accepted Answer

A) True 
 B)False

Question 19

The SQL keyword SELECT is used to specify the columns to be listed in the query results.

Accepted Answer

A) True 
 B)False

Question 20

SQL is a ________.

Accepted Answer

A) data sublanguage 
B) product of IBM research 
C) national standard 
D) combination that include a data definition language and a data manipulation language 
E) All of the above. 
A) data sublanguage 
B) product of IBM research 
C) national standard 
D) combination that include a data definition language and a data manipulation language 
E) All of the above.

Exam 2: Introduction to Structured Query Language SQL

In an SQL query,which SQL keyword must be used to remove duplicate rows from the result table?

In an SQL query,which SQL keyword is used to specify the column names to be used in a join?

The SQL keyword FROM is used to specify the table to be used.

SQL commands can be embedded in application programs.

An asterisk (*)following the SELECT verb means that all columns are to be displayed.

Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the following would find all employees whose name begins with the letter "S" using standard SQL?

In an SQL query,which SQL keyword is used to implement a subquery?

SQL stands for Standard Query Language.

Based on the tables below,which of the following ANSI SQL commands would return the average customer balance grouped by SalesRepNo? GENERAL SALES DATABASE: SALESREP CUSTOMER

The Microsoft Access wildcard character "*" (asterisk)indicates a sequence of one or more unspecified characters in a Microsoft Access SQL query.

In an SQL query,which of the following symbols is used by ANSI SQL to represent a single unspecified character?

SQL,although very popular,has never become a national standard.

The clause SELECT COUNT (*)results in a table with a single row and a single column.

To have SQL automatically eliminate duplicate rows from a result,use the keyword DISTINCT with the FROM keyword.

Based on the tables below,which of the following commands in ANSI SQL would return only the name of the sales representative and the name of the customer for each customer that has a balance greater than 400? GENERAL SALES DATABASE: SALESREP CUSTOMER

The rows of the result table can be sorted by the values in one or more columns.

When one SQL query is embedded in another SQL query,the first SQL query can still contain an SQL ________ clause.

A nested SELECT statement (one that appears within the WHERE clause of another SQL statement)is called a subquery and must be enclosed in parentheses.

The SQL keyword SELECT is used to specify the columns to be listed in the query results.

SQL is a ________.

Introduction

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters