Question 1

The SQL syntax JOIN ...ON can be used as alternate way of writing an SQL join statement.

Accepted Answer

A) True 
 B)False

Question 2

In an SQL query,which built-in function is used to compute the number of rows in a table?

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

Accepted Answer

A) True 
 B)False

Question 6

SQL can only query a single table.

Accepted Answer

A) True 
 B)False

Question 7

A WHERE clause can contain only one condition.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

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?

Accepted Answer

A) GROUP BY 
B) ORDER BY 
C) SELECT 
D) SORT BY 
E) DISTINCT SET 
A) GROUP BY 
B) ORDER BY 
C) SELECT 
D) SORT BY 
E) DISTINCT SET

Question 11

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Briefly describe subqueries and joins.Explain when each is not an acceptable alternative for the other.

Accepted Answer

Subqueries and joins are both methods fo

Question 14

The WHERE clause contains the condition that specifies which columns are to be selected.

Accepted Answer

A) True 
 B)False

Question 15

While many subqueries can be alternatively written as joins,correlated subqueries do work that cannot be duplicated as a join.

Accepted Answer

A) True 
 B)False

Question 16

To refer to a set of values needed for a condition,use the SQL IN operator.

Accepted Answer

A) True 
 B)False

Question 17

What are SQL Built-in Functions?

Accepted Answer

SQL Built-in Functions are functions tha

Question 18

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

Accepted Answer

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

Question 19

The SQL wildcard character "%" represents a series of one or more unspecified characters.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 2: Introduction to Structured Query Language SQL

The SQL syntax JOIN ...ON can be used as alternate way of writing an SQL join statement.

In an SQL query,which built-in function is used to compute the number of rows in a table?

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

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

The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

SQL can only query a single table.

A WHERE clause can contain only one condition.

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

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 with built-in functions to group together rows that have the same value in a specified column?

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

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

Briefly describe subqueries and joins.Explain when each is not an acceptable alternative for the other.

The WHERE clause contains the condition that specifies which columns are to be selected.

While many subqueries can be alternatively written as joins,correlated subqueries do work that cannot be duplicated as a join.

To refer to a set of values needed for a condition,use the SQL IN operator.

What are SQL Built-in Functions?

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

The SQL wildcard character "%" represents a series of one or more unspecified characters.

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

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