Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 3

Based on the tables below,which of the following ANSI SQL commands would return the average customer balance grouped by SalesRepNo? GENERAL SALES DATABASE:
SALESREP
 
CUSTOMER

Accepted Answer

A) SELECT AVG (Balance)
FROM CUSTOMER
WHERE SalesRepNo; 
B) SELECT AVG (Balance)
FROM CUSTOMER
GROUP BY SalesRepNo; 
C) SELECT AVG (Balance)
FROM CUSTOMER,SALESREP
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo; 
D) SELECT AVG (Balance)
FROM CUSTOMER
ORDER BY SalesRepNo; 
E) SELECT AVG (Balanc
E) 
FROM CUSTOMER,SALESREP
WHERE CUSTOMER.SalesRepNo = CUSTOMER.SalesRepNo
HAVING SalesRepNo; 
A) SELECT AVG (Balance)
FROM CUSTOMER
WHERE SalesRepNo; 
B) SELECT AVG (Balance)
FROM CUSTOMER
GROUP BY SalesRepNo; 
C) SELECT AVG (Balance)
FROM CUSTOMER,SALESREP
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo; 
D) SELECT AVG (Balance)
FROM CUSTOMER
ORDER BY SalesRepNo; 
E) SELECT AVG (Balanc
E) 
FROM CUSTOMER,SALESREP
WHERE CUSTOMER.SalesRepNo = CUSTOMER.SalesRepNo
HAVING SalesRepNo;

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

The SQL keyword FROM is used to specify the table to be used.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Question 8

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 9

SQL is a ________.

Accepted Answer

A) data sublanguage 
B) product of IBM research 
C) national standard 
D) combination that includes a data definition language and a data manipulation language 
E) All of the above 
A) data sublanguage 
B) product of IBM research 
C) national standard 
D) combination that includes a data definition language and a data manipulation language 
E) All of the above

Question 10

In an SQL query,which SQL keyword is used to sort the result table by the values in one or more columns?

Accepted Answer

A) GROUP BY 
B) ORDER BY 
C) SELECT 
D) SORT BY 
E) WHERE 
A) GROUP BY 
B) ORDER BY 
C) SELECT 
D) SORT BY 
E) WHERE

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

SQL statements end with a colon.

Accepted Answer

A) True 
 B)False

Question 15

To have SQL automatically eliminate duplicate rows from a result,use the keyword DISTINCT with the FROM keyword.

Accepted Answer

A) True 
 B)False

Question 16

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 17

In an SQL query,which SQL keyword is used to specify the table(s)to be used?

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

A nested SELECT statement (one that appears within the WHERE clause of another SQL statement)is called a subquery and must be enclosed in parentheses.

Accepted Answer

A) True 
 B)False

Question 20

What is SQL?

Accepted Answer

Structured Query Language (SQL)is used t

Exam 2: Introduction to Structured Query Language SQL

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

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.

Based on the tables below,which of the following ANSI SQL commands would return the average customer balance grouped by SalesRepNo? GENERAL SALES DATABASE: SALESREP CUSTOMER

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

The SQL keyword FROM is used to specify the table to be used.

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

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?

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

SQL is a ________.

In an SQL query,which SQL keyword is used to sort the result table by the values in one or more columns?

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

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

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

SQL statements end with a colon.

To have SQL automatically eliminate duplicate rows from a result,use the keyword DISTINCT with the FROM keyword.

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

In an SQL query,which SQL keyword is used to specify the table(s)to be used?

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

A nested SELECT statement (one that appears within the WHERE clause of another SQL statement)is called a subquery and must be enclosed in parentheses.

What is SQL?

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