Question 1

The ON UPDATE ________ option allows changes to a parent table to pass onto a child table or tables.

Accepted Answer

The answer of The ON UPDATE ________ option allows changes...

Question 2

The ________ command enables one to change table definitions.

Accepted Answer

The answer of The ________ command enables one to change...

Question 3

SQL is both an American and international standard for database access.

Accepted Answer

A) True 
 B)False

Question 4

The CREATE SCHEMA DDL command is used to create a table.

Accepted Answer

A) True 
 B)False

Question 5

Expressions are mathematical manipulations of data in a table that may be included as part of the SELECT statement.

Accepted Answer

A) True 
 B)False

Question 6

In SQL the ________ and ________ clauses are required,while the ________ clause is needed when only certain rows are to be retrieved or multiple tables are to be joined.

Accepted Answer

The answer of In SQL the ________ and ________ clauses...

Question 7

Which of the following is a technique for optimizing the internal performance of the relational data model?

Accepted Answer

A)  Avoiding indexes on secondary keys 
B)  Clustering data 
C)  Not reporting statistics to save machine resources 
D)  Using random index organizations 
A)  Avoiding indexes on secondary keys 
B)  Clustering data 
C)  Not reporting statistics to save machine resources 
D)  Using random index organizations

Question 8

The asterisk (*)wildcard designator can be used to select all fields from a table,as well as in WHERE clauses when an exact match is not possible.

Accepted Answer

A) True 
 B)False

Question 9

A DBMS that manages data as a collection of tables in which all data relationships are represented by common values in related tables is called a(n)________ DBMS.

Accepted Answer

The answer of A DBMS that manages data as a...

Question 10

In an SQL statement,which of the following parts states the conditions for row selection?

Accepted Answer

A)  Select 
B)  From 
C)  Where 
D)  Group By 
A)  Select 
B)  From 
C)  Where 
D)  Group By

Question 11

The ________ Boolean operator joins two or more conditions and returns results only when all conditions are true.

Accepted Answer

The answer of The ________ Boolean operator joins two or...

Question 12

Indexes generally slow down access speed in most RDMS.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following will produce the minimum of all standard prices?

Accepted Answer

A)  Select standard_price from product_v where standard_price = min; 
B)  Select min(standard_price) from product_v; 
C)  Select standard_price from min(product_v); 
D)  Select min(standard_price) from product_v where standard_price = min(standard_price); 
A)  Select standard_price from product_v where standard_price = min; 
B)  Select min(standard_price) from product_v; 
C)  Select standard_price from min(product_v); 
D)  Select min(standard_price) from product_v where standard_price = min(standard_price);

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

A ________ is a virtual table that is created dynamically upon request to a user.

Accepted Answer

The answer of A ________ is a virtual table that...

Question 16

Which of the following questions is answered by the SQL statement?
Select Count (Product_Description)from Product_T;

Accepted Answer

A)  How many products are in the Product Table? 
B)  How many products have product descriptions in the Product Table? 
C)  How many characters are in the field name "Product_Description"? 
D)  How many different columns named "product Description" are there in table Product_T? 
A)  How many products are in the Product Table? 
B)  How many products have product descriptions in the Product Table? 
C)  How many characters are in the field name "Product_Description"? 
D)  How many different columns named "product Description" are there in table Product_T?

Question 17

To update data in SQL we must inform the DBMS what ________,________,and ________ are involved.

Accepted Answer

relation,c

Question 18

Commands used to control a database are part of the ________ or ________.

Accepted Answer

data contr

Question 19

How is the having clause different from the where clause?

Accepted Answer

While the where clause works on each row

Question 20

The views are created by executing a CREATE VIEW SQL command.

Accepted Answer

A) True 
 B)False

The ON UPDATE ________ option allows changes to a parent table to pass onto a child table or tables.

The ________ command enables one to change table definitions.

SQL is both an American and international standard for database access.

The CREATE SCHEMA DDL command is used to create a table.

Expressions are mathematical manipulations of data in a table that may be included as part of the SELECT statement.

In SQL the and clauses are required,while the clause is needed when only certain rows are to be retrieved or multiple tables are to be joined.

Which of the following is a technique for optimizing the internal performance of the relational data model?

The asterisk (*)wildcard designator can be used to select all fields from a table,as well as in WHERE clauses when an exact match is not possible.

A DBMS that manages data as a collection of tables in which all data relationships are represented by common values in related tables is called a(n)________ DBMS.

In an SQL statement,which of the following parts states the conditions for row selection?

The ________ Boolean operator joins two or more conditions and returns results only when all conditions are true.

Indexes generally slow down access speed in most RDMS.

Which of the following will produce the minimum of all standard prices?

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

A ________ is a virtual table that is created dynamically upon request to a user.

Which of the following questions is answered by the SQL statement? Select Count (Product_Description)from Product_T;

To update data in SQL we must inform the DBMS what ,,and are involved.

Commands used to control a database are part of the or .

How is the having clause different from the where clause?

The views are created by executing a CREATE VIEW SQL command.

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

The ON UPDATE ________ option allows changes to a parent table to pass onto a child table or tables.

The ________ command enables one to change table definitions.

SQL is both an American and international standard for database access.

The CREATE SCHEMA DDL command is used to create a table.

Expressions are mathematical manipulations of data in a table that may be included as part of the SELECT statement.

In SQL the ________ and ________ clauses are required,while the ________ clause is needed when only certain rows are to be retrieved or multiple tables are to be joined.

Which of the following is a technique for optimizing the internal performance of the relational data model?

The asterisk (*)wildcard designator can be used to select all fields from a table,as well as in WHERE clauses when an exact match is not possible.

A DBMS that manages data as a collection of tables in which all data relationships are represented by common values in related tables is called a(n)________ DBMS.

In an SQL statement,which of the following parts states the conditions for row selection?

The ________ Boolean operator joins two or more conditions and returns results only when all conditions are true.

Indexes generally slow down access speed in most RDMS.

Which of the following will produce the minimum of all standard prices?

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

A ________ is a virtual table that is created dynamically upon request to a user.

Which of the following questions is answered by the SQL statement? Select Count (Product_Description)from Product_T;

To update data in SQL we must inform the DBMS what ________,________,and ________ are involved.

Commands used to control a database are part of the ________ or ________.

How is the having clause different from the where clause?

The views are created by executing a CREATE VIEW SQL command.

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

In SQL the and clauses are required,while the clause is needed when only certain rows are to be retrieved or multiple tables are to be joined.

To update data in SQL we must inform the DBMS what ,,and are involved.

Commands used to control a database are part of the or .