Question 1

SQL is only a data manipulation language (DML).

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

In an SQL query of two tables,which SQL keyword indicates that we want data from all the rows of one table to be included in the result,even if the row does not correspond to any data in the other table?

Accepted Answer

A) LEFT JOIN 
B) RIGHT JOIN 
C) INCLUDE 
D) A and B 
E) A,B,and C 
A) LEFT JOIN 
B) RIGHT JOIN 
C) INCLUDE 
D) A and B 
E) A,B,and C

Question 4

The rows of the result table can be sorted by the values in one or more columns.

Accepted Answer

A) True 
 B)False

Question 5

The SQL keyword SELECT is used to specify the columns to be listed in the query results.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

The LIKE keyword is used in the WHERE cl

Question 7

The Microsoft Access wildcard character "_" (underscore)indicates a single,unspecified character in a specific location in a Microsoft Access SQL query.

Accepted Answer

A) True 
 B)False

Question 8

SQL is not a complete programming language.Rather it is a data sublanguage.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

SELECT Name,PhoneNum

Question 12

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance),write the standard SQL query to retrieve the Name and PhoneNumber of customers whose name begins with 'S'.

Accepted Answer

SELECT Name,PhoneNum

Question 13

When one SQL query is embedded in another SQL query,the second SQL query is embedded in the ________ of the first query.

Accepted Answer

A) SELECT 
B) FROM 
C) WHERE 
D) GROUP BY 
E) HAVING 
A) SELECT 
B) FROM 
C) WHERE 
D) GROUP BY 
E) HAVING

Question 14

The clause SELECT COUNT (*)results in a table with a single row and a single column.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

To refer to a set of values in a condition,the values are placed inside parentheses ( )and separated by commas.

Accepted Answer

A) True 
 B)False

Question 17

The Microsoft Access wildcard character "*" (asterisk)indicates a sequence of one or more unspecified characters in a Microsoft Access SQL query.

Accepted Answer

A) True 
 B)False

Question 18

The SQL wildcard character "#" indicates a single,unspecified character in a specific location in an SQL query.

Accepted Answer

A) True 
 B)False

Question 19

In an SQL query,which of the following symbols is used by ANSI SQL to represent all the columns in a single table?

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 20

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

Accepted Answer

A) True 
 B)False

Exam 2: Introduction to Structured Query Language SQL

SQL is only a data manipulation language (DML).

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

In an SQL query of two tables,which SQL keyword indicates that we want data from all the rows of one table to be included in the result,even if the row does not correspond to any data in the other table?

The rows of the result table can be sorted by the values in one or more columns.

The SQL keyword SELECT is used to specify the columns to be listed in the query results.

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

The Microsoft Access wildcard character "_" (underscore)indicates a single,unspecified character in a specific location in a Microsoft Access SQL query.

SQL is not a complete programming language.Rather it is a data sublanguage.

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

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

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

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance),write the standard SQL query to retrieve the Name and PhoneNumber of customers whose name begins with 'S'.

When one SQL query is embedded in another SQL query,the second SQL query is embedded in the ________ of the first query.

The clause SELECT COUNT (*)results in a table with a single row and a single column.

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

To refer to a set of values in a condition,the values are placed inside parentheses ( )and separated by commas.

The Microsoft Access wildcard character "*" (asterisk)indicates a sequence of one or more unspecified characters in a Microsoft Access SQL query.

The SQL wildcard character "#" indicates a single,unspecified character in a specific location in an SQL query.

In an SQL query,which of the following symbols is used by ANSI SQL to represent all the columns in a single table?

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

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