Question 1

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 2

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 3

When making an SQL query,we are using SQL as a(n)________.

Accepted Answer

A) DDL 
B) DML 
C) embedded language 
D) SET 
E) WHERE 
A) DDL 
B) DML 
C) embedded language 
D) SET 
E) WHERE

Question 4

Explain why it is important to learn SQL.

Accepted Answer

Most modern DBMS products support SQL as

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

The SQL built-in function MOST obtains the largest value in a numeric column.

Accepted Answer

A) True 
 B)False

Question 11

Distinguish between the HAVING clause and the WHERE clause.

Accepted Answer

The HAVING clause and the WHERE clause d

Question 12

Columns can be sorted in descending sequence by using the SQL DESC keyword.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 15

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 16

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

Accepted Answer

SELECT Name,PhoneNum

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

In an SQL query,which of the following symbols is used by Microsoft Access 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 19

A WHERE clause can contain only one condition.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 2: Introduction to Structured Query Language SQL

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

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

When making an SQL query,we are using SQL as a(n)________.

Explain why it is important to learn SQL.

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

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

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

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

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

The SQL built-in function MOST obtains the largest value in a numeric column.

Distinguish between the HAVING clause and the WHERE clause.

Columns can be sorted in descending sequence by using the SQL DESC keyword.

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?

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.

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

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

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

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

A WHERE clause can contain only one condition.

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

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