Question 1

In an SQL query,which SQL keyword actually begins the query?

Accepted Answer

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

Question 2

Arithmetic in SQL statements is limited to the operations provided by the built-in functions.

Accepted Answer

A) True 
 B)False

Question 3

When people use the term join they normally mean an equijoin.

Accepted Answer

A) True 
 B)False

Question 4

To refer to a set of values in a condition,the values are placed inside parentheses ( )and separated by commas.

Accepted Answer

A) True 
 B)False

Question 5

In an SQL query,which SQL keyword is used with GROUP BY to select groups meeting specified criteria?

Accepted Answer

A) AND 
B) WHERE 
C) HAVING 
D) IN 
A) AND 
B) WHERE 
C) HAVING 
D) IN

Question 6

A WHERE clause can contain another SELECT statement enclosed in parentheses.

Accepted Answer

A) True 
 B)False

Question 7

Distinguish between the HAVING clause and the WHERE clause.

Accepted Answer

The HAVING clause and the WHERE clause d

Question 8

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

Accepted Answer

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

Question 9

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance),write the standard SQL query to retrieve the Name and PhoneNumber of customers whose name begins with 'S'.

Accepted Answer

SELECT Name,PhoneNum

Question 10

In an SQL query,which of the following symbols is used by ANSI SQL to represent all the columns in a single table?

Accepted Answer

A) _ (underscore) 
B) $?$ (question mark) 
C) * (asterisk) 
D) % (percent) 
A) _ (underscore) 
B) $?$ (question mark) 
C) * (asterisk) 
D) % (percent)

Question 11

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

Accepted Answer

A) FROM or SORT BY 
B) UNIQUE IN 
C) GROUP BY 
D) WHERE IN 
A) FROM or SORT BY 
B) UNIQUE IN 
C) GROUP BY 
D) WHERE IN

Question 12

The built-in function SUM can be used with any column.

Accepted Answer

A) True 
 B)False

Question 13

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance),write the standard SQL query to retrieve the Name and PhoneNumber of customers with a balance greater than 50.

Accepted Answer

SELECT Name,PhoneNum

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

The names of tables to be joined in an SQL query are listed in the FROM clause.

Accepted Answer

A) True 
 B)False

Question 17

Suppose tables EMPLOYEE and CUSTOMER both store address information,and you want to send a letter to all employees and customers of your company to make a major announcement.Which SQL keyword would you most likely use here?

Accepted Answer

A) INTERSECT 
B) UNION 
C) UNION ALL 
D) JOIN 
A) INTERSECT 
B) UNION 
C) UNION ALL 
D) JOIN

Question 18

SQL includes a data definition language,a data manipulation language,and SQL/Persistent stored modules.

Accepted Answer

A) True 
 B)False

Question 19

SQL stands for Standard Query Language.

Accepted Answer

A) True 
 B)False

Question 20

Only two tables can be queried by using a subquery.

Accepted Answer

A) True 
 B)False

Exam 2: Introduction to Structured Query Language

In an SQL query,which SQL keyword actually begins the query?

Arithmetic in SQL statements is limited to the operations provided by the built-in functions.

When people use the term join they normally mean an equijoin.

To refer to a set of values in a condition,the values are placed inside parentheses ( )and separated by commas.

In an SQL query,which SQL keyword is used with GROUP BY to select groups meeting specified criteria?

A WHERE clause can contain another SELECT statement enclosed in parentheses.

Distinguish between the HAVING clause and the WHERE clause.

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

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance),write the standard SQL query to retrieve the Name and PhoneNumber of customers whose name begins with 'S'.

In an SQL query,which of the following symbols is used by ANSI SQL to represent all the columns in a single table?

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

The built-in function SUM can be used with any column.

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance),write the standard SQL query to retrieve the Name and PhoneNumber of customers with a balance greater than 50.

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

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

The names of tables to be joined in an SQL query are listed in the FROM clause.

Suppose tables EMPLOYEE and CUSTOMER both store address information,and you want to send a letter to all employees and customers of your company to make a major announcement.Which SQL keyword would you most likely use here?

SQL includes a data definition language,a data manipulation language,and SQL/Persistent stored modules.

SQL stands for Standard Query Language.

Only two tables can be queried by using 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

Managing Databases With SQL Server 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters