Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)  ternary join. 
B)  self-join. 
C)  unnatural join. 
D)  pinned join. 
A)  ternary join. 
B)  self-join. 
C)  unnatural join. 
D)  pinned join.

Question 3

An interactive command that can be used to dynamically control a user session for appropriate integrity measures is:

Accepted Answer

A)  rollback. 
B)  rollforward. 
C)  set autocommit. 
D)  expunge. 
A)  rollback. 
B)  rollforward. 
C)  set autocommit. 
D)  expunge.

Question 4

Discuss the differences between an equi-join, natural join and outer join.

Accepted Answer

Both a natural join and an equi-join cre

Question 5

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 6

A trigger is a named set of SQL statements that are considered when a data modification occurs.

Accepted Answer

A) True 
 B)False

Question 7

A join in which rows that do not have matching values in common columns are still included in the result table is called a(n):

Accepted Answer

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

Question 8

While triggers run automatically, ________ do not and have to be called.

Accepted Answer

A)  trapdoors 
B)  routines 
C)  selects 
D)  updates 
A)  trapdoors 
B)  routines 
C)  selects 
D)  updates

Question 9

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 10

DBA_USERS contains comments on all tables in an Oracle database.

Accepted Answer

A) True 
 B)False

Question 11

User-defined data types:

Accepted Answer

A)  are not allowed in any DBMS. 
B)  are only allowed in Oracle. 
C)  can have defined functions and methods. 
D)  can be used once in a system. 
A)  are not allowed in any DBMS. 
B)  are only allowed in Oracle. 
C)  can have defined functions and methods. 
D)  can be used once in a system.

Question 12

What can be done with Persistent Stored Modules?

Accepted Answer

Persistent Stored Modules allow one to c

Question 13

Triggers have three parts: the event, the condition, and the action.

Accepted Answer

A) True 
 B)False

Question 14

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)  both return exactly one row. 
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)  both return exactly one row.

Question 15

The following code is an example of a correlated subquery.
SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState,
CustomerPostalCode
FROM Customer_T
WHERE Customer_T.CustomerID =
(SELECT Order_T.CustomerID
FROM Order_T
WHERE OrderID = 1008);

Accepted Answer

A) True 
 B)False

Question 16

An SQL query that implements an outer join will return rows that do not have matching values in common columns.

Accepted Answer

A) True 
 B)False

Question 17

Combining a table with itself results in a faster query.

Accepted Answer

A) True 
 B)False

Question 18

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 19

A correlated subquery is executed once for each iteration through the outer loop.

Accepted Answer

A) True 
 B)False

Question 20

Specifying the attribute names in the SELECT statement will make it easier to find errors in queries and also correct for problems that may occur in the base system.

Accepted Answer

A) True 
 B)False

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

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

An interactive command that can be used to dynamically control a user session for appropriate integrity measures is:

Discuss the differences between an equi-join, natural join and outer join.

Embedded SQL consists of:

A trigger is a named set of SQL statements that are considered when a data modification occurs.

A join in which rows that do not have matching values in common columns are still included in the result table is called a(n):

While triggers run automatically, ________ do not and have to be called.

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.

DBA_USERS contains comments on all tables in an Oracle database.

User-defined data types:

What can be done with Persistent Stored Modules?

Triggers have three parts: the event, the condition, and the action.

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

The following code is an example of a correlated subquery. SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode FROM Customer_T WHERE Customer_T.CustomerID = (SELECT Order_T.CustomerID FROM Order_T WHERE OrderID = 1008);

An SQL query that implements an outer join will return rows that do not have matching values in common columns.

Combining a table with itself results in a faster query.

The most commonly used form of join operation is the:

A correlated subquery is executed once for each iteration through the outer loop.

Specifying the attribute names in the SELECT statement will make it easier to find errors in queries and also correct for problems that may occur in the base system.

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

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

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

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

An interactive command that can be used to dynamically control a user session for appropriate integrity measures is:

Discuss the differences between an equi-join, natural join and outer join.

Embedded SQL consists of:

A trigger is a named set of SQL statements that are considered when a data modification occurs.

A join in which rows that do not have matching values in common columns are still included in the result table is called a(n):

While triggers run automatically, ________ do not and have to be called.

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.

DBA_USERS contains comments on all tables in an Oracle database.

User-defined data types:

What can be done with Persistent Stored Modules?

Triggers have three parts: the event, the condition, and the action.

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

The following code is an example of a correlated subquery. SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode FROM Customer_T WHERE Customer_T.CustomerID = (SELECT Order_T.CustomerID FROM Order_T WHERE OrderID = 1008);

An SQL query that implements an outer join will return rows that do not have matching values in common columns.

Combining a table with itself results in a faster query.

The most commonly used form of join operation is the:

A correlated subquery is executed once for each iteration through the outer loop.

Specifying the attribute names in the SELECT statement will make it easier to find errors in queries and also correct for problems that may occur in the base system.

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

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