Question 1

SQL commands can be embedded in application programs.

Accepted Answer

A) True 
 B)False  True

Question 2

The result of an SQL SELECT operation can contain duplicate rows.

Accepted Answer

A) True 
 B)False  True

Question 3

In an SQL query,the built-in function COUNT works with columns containing data of which of the following data types?

Accepted Answer

A) Integer 
B) Numeric 
C) Char 
D) A and B 
E) A,B,and C 
A) Integer 
B) Numeric 
C) Char 
D) A and B 
E) A,B,and C E

Question 4

In an SQL query,which of the following symbols is used by Microsoft Access 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 5

The SQL built-in function ADDUP totals values in numeric columns.

Accepted Answer

A) True 
 B)False

Question 6

Outer joins can be either up joins or down joins.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

In an SQL query,a join operation is achieved by specifying the equality of the respective column names as a condition in the WHERE clause.

Accepted Answer

A) True 
 B)False

Question 9

The American National Standards Institute (ANSI)maintains the standards for SQL.

Accepted Answer

A) True 
 B)False

Question 10

SQL stands for Standard Query Language.

Accepted Answer

A) True 
 B)False

Question 11

In an SQL query,which SQL keyword is used to state the condition that specifies which rows are to be selected?

Accepted Answer

A) EXISTS 
B) FROM 
C) SELECT 
D) SET 
E) WHERE 
A) EXISTS 
B) FROM 
C) SELECT 
D) SET 
E) WHERE

Question 12

To remove duplicate rows from the result of a query,specify the SQL DISTINCT keyword.

Accepted Answer

A) True 
 B)False

Question 13

The SQL keyword WHERE is used to specify the table(s)that contain(s)the data to be retrieved.

Accepted Answer

A) True 
 B)False

Question 14

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 15

Sorting is specified by the use of the SORT BY phrase.

Accepted Answer

A) True 
 B)False

Question 16

In addition to being a data sublanguage,SQL is also a programming language,like Java or C#.

Accepted Answer

A) True 
 B)False

Question 17

The SQL keyword LIKE is used in SQL expressions to select on partial values.

Accepted Answer

A) True 
 B)False

Question 18

Distinguish between the HAVING clause and the WHERE clause.

Accepted Answer

The HAVING clause and the WHERE clause d

Question 19

In an SQL query,which SQL keyword is used to join two conditions that both must be true for the rows to be selected?

Accepted Answer

A) AND 
B) EXISTS 
C) HAVING 
D) IN 
E) OR 
A) AND 
B) EXISTS 
C) HAVING 
D) IN 
E) OR

Question 20

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

Exam 2: Introduction to Structured Query Language SQL

SQL commands can be embedded in application programs.

The result of an SQL SELECT operation can contain duplicate rows.

In an SQL query,the built-in function COUNT works with columns containing data of which of the following data types?

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

The SQL built-in function ADDUP totals values in numeric columns.

Outer joins can be either up joins or down joins.

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

In an SQL query,a join operation is achieved by specifying the equality of the respective column names as a condition in the WHERE clause.

The American National Standards Institute (ANSI)maintains the standards for SQL.

SQL stands for Standard Query Language.

In an SQL query,which SQL keyword is used to state the condition that specifies which rows are to be selected?

To remove duplicate rows from the result of a query,specify the SQL DISTINCT keyword.

The SQL keyword WHERE is used to specify the table(s)that contain(s)the data to be retrieved.

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

Sorting is specified by the use of the SORT BY phrase.

In addition to being a data sublanguage,SQL is also a programming language,like Java or C#.

The SQL keyword LIKE is used in SQL expressions to select on partial values.

Distinguish between the HAVING clause and the WHERE clause.

In an SQL query,which SQL keyword is used to join two conditions that both must be true for the rows to be selected?

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

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

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

Microsoft Access 2013

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 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters