Question 1

When one SQL query is embedded in another SQL query to simulate a join,the second SQL query is embedded in the ________ of the first query.

Accepted Answer

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

Question 2

The following database will be used in this question:
GENERAL SALES DATABASE:
SALESREP
   CUSTOMER
   Explain the use of the of SQL keyword SELECT.Include an example based on the CUSTOMER table in the General Sales database.

Accepted Answer

The SQL keyword SELECT forms the basis for all SQL querying.Although SELECT technically specifies columns to be used in a query,it is always the first SQL keyword or command in an SQL phrase that includes at least the SQL keyword FROM and often the SQL keyword WHERE.The SQL keyword FROM is used to specify which tables are used in the query,while the SQL keyword WHERE is used to specify conditions or constraints imposed on the query.For example,
SELECT *
FROM CUSTOMER
WHERE CustNo = 8590;
is a query that returns all information in the table CUSTOMER about the customer whose customer number is 8590.

Question 3

A SELECT statement used in a WHERE clause is called a subquery.

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 Microsoft Access?

Accepted Answer

A) SELECT *
FROM EMPLOYEE
WHERE Name IN ['S']; 
B) SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S'; 
C) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S*'; 
D) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%'; 
A) SELECT *
FROM EMPLOYEE
WHERE Name IN ['S']; 
B) SELECT EmpNo
FROM EMPLOYEE
WHERE Name LIKE 'S'; 
C) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S*'; 
D) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'S%';

Question 6

SQL was developed by IBM in the late 1970s.

Accepted Answer

A) True 
 B)False

Question 7

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) JOIN 
C) SELECT 
D) WHERE 
A) FROM 
B) JOIN 
C) SELECT 
D) WHERE

Question 8

When one SQL query is embedded in another SQL query,this is referred to as a ________.

Accepted Answer

A) subquery 
B) join 
C) WHERE Query 
D) subset query 
A) subquery 
B) join 
C) WHERE Query 
D) subset query

Question 9

In an SQL query,which SQL keyword is used with built-in functions to group together rows that have the same value in a specified column or columns?

Accepted Answer

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

Question 10

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

Accepted Answer

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

Question 11

Joins that show only matching rows from the joined tables in their results are called inner joins.

Accepted Answer

A) True 
 B)False

Question 12

The UNION of two relations A and B consists of all rows that are either in relation A or in relation B or both.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

SQL statements end with a colon.

Accepted Answer

A) True 
 B)False

Question 15

In an SQL query,which built-in function is used to obtain the smallest value of numeric columns?

Accepted Answer

A) AVG 
B) COUNT 
C) MAX 
D) MIN 
A) AVG 
B) COUNT 
C) MAX 
D) MIN

Question 16

Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the following is not a valid ANSI SQL command?

Accepted Answer

A) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'Ja%'; 
B) SELECT COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000; 
C) SELECT HireDate,COUNT(*)
FROM EMPLOYEE
GROUP BY HireDate; 
D) SELECT HireDate,COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000; 
A) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'Ja%'; 
B) SELECT COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000; 
C) SELECT HireDate,COUNT(*)
FROM EMPLOYEE
GROUP BY HireDate; 
D) SELECT HireDate,COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000;

Question 17

In an SQL query,which built-in function is used to total numeric columns?

Accepted Answer

A) AVG 
B) COUNT 
C) MAX 
D) SUM 
A) AVG 
B) COUNT 
C) MAX 
D) SUM

Question 18

Assuming the "Quantity" column of an ORDER table contains integer data,what does COUNT(Quantity)compute?

Accepted Answer

A) The number of rows in the ORDER table 
B) The number of non-zero values in the Quantity column 
C) The number of distinct values in the Quantity column 
D) The number of non-null values in the Quantity column 
A) The number of rows in the ORDER table 
B) The number of non-zero values in the Quantity column 
C) The number of distinct values in the Quantity column 
D) The number of non-null values in the Quantity column

Question 19

SQL can only query a single table.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 2: Introduction to Structured Query Language

When one SQL query is embedded in another SQL query to simulate a join,the second SQL query is embedded in the ________ of the first query.

The following database will be used in this question: GENERAL SALES DATABASE: SALESREP CUSTOMER Explain the use of the of SQL keyword SELECT.Include an example based on the CUSTOMER table in the General Sales database.

A SELECT statement used in a WHERE clause is called a subquery.

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

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 Microsoft Access?

SQL was developed by IBM in the late 1970s.

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

When one SQL query is embedded in another SQL query,this is referred to as a ________.

In an SQL query,which SQL keyword is used with built-in functions to group together rows that have the same value in a specified column or columns?

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

Joins that show only matching rows from the joined tables in their results are called inner joins.

The UNION of two relations A and B consists of all rows that are either in relation A or in relation B or both.

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

SQL statements end with a colon.

In an SQL query,which built-in function is used to obtain the smallest value of numeric columns?

Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the following is not a valid ANSI SQL command?

In an SQL query,which built-in function is used to total numeric columns?

Assuming the "Quantity" column of an ORDER table contains integer data,what does COUNT(Quantity)compute?

SQL can only query a single table.

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

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