Question 1

SQL was developed by IBM in the late 1970s.

Accepted Answer

A) True 
 B)False

Question 2

Regarding the interchangeability of subqueries and joins,

Accepted Answer

A) a join can always be used as an alternative to a subquery,and a subquery can always be used as an alternative to a join. 
B) a join can sometimes be used as an alternative to a subquery,and a subquery can sometimes be used as an alternative to a join. 
C) a join can always be used as an alternative to a subquery,and a subquery can sometimes be used as an alternative to a join. 
D) a join can sometimes be used as an alternative to a subquery,and a subquery can always be used as an alternative to a join. 
E) a join can never be used as an alternative to a subquery,and a subquery can never be used as an alternative to a join. 
A) a join can always be used as an alternative to a subquery,and a subquery can always be used as an alternative to a join. 
B) a join can sometimes be used as an alternative to a subquery,and a subquery can sometimes be used as an alternative to a join. 
C) a join can always be used as an alternative to a subquery,and a subquery can sometimes be used as an alternative to a join. 
D) a join can sometimes be used as an alternative to a subquery,and a subquery can always be used as an alternative to a join. 
E) a join can never be used as an alternative to a subquery,and a subquery can never be used as an alternative to a join.

Question 3

The columns to be obtained by an SQL command are listed after the FROM keyword.

Accepted Answer

A) True 
 B)False

Question 4

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 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 5

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 f

Question 6

Only two tables can be queried by using a subquery.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

The GROUP BY keyword is used in conjunct

Question 9

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

Accepted Answer

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

Question 10

The SQL built-in function COUNT computes the number of rows in a 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

When two conditions must both be true for the rows to be selected,the conditions are separated by the SQL AND keyword.

Accepted Answer

A) True 
 B)False

Question 13

Every subquery can be alternatively expressed by a join.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

In an SQL query,the built-in functions SUM and AVG work 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

Question 18

In an SQL query,which SQL keyword is used to specify the names of tables to be joined?

Accepted Answer

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

Question 19

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 
E) SUM 
A) AVG 
B) COUNT 
C) MAX 
D) MIN 
E) SUM

Question 20

Joins that show the matching rows from the joined tables plus unmatched rows from one other table in their results are called outer joins.

Accepted Answer

A) True 
 B)False

Exam 2: Introduction to Structured Query Language SQL

SQL was developed by IBM in the late 1970s.

Regarding the interchangeability of subqueries and joins,

The columns to be obtained by an SQL command are listed after the FROM keyword.

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?

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.

Only two tables can be queried by using a subquery.

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

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

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

The SQL built-in function COUNT computes the number of rows in a query.

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

When two conditions must both be true for the rows to be selected,the conditions are separated by the SQL AND keyword.

Every subquery can be alternatively expressed by a join.

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

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

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

In an SQL query,the built-in functions SUM and AVG work with columns containing data of which of the following data types?

In an SQL query,which SQL keyword is used to specify the names of tables to be joined?

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

Joins that show the matching rows from the joined tables plus unmatched rows from one other table in their results are called outer joins.

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