Question 1

What will result from the following SQL Select statement? Select min(Product_Description)
From Product_V;

Accepted Answer

A)  The minimum value of Product_Description will be displayed. 
B)  An error message will be generated. 
C)  The first product description alphabetically in Product_V will be shown. 
D)  SELECT @ will be displayed. 
A)  The minimum value of Product_Description will be displayed. 
B)  An error message will be generated. 
C)  The first product description alphabetically in Product_V will be shown. 
D)  SELECT @ will be displayed. C

Question 2

SQL has been implemented only in the mainframe and midrange environments.

Accepted Answer

A) True 
 B)False  False

Question 3

What result set will the following query return? Select Item_No, description
From item
Where weight > 100 and weight < 200;

Accepted Answer

A)  The Item_No and description for all items weighing less than 100 
B)  The Item_No for all items weighing between 101 and 199 
C)  The Item_No and description for all items weighing between 101 and 199 
D)  The Item_No for all items weighing more than 200 
A)  The Item_No and description for all items weighing less than 100 
B)  The Item_No for all items weighing between 101 and 199 
C)  The Item_No and description for all items weighing between 101 and 199 
D)  The Item_No for all items weighing more than 200 C

Question 4

How is the HAVING clause different from the WHERE clause?

Accepted Answer

While the WHERE clause works on each row

Question 5

A database is maintained and queried using the data mapping language (DML).

Accepted Answer

A) True 
 B)False

Question 6

Which of the following finds all groups meeting stated conditions?

Accepted Answer

A)  Select 
B)  Where 
C)  Having 
D)  Find 
A)  Select 
B)  Where 
C)  Having 
D)  Find

Question 7

What does the following SQL statement do? Update Product_T
Set Unit_Price = 775
Where Product_ID = 7

Accepted Answer

A)  Changes the price of a unit called Product_T to 7 
B)  Changes the unit price of Product 7 to 775 
C)  Changes the length of the Unit_Price field to 775 
D)  Updates the Product_T table to have a unit price of 775 
A)  Changes the price of a unit called Product_T to 7 
B)  Changes the unit price of Product 7 to 775 
C)  Changes the length of the Unit_Price field to 775 
D)  Updates the Product_T table to have a unit price of 775

Question 8

Implementation of a standard can never stifle creativity and innovation.

Accepted Answer

A) True 
 B)False

Question 9

What are some of the standard SQL functions that can be used in the SELECT clause?

Accepted Answer

The standard functions can be broken dow

Question 10

In order to update data in SQL, one must inform the DBMS which relation, columns, and rows are involved.

Accepted Answer

A) True 
 B)False

Question 11

The ________ is the structure that contains descriptions of objects such as tables and views created by users.

Accepted Answer

A)  SQL 
B)  schema 
C)  catalog 
D)  master view 
A)  SQL 
B)  schema 
C)  catalog 
D)  master view

Question 12

The SQL command ________ defines a logical table from one or more tables or views.

Accepted Answer

A)  create table 
B)  alter table 
C)  create view 
D)  create relationship 
A)  create table 
B)  alter table 
C)  create view 
D)  create relationship

Question 13

One of the original purposes of the SQL standard was to provide a vehicle for portability of database definition and application modules between conforming DBMSs.

Accepted Answer

A) True 
 B)False

Question 14

A database table is defined using the data definition language (DDL).

Accepted Answer

A) True 
 B)False

Question 15

A catalog is the structure that contains object descriptions created by a user.

Accepted Answer

A) True 
 B)False

Question 16

The main concept of relational databases was published in 1970 by:

Accepted Answer

A)  Itzak Ben-Gan. 
B)  Hoffer. 
C)  Mills. 
D)  E.F.Codd. 
A)  Itzak Ben-Gan. 
B)  Hoffer. 
C)  Mills. 
D)  E.F.Codd.

Question 17

To get all the customers from Hawaii sorted together, which of the following would be used?

Accepted Answer

A)  Order By 
B)  Group By 
C)  Having 
D)  Sort 
A)  Order By 
B)  Group By 
C)  Having 
D)  Sort

Question 18

The benefits of a standardized relational language include:

Accepted Answer

A)  application turnover. 
B)  increased training costs. 
C)  cross-system communication. 
D)  confusing the SQL programmers. 
A)  application turnover. 
B)  increased training costs. 
C)  cross-system communication. 
D)  confusing the SQL programmers.

Question 19

What result will the following SQL statement produce? Select Avg(standard_price) as average from Product_V;

Accepted Answer

A)  The average of all products in Product_V 
B)  The average Standard_Price of all products in Product_V 
C)  The average price of all products 
D)  The mode of all prices 
A)  The average of all products in Product_V 
B)  The average Standard_Price of all products in Product_V 
C)  The average price of all products 
D)  The mode of all prices

Question 20

A single value returned from an SQL query that includes an aggregate function is called a vector aggregate.

Accepted Answer

A) True 
 B)False

What will result from the following SQL Select statement? Select min(Product_Description) From Product_V;

SQL has been implemented only in the mainframe and midrange environments.

What result set will the following query return? Select Item_No, description From item Where weight > 100 and weight < 200;

How is the HAVING clause different from the WHERE clause?

A database is maintained and queried using the data mapping language (DML).

Which of the following finds all groups meeting stated conditions?

What does the following SQL statement do? Update Product_T Set Unit_Price = 775 Where Product_ID = 7

Implementation of a standard can never stifle creativity and innovation.

What are some of the standard SQL functions that can be used in the SELECT clause?

In order to update data in SQL, one must inform the DBMS which relation, columns, and rows are involved.

The ________ is the structure that contains descriptions of objects such as tables and views created by users.

The SQL command ________ defines a logical table from one or more tables or views.

One of the original purposes of the SQL standard was to provide a vehicle for portability of database definition and application modules between conforming DBMSs.

A database table is defined using the data definition language (DDL).

A catalog is the structure that contains object descriptions created by a user.

The main concept of relational databases was published in 1970 by:

To get all the customers from Hawaii sorted together, which of the following would be used?

The benefits of a standardized relational language include:

What result will the following SQL statement produce? Select Avg(standard_price) as average from Product_V;

A single value returned from an SQL query that includes an aggregate function is called a vector aggregate.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 6: Introduction to SQL

What will result from the following SQL Select statement? Select min(Product_Description) From Product_V;

SQL has been implemented only in the mainframe and midrange environments.

What result set will the following query return? Select Item_No, description From item Where weight > 100 and weight < 200;

How is the HAVING clause different from the WHERE clause?

A database is maintained and queried using the data mapping language (DML).

Which of the following finds all groups meeting stated conditions?

What does the following SQL statement do? Update Product_T Set Unit_Price = 775 Where Product_ID = 7

Implementation of a standard can never stifle creativity and innovation.

What are some of the standard SQL functions that can be used in the SELECT clause?

In order to update data in SQL, one must inform the DBMS which relation, columns, and rows are involved.

The ________ is the structure that contains descriptions of objects such as tables and views created by users.

The SQL command ________ defines a logical table from one or more tables or views.

One of the original purposes of the SQL standard was to provide a vehicle for portability of database definition and application modules between conforming DBMSs.

A database table is defined using the data definition language (DDL).

A catalog is the structure that contains object descriptions created by a user.

The main concept of relational databases was published in 1970 by:

To get all the customers from Hawaii sorted together, which of the following would be used?

The benefits of a standardized relational language include:

What result will the following SQL statement produce? Select Avg(standard_price) as average from Product_V;

A single value returned from an SQL query that includes an aggregate function is called a vector aggregate.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters