Question 1

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) WHERE 
A) EXISTS 
B) FROM 
C) SELECT 
D) WHERE

Question 2

Regarding the interchangeability of subqueries and joins,________.

Accepted Answer

A) a join can always be used as an alternative to a subquery,and a subquery can always be used as an alternative to a join 
B) a join can sometimes be used as an alternative to a subquery,and a subquery can sometimes be used as an alternative to a join 
C) a join can always be used as an alternative to a subquery,and a subquery can sometimes be used as an alternative to a join 
D) a join can sometimes be used as an alternative to a subquery,and a subquery can always be used as an alternative to a join 
A) a join can always be used as an alternative to a subquery,and a subquery can always be used as an alternative to a join 
B) a join can sometimes be used as an alternative to a subquery,and a subquery can sometimes be used as an alternative to a join 
C) a join can always be used as an alternative to a subquery,and a subquery can sometimes be used as an alternative to a join 
D) a join can sometimes be used as an alternative to a subquery,and a subquery can always be used as an alternative to a join

Question 3

Suppose your company stores EMPLOYEE and CUSTOMER data in separate tables.If you want to find all customers who are not also employees,which SQL keyword would you most likely use?

Accepted Answer

A) INTERSECT 
B) UNION 
C) EXCEPT 
D) UNION ALL 
A) INTERSECT 
B) UNION 
C) EXCEPT 
D) UNION ALL

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

What are SQL Built-in Functions?

Accepted Answer

SQL Built-in Functions are functions tha

Question 6

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

Accepted Answer

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

Question 7

In addition to being a data sublanguage,SQL is also a programming language,like Java or C#.

Accepted Answer

A) True 
 B)False

Question 8

Explain why it is important to learn SQL.

Accepted Answer

Most modern DBMS products support SQL as

Question 9

The condition in WHERE clauses can refer to a set of values by using the IN operator.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

A WHERE clause can contain only one condition.

Accepted Answer

A) True 
 B)False

Question 13

Business Intelligence (BI)systems typically store their data in data warehouses.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

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

Regarding the interchangeability of subqueries and joins,________.

Suppose your company stores EMPLOYEE and CUSTOMER data in separate tables.If you want to find all customers who are not also employees,which SQL keyword would you most likely use?

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

What are SQL Built-in Functions?

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

In addition to being a data sublanguage,SQL is also a programming language,like Java or C#.

Explain why it is important to learn SQL.

The condition in WHERE clauses can refer to a set of values by using the IN operator.

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

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

A WHERE clause can contain only one condition.

Business Intelligence (BI)systems typically store their data in data warehouses.

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

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

Exam 2: Introduction to Structured Query Language

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

Regarding the interchangeability of subqueries and joins,________.

Suppose your company stores EMPLOYEE and CUSTOMER data in separate tables.If you want to find all customers who are not also employees,which SQL keyword would you most likely use?

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

What are SQL Built-in Functions?

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

In addition to being a data sublanguage,SQL is also a programming language,like Java or C#.

Explain why it is important to learn SQL.

The condition in WHERE clauses can refer to a set of values by using the IN operator.

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

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

A WHERE clause can contain only one condition.

Business Intelligence (BI)systems typically store their data in data warehouses.

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

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