Question 1

What does the following SQL statement do?
Select * From Customer Where Cust_Type = "Best"

Accepted Answer

A)  Selects all the fields from the Customer table for each row with a customer labeled "best" 
B)  Selects the "*" field from the Customer table for each row with a customer labeled "best" 
C)  Selects fields with a "*" in them from the Customer table 
D)  Selects all the fields from the Customer table for each row with a customer labeled "*" 
A)  Selects all the fields from the Customer table for each row with a customer labeled "best" 
B)  Selects the "*" field from the Customer table for each row with a customer labeled "best" 
C)  Selects fields with a "*" in them from the Customer table 
D)  Selects all the fields from the Customer table for each row with a customer labeled "*"

Question 2

The ________ clause sorts the final results rows of a query in ascending or descending order.

Accepted Answer

The answer of The ________ clause sorts the final results...

Question 3

________ is a set of commands used to update and query a database.

Accepted Answer

A)  DML 
B)  DDL 
C)  DCL 
D)  DPL 
A)  DML 
B)  DDL 
C)  DCL 
D)  DPL

Question 4

The command for creating a database is:

Accepted Answer

A)  create table. 
B)  create view. 
C)  create schema. 
D)  create authorization. 
A)  create table. 
B)  create view. 
C)  create schema. 
D)  create authorization.

Question 5

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)  None of the above. 
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)  None of the above.

Question 6

The comparison operators = and != are used to establish a range of values.

Accepted Answer

A) True 
 B)False

Question 7

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 8

The SQL command ________ adds one or more new columns to a table.

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 9

A major benefit of SQL as a standard is reduced training costs.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Adding the keyword ________ to an SQL query will eliminate duplicate rows from the query result set.

Accepted Answer

The answer of Adding the keyword ________ to an SQL...

Question 12

The HAVING clause acts as a secondary ________ clause.

Accepted Answer

The answer of The HAVING clause acts as a secondary...

Question 13

The first in a series of steps to follow when creating a table is to:

Accepted Answer

A)  identify columns that must be unique. 
B)  identify each attribute and its characteristics. 
C)  create an index. 
D)  identify columns that must be null. 
A)  identify columns that must be unique. 
B)  identify each attribute and its characteristics. 
C)  create an index. 
D)  identify columns that must be null.

Question 14

________ is a constraint that specifies that the value of an attribute in one relation depends upon the value of a primary key in the same or other relation.

Accepted Answer

Referentia

Question 15

Discuss when to use the group by clause.

Accepted Answer

The group by clause is useful when you h

Question 16

Which of the following can produce scalar and vector aggregates?

Accepted Answer

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

Question 17

The ORDER BY clause is the first statement processed in an SQL command.

Accepted Answer

A) True 
 B)False

Question 18

Any create command may be reversed by using a ________ command.

Accepted Answer

A)  truncate 
B)  drop 
C)  delete 
D)  unpack 
A)  truncate 
B)  drop 
C)  delete 
D)  unpack

Question 19

Materialized views are stored on disk and are never refreshed.

Accepted Answer

A) True 
 B)False

Question 20

The ________ contains raw data.

Accepted Answer

The answer of The ________ contains raw data....

What does the following SQL statement do? Select * From Customer Where Cust_Type = "Best"

The ________ clause sorts the final results rows of a query in ascending or descending order.

________ is a set of commands used to update and query a database.

The command for creating a database is:

What will result from the following SQL Select statement? Select min(product_description) From product_v;

The comparison operators = and != are used to establish a range of values.

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

The SQL command ________ adds one or more new columns to a table.

A major benefit of SQL as a standard is reduced training costs.

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

Adding the keyword ________ to an SQL query will eliminate duplicate rows from the query result set.

The HAVING clause acts as a secondary ________ clause.

The first in a series of steps to follow when creating a table is to:

________ is a constraint that specifies that the value of an attribute in one relation depends upon the value of a primary key in the same or other relation.

Discuss when to use the group by clause.

Which of the following can produce scalar and vector aggregates?

The ORDER BY clause is the first statement processed in an SQL command.

Any create command may be reversed by using a ________ command.

Materialized views are stored on disk and are never refreshed.

The ________ contains raw data.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 6: Introduction to SQL

What does the following SQL statement do? Select * From Customer Where Cust_Type = "Best"

The ________ clause sorts the final results rows of a query in ascending or descending order.

________ is a set of commands used to update and query a database.

The command for creating a database is:

What will result from the following SQL Select statement? Select min(product_description) From product_v;

The comparison operators = and != are used to establish a range of values.

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

The SQL command ________ adds one or more new columns to a table.

A major benefit of SQL as a standard is reduced training costs.

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

Adding the keyword ________ to an SQL query will eliminate duplicate rows from the query result set.

The HAVING clause acts as a secondary ________ clause.

The first in a series of steps to follow when creating a table is to:

________ is a constraint that specifies that the value of an attribute in one relation depends upon the value of a primary key in the same or other relation.

Discuss when to use the group by clause.

Which of the following can produce scalar and vector aggregates?

The ORDER BY clause is the first statement processed in an SQL command.

Any create command may be reversed by using a ________ command.

Materialized views are stored on disk and are never refreshed.

The ________ contains raw data.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters