Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

The SQL keyword LIKE is used in SQL expressions to select on partial values.

Accepted Answer

A) True 
 B)False

Question 3

The SQL built-in function MIN obtains the smallest value in a numeric column.

Accepted Answer

A) True 
 B)False

Question 4

Only two tables can be queried by using a subquery.

Accepted Answer

A) True 
 B)False

Question 5

Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the following is not a valid ANSI SQL command?

Accepted Answer

A) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'Ja%'; 
B) SELECT COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000; 
C) SELECT COUNT(EmpNo)
FROM EMPLOYEE; 
D) SELECT HireDate,COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000; 
E) SELECT HireDate,COUNT(*)
FROM EMPLOYEE
GROUP BY HireDate; 
A) SELECT *
FROM EMPLOYEE
WHERE Name LIKE 'Ja%'; 
B) SELECT COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000; 
C) SELECT COUNT(EmpNo)
FROM EMPLOYEE; 
D) SELECT HireDate,COUNT(*)
FROM EMPLOYEE
WHERE Salary < 30000; 
E) SELECT HireDate,COUNT(*)
FROM EMPLOYEE
GROUP BY HireDate;

Question 6

In an SQL query,which SQL keyword is used to join two conditions that both must be true for the rows to be selected?

Accepted Answer

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

Question 7

SQL statements end with a colon.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

In an SQL query,the built-in function COUNT works 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 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The built-in function SUM can be used with any column.

Accepted Answer

A) True 
 B)False

Question 14

Sorting is specified by the use of the SORT BY phrase.

Accepted Answer

A) True 
 B)False

Question 15

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 16

SQL can only query a single table.

Accepted Answer

A) True 
 B)False

Question 17

In an SQL query,a join operation is achieved by specifying the equality of the respective column names as a condition in the WHERE clause.

Accepted Answer

A) True 
 B)False

Question 18

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 19

SQL was developed by IBM in the late 1970s.

Accepted Answer

A) True 
 B)False

Question 20

In an SQL query,which SQL keyword is used to determine if a column value is equal to any one of a set of values?

Accepted Answer

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

Exam 2: Introduction to Structured Query Language SQL

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

The SQL keyword LIKE is used in SQL expressions to select on partial values.

The SQL built-in function MIN obtains the smallest value in a numeric column.

Only two tables can be queried by using a subquery.

Given a table with the structure: EMPLOYEE (EmpNo,Name,Salary,HireDate),which of the following is not a valid ANSI SQL command?

In an SQL query,which SQL keyword is used to join two conditions that both must be true for the rows to be selected?

SQL statements end with a colon.

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

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

In an SQL query,the built-in function COUNT works with columns containing data of which of the following data types?

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

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

The built-in function SUM can be used with any column.

Sorting is specified by the use of the SORT BY phrase.

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.

SQL can only query a single table.

In an SQL query,a join operation is achieved by specifying the equality of the respective column names as a condition in the WHERE clause.

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

SQL was developed by IBM in the late 1970s.

In an SQL query,which SQL keyword is used to determine if a column value is equal to any one of a set of values?

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