Question 1

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 2

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 3

What are SQL Built-in Functions?

Accepted Answer

SQL Built-in Functions are functions tha

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

To obtain all columns,use an asterisk (*)wildcard character instead of listing all the column names.

Accepted Answer

A) True 
 B)False

Question 6

What is SQL?

Accepted Answer

Structured Query Language (SQL)is used t

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

The SQL built-in function AVG computes the average of values in numeric columns.

Accepted Answer

A) True 
 B)False

Question 10

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 11

To exclude one or more values using a condition,the SQL OUT keyword must be used.

Accepted Answer

A) True 
 B)False

Question 12

To sort the rows of the result table,the ORDER BY clause is specified.

Accepted Answer

A) True 
 B)False

Question 13

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 14

Two or more tables are joined by giving the table names in the WHERE clause and specifying the equality of the respective column names as a condition in the GROUP BY clause.

Accepted Answer

A) True 
 B)False

Question 15

An alternative to combining tables by a subquery is to use a join.

Accepted Answer

A) True 
 B)False

Question 16

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 17

SQL is only a data manipulation language (DML).

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 2: Introduction to Structured Query Language SQL

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

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

What are SQL Built-in Functions?

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

To obtain all columns,use an asterisk (*)wildcard character instead of listing all the column names.

What is SQL?

Regarding the interchangeability of subqueries and joins,

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

The SQL built-in function AVG computes the average of values in numeric columns.

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.

To exclude one or more values using a condition,the SQL OUT keyword must be used.

To sort the rows of the result table,the ORDER BY clause is specified.

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?

Two or more tables are joined by giving the table names in the WHERE clause and specifying the equality of the respective column names as a condition in the GROUP BY clause.

An alternative to combining tables by a subquery is to use a join.

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

SQL is only a data manipulation language (DML).

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

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

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

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 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

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 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters