Question 1

SQL is only a data manipulation language (DML).

Accepted Answer

A) True 
 B)False

Question 2

In an SQL query,which SQL keyword is used to specify the names of tables to be joined?

Accepted Answer

A) FROM 
B) HAVING 
C) JOIN 
D) WHERE 
A) FROM 
B) HAVING 
C) JOIN 
D) WHERE

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

In an SQL query,which SQL keyword must be used to remove duplicate rows from the result table?

Accepted Answer

A) DELETE 
B) DISTINCT 
C) UNIQUE 
D) KEY 
A) DELETE 
B) DISTINCT 
C) UNIQUE 
D) KEY

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

An ad-hoc query is ________.

Accepted Answer

A) a question about the data that requires a program to be written 
B) a question that can be answered from the database using SQL 
C) a question that can be answered only by combining several SQL queries 
D) never useful in Business Intelligence scenarios 
A) a question about the data that requires a program to be written 
B) a question that can be answered from the database using SQL 
C) a question that can be answered only by combining several SQL queries 
D) never useful in Business Intelligence scenarios

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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) OR 
D) IN 
A) AND 
B) EXISTS 
C) OR 
D) IN

Question 9

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 10

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 11

SQL commands can be embedded in application programs.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

Based on the tables below,which of the following commands in ANSI SQL would return only the name of the sales representative and the name of the customer for each customer that has a balance greater than 400? GENERAL SALES DATABASE:
SALESREP
  CUSTOMER

Accepted Answer

A) SELECT *
FROM SALESREP,CUSTOMER
WHERE Balance > 400; 
B) SELECT DISTINCT RepName,CustName
FROM SALESREP,CUSTOMER
WHERE Balance > 400; 
C) SELECT *
FROM SALESREP,CUSTOMER
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo
AND Balance > 400; 
D) SELECT RepName,CustName
FROM SALESREP,CUSTOMER
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo
AND Balance > 400; 
A) SELECT *
FROM SALESREP,CUSTOMER
WHERE Balance > 400; 
B) SELECT DISTINCT RepName,CustName
FROM SALESREP,CUSTOMER
WHERE Balance > 400; 
C) SELECT *
FROM SALESREP,CUSTOMER
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo
AND Balance > 400; 
D) SELECT RepName,CustName
FROM SALESREP,CUSTOMER
WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo
AND Balance > 400;

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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) Both A and B are correct 
A) LEFT JOIN 
B) RIGHT JOIN 
C) INCLUDE 
D) Both A and B are correct

Question 20

A database extracted from the operational database for BI purposes typically ________.

Accepted Answer

A) is an exact copy of the operational database 
B) contains only the metadata from the operational database 
C) combines all the data from the operational database into one large table 
D) contains just part of the operational database 
A) is an exact copy of the operational database 
B) contains only the metadata from the operational database 
C) combines all the data from the operational database into one large table 
D) contains just part of the operational database

Exam 2: Introduction to Structured Query Language

SQL is only a data manipulation language (DML).

In an SQL query,which SQL keyword is used to specify the names of tables to be joined?

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

In an SQL query,which SQL keyword must be used to remove duplicate rows from the result table?

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

An ad-hoc query is ________.

The SQL built-in function MIN obtains the smallest value in a numeric 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?

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.

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

SQL commands can be embedded in application programs.

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.

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

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

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

Based on the tables below,which of the following commands in ANSI SQL would return only the name of the sales representative and the name of the customer for each customer that has a balance greater than 400? GENERAL SALES DATABASE: SALESREP CUSTOMER

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.

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

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?

A database extracted from the operational database for BI purposes typically ________.

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 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters