Question 1

The most commonly used form of join operation is the:

Accepted Answer

A)  outer join. 
B)  union join. 
C)  equi-join. 
D)  natural join. 
A)  outer join. 
B)  union join. 
C)  equi-join. 
D)  natural join.

Question 2

________ and ________ are very powerful database objects because they are stored in the database and controlled by the DBMS.

Accepted Answer

The answer of ________ and ________ are very powerful database...

Question 3

EXISTS takes a value of false if the subquery returns an intermediate result set.

Accepted Answer

A) True 
 B)False

Question 4

Transaction integrity commands are not used to identify whole units of database changes that must be completed in full for the database to retain integrity.

Accepted Answer

A) True 
 B)False

Question 5

Triggers can be used to ensure referential integrity,enforce business rules,create audit trails,replicate tables,but cannot call other triggers.

Accepted Answer

A) True 
 B)False

Question 6

Subqueries can only be used in the WHERE clause.

Accepted Answer

A) True 
 B)False

Question 7

A procedure is run by calling it by its name.

Accepted Answer

A) True 
 B)False

Question 8

When EXISTS or NOT EXISTS is used in a subquery,the select list of the subquery will usually just select all columns as a placeholder because it doesn't matter which columns are returned.

Accepted Answer

A) True 
 B)False

Question 9

In order for two queries to be UNION-compatible,they must:

Accepted Answer

A)  both have the same number of lines in their SQL statements. 
B)  both output compatible data types for each column and return the same number of rows. 
C)  both return at least one row. 
D)  all of the above. 
A)  both have the same number of lines in their SQL statements. 
B)  both output compatible data types for each column and return the same number of rows. 
C)  both return at least one row. 
D)  all of the above.

Question 10

Dynamic SQL:

Accepted Answer

A)  is used to generate appropriate SQL code on the fly, as an application is processing. 
B)  is quite volatile. 
C)  is not used widely on the Internet. 
D)  creates a less flexible application. 
A)  is used to generate appropriate SQL code on the fly, as an application is processing. 
B)  is quite volatile. 
C)  is not used widely on the Internet. 
D)  creates a less flexible application.

Question 11

A new set of analytical functions added in SQL:200n are referred to as:

Accepted Answer

A)  OLAF Functions. 
B)  MOLAP Functions. 
C)  Average Functions. 
D)  OLAP Functions. 
A)  OLAF Functions. 
B)  MOLAP Functions. 
C)  Average Functions. 
D)  OLAP Functions.

Question 12

RANK and DENSE-RANK are examples of:

Accepted Answer

A)  Ceilings. 
B)  Door Functions. 
C)  Window Functions. 
D)  Moving Functions. 
A)  Ceilings. 
B)  Door Functions. 
C)  Window Functions. 
D)  Moving Functions.

Question 13

Extensions defined in SQL-99 that include the capability to create and drop modules of code stored in the database schema across user sessions are called:

Accepted Answer

A)  stored procedures. 
B)  Persistent Stored Modules. 
C)  flow control modules. 
D)  none of the above. 
A)  stored procedures. 
B)  Persistent Stored Modules. 
C)  flow control modules. 
D)  none of the above.

Question 14

________ differs from array because it can contain duplicates.

Accepted Answer

A)  BIGINT 
B)  XML 
C)  MULTISET 
D)  TABLE 
A)  BIGINT 
B)  XML 
C)  MULTISET 
D)  TABLE

Question 15

The three parts of triggers are the event,condition,and ________.

Accepted Answer

The answer of The three parts of triggers are the...

Question 16

A transaction is the complete set of closely related update commands that must all be done,or none of them done,for the database to remain valid.

Accepted Answer

A) True 
 B)False

Question 17

Embedded SQL consists of:

Accepted Answer

A)  hard-coded SQL statements included in a program written in another language. 
B)  SQL encapsulated inside of other SQL statements. 
C)  SQL written into a front-end application. 
D)  SQL translated to a lower-level language. 
A)  hard-coded SQL statements included in a program written in another language. 
B)  SQL encapsulated inside of other SQL statements. 
C)  SQL written into a front-end application. 
D)  SQL translated to a lower-level language.

Question 18

All of the following are new data types added in SQL:200n EXCEPT:

Accepted Answer

A)  BIGINT 
B)  BIT 
C)  MULTISET 
D)  XML 
A)  BIGINT 
B)  BIT 
C)  MULTISET 
D)  XML

Question 19

DBA_USERS contains comments on all tables in an Oracle database.

Accepted Answer

A) True 
 B)False

Question 20

A type of join where a table is joined to itself is called a(n)________.

Accepted Answer

A)  unary join 
B)  self join 
C)  unnatural join 
D)  pinned join 
A)  unary join 
B)  self join 
C)  unnatural join 
D)  pinned join

The most commonly used form of join operation is the:

and are very powerful database objects because they are stored in the database and controlled by the DBMS.

EXISTS takes a value of false if the subquery returns an intermediate result set.

Transaction integrity commands are not used to identify whole units of database changes that must be completed in full for the database to retain integrity.

Triggers can be used to ensure referential integrity,enforce business rules,create audit trails,replicate tables,but cannot call other triggers.

Subqueries can only be used in the WHERE clause.

A procedure is run by calling it by its name.

When EXISTS or NOT EXISTS is used in a subquery,the select list of the subquery will usually just select all columns as a placeholder because it doesn't matter which columns are returned.

In order for two queries to be UNION-compatible,they must:

Dynamic SQL:

A new set of analytical functions added in SQL:200n are referred to as:

RANK and DENSE-RANK are examples of:

Extensions defined in SQL-99 that include the capability to create and drop modules of code stored in the database schema across user sessions are called:

________ differs from array because it can contain duplicates.

The three parts of triggers are the event,condition,and ________.

A transaction is the complete set of closely related update commands that must all be done,or none of them done,for the database to remain valid.

Embedded SQL consists of:

All of the following are new data types added in SQL:200n EXCEPT:

DBA_USERS contains comments on all tables in an Oracle database.

A type of join where a table is joined to itself is called a(n)________.

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

Introduction to 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 7: Advanced SQL

The most commonly used form of join operation is the:

________ and ________ are very powerful database objects because they are stored in the database and controlled by the DBMS.

EXISTS takes a value of false if the subquery returns an intermediate result set.

Transaction integrity commands are not used to identify whole units of database changes that must be completed in full for the database to retain integrity.

Triggers can be used to ensure referential integrity,enforce business rules,create audit trails,replicate tables,but cannot call other triggers.

Subqueries can only be used in the WHERE clause.

A procedure is run by calling it by its name.

When EXISTS or NOT EXISTS is used in a subquery,the select list of the subquery will usually just select all columns as a placeholder because it doesn't matter which columns are returned.

In order for two queries to be UNION-compatible,they must:

Dynamic SQL:

A new set of analytical functions added in SQL:200n are referred to as:

RANK and DENSE-RANK are examples of:

Extensions defined in SQL-99 that include the capability to create and drop modules of code stored in the database schema across user sessions are called:

________ differs from array because it can contain duplicates.

The three parts of triggers are the event,condition,and ________.

A transaction is the complete set of closely related update commands that must all be done,or none of them done,for the database to remain valid.

Embedded SQL consists of:

All of the following are new data types added in SQL:200n EXCEPT:

DBA_USERS contains comments on all tables in an Oracle database.

A type of join where a table is joined to itself is called a(n)________.

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

Introduction to 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

and are very powerful database objects because they are stored in the database and controlled by the DBMS.