Question 1

There is a special operation in SQL to join a table to itself.

Accepted Answer

A) True 
 B)False

Question 2

MULTISET is similar to the table datatype.

Accepted Answer

A) True 
 B)False

Question 3

SQL:200n allows one to calculate linear regressions,moving averages and correlations without moving the data outside of the database.

Accepted Answer

A) True 
 B)False

Question 4

A join in which the joining condition is based on equality between values in the common columns is called a(n):

Accepted Answer

A)  equi-join. 
B)  uni-lateral join. 
C)  natural join. 
D)  both A and C. 
A)  equi-join. 
B)  uni-lateral join. 
C)  natural join. 
D)  both A and C.

Question 5

When is it better to use a subquery over using a join?

Accepted Answer

Often,a subquery and join will return th

Question 6

Establishing IF-THEN-ELSE logical processing within an SQL statement can now be accomplished by using the ________ keyword in a statement.

Accepted Answer

The answer of Establishing IF-THEN-ELSE logical processing within an SQL...

Question 7

Persistent stored modules are extensions defined in SQL:1999 that include the capability to add and drop modules of code.

Accepted Answer

A) True 
 B)False

Question 8

Explain how to combine queries using the UNION clause.

Accepted Answer

The union clause is used to combine the

Question 9

The UNION clause is used to combine the output from multiple queries into a single result table.

Accepted Answer

A) True 
 B)False

Question 10

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 11

All of the following are guidelines for better query design EXCEPT:

Accepted Answer

A)  Understand how indexes are used in query processing 
B)  Use a lot of self-joins 
C)  Write simple queries 
D)  Retrieve on the data that you need 
A)  Understand how indexes are used in query processing 
B)  Use a lot of self-joins 
C)  Write simple queries 
D)  Retrieve on the data that you need

Question 12

Explicit commands to manage transactions are needed when:

Accepted Answer

A)  a transaction consists of just one SQL command. 
B)  multiple SQL commands must be run as part of a transaction. 
C)  autocommit is set to off. 
D)  none of the above. 
A)  a transaction consists of just one SQL command. 
B)  multiple SQL commands must be run as part of a transaction. 
C)  autocommit is set to off. 
D)  none of the above.

Question 13

Constraints are a special case of triggers.

Accepted Answer

A) True 
 B)False

Question 14

A join that is based upon equality between values in two common columns with the same name and where one duplicate column has been removed is called a(n):

Accepted Answer

A)  equi-join. 
B)  natural join. 
C)  multivariate join. 
D)  inner join. 
A)  equi-join. 
B)  natural join. 
C)  multivariate join. 
D)  inner join.

Question 15

A function has only input parameters but can return multiple values.

Accepted Answer

A) True 
 B)False

Question 16

User-defined transactions can improve system performance because:

Accepted Answer

A)  transactions are processed as sets, reducing system overhead. 
B)  transactions are mapped to SQL statements. 
C)  speed is improved due to query optimization. 
D)  all of the above. 
A)  transactions are processed as sets, reducing system overhead. 
B)  transactions are mapped to SQL statements. 
C)  speed is improved due to query optimization. 
D)  all of the above.

Question 17

If the DBA wishes to describe all tables in the database,which data dictionary view should be accessed in Oracle?

Accepted Answer

A)  dba_tab_privs 
B)  dba_tab_comments 
C)  dba_table_label 
D)  dba_tables 
A)  dba_tab_privs 
B)  dba_tab_comments 
C)  dba_table_label 
D)  dba_tables

Question 18

A join in which the joining condition is based on equality between values in the common column is called a(n)________.

Accepted Answer

The answer of A join in which the joining condition...

Question 19

The ________ DBA view shows information about all users of the database in Oracle.

Accepted Answer

The answer of The ________ DBA view shows information about...

Question 20

Figuring out what attributes you want in your query before you write the query will help with query writing.

Accepted Answer

A) True 
 B)False

There is a special operation in SQL to join a table to itself.

MULTISET is similar to the table datatype.

SQL:200n allows one to calculate linear regressions,moving averages and correlations without moving the data outside of the database.

A join in which the joining condition is based on equality between values in the common columns is called a(n):

When is it better to use a subquery over using a join?

Establishing IF-THEN-ELSE logical processing within an SQL statement can now be accomplished by using the ________ keyword in a statement.

Persistent stored modules are extensions defined in SQL:1999 that include the capability to add and drop modules of code.

Explain how to combine queries using the UNION clause.

The UNION clause is used to combine the output from multiple queries into a single result table.

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

All of the following are guidelines for better query design EXCEPT:

Explicit commands to manage transactions are needed when:

Constraints are a special case of triggers.

A join that is based upon equality between values in two common columns with the same name and where one duplicate column has been removed is called a(n):

A function has only input parameters but can return multiple values.

User-defined transactions can improve system performance because:

If the DBA wishes to describe all tables in the database,which data dictionary view should be accessed in Oracle?

A join in which the joining condition is based on equality between values in the common column is called a(n)________.

The ________ DBA view shows information about all users of the database in Oracle.

Figuring out what attributes you want in your query before you write the query will help with query writing.

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

There is a special operation in SQL to join a table to itself.

MULTISET is similar to the table datatype.

SQL:200n allows one to calculate linear regressions,moving averages and correlations without moving the data outside of the database.

A join in which the joining condition is based on equality between values in the common columns is called a(n):

When is it better to use a subquery over using a join?

Establishing IF-THEN-ELSE logical processing within an SQL statement can now be accomplished by using the ________ keyword in a statement.

Persistent stored modules are extensions defined in SQL:1999 that include the capability to add and drop modules of code.

Explain how to combine queries using the UNION clause.

The UNION clause is used to combine the output from multiple queries into a single result table.

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

All of the following are guidelines for better query design EXCEPT:

Explicit commands to manage transactions are needed when:

Constraints are a special case of triggers.

A join that is based upon equality between values in two common columns with the same name and where one duplicate column has been removed is called a(n):

A function has only input parameters but can return multiple values.

User-defined transactions can improve system performance because:

If the DBA wishes to describe all tables in the database,which data dictionary view should be accessed in Oracle?

A join in which the joining condition is based on equality between values in the common column is called a(n)________.

The ________ DBA view shows information about all users of the database in Oracle.

Figuring out what attributes you want in your query before you write the query will help with query writing.

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