Question 1

One major disadvantage of the outer join is that information is easily lost.

Accepted Answer

A) True 
 B)False

Question 2

An equi-join is a join in which one of the duplicate columns is eliminated in the result table.

Accepted Answer

A) True 
 B)False

Question 3

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 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)  unilateral join. 
C)  natural join. 
D)  both A and C. 
A)  equi-join. 
B)  unilateral join. 
C)  natural join. 
D)  both A and C.

Question 5

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 6

A materialized view is not persistent.

Accepted Answer

A) True 
 B)False

Question 7

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 only 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 only the data that you need.

Question 8

A dynamic query is created by the user.

Accepted Answer

A) True 
 B)False

Question 9

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

Question 10

A ________ is a temporary table used in the FROM clause of an SQL query.

Accepted Answer

A)  correlated subquery 
B)  derived table 
C)  view table 
D)  trigger 
A)  correlated subquery 
B)  derived table 
C)  view table 
D)  trigger

Question 11

The MERGE command:

Accepted Answer

A)  allows one to combine the INSERT and UPDATE operations. 
B)  allows one to combine the INSERT and DELETE operations. 
C)  joins 2 tables together. 
D)  is always a single table operation. 
A)  allows one to combine the INSERT and UPDATE operations. 
B)  allows one to combine the INSERT and DELETE operations. 
C)  joins 2 tables together. 
D)  is always a single table operation.

Question 12

A new set of analytical functions added in SQL:2008 is 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 13

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 14

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 15

Explain how to combine queries using the UNION clause.

Accepted Answer

The UNION clause is used to combine the

Question 16

A join operation:

Accepted Answer

A)  brings together data from two different fields. 
B)  causes two tables with a common domain to be combined into a single table or view. 
C)  causes two disparate tables to be combined into a single table or view. 
D)  is used to combine indexing operations. 
A)  brings together data from two different fields. 
B)  causes two tables with a common domain to be combined into a single table or view. 
C)  causes two disparate tables to be combined into a single table or view. 
D)  is used to combine indexing operations.

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

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

Accepted Answer

A) True 
 B)False

Question 19

________ use the result of the inner query to determine the processing of the outer query.

Accepted Answer

A)  Correlated subqueries 
B)  Outer subqueries 
C)  Inner subqueries 
D)  Subqueries 
A)  Correlated subqueries 
B)  Outer subqueries 
C)  Inner subqueries 
D)  Subqueries

Question 20

A join in which the joining condition is based on equality between values in the common column is called an equi-join.

Accepted Answer

A) True 
 B)False

One major disadvantage of the outer join is that information is easily lost.

An equi-join is a join in which one of the duplicate columns is eliminated in the result table.

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.

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

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 materialized view is not persistent.

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

A dynamic query is created by the user.

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

A ________ is a temporary table used in the FROM clause of an SQL query.

The MERGE command:

A new set of analytical functions added in SQL:2008 is referred to as:

The most commonly used form of join operation is the:

User-defined data types:

Explain how to combine queries using the UNION clause.

A join operation:

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

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

________ use the result of the inner query to determine the processing of the outer query.

A join in which the joining condition is based on equality between values in the common column is called an equi-join.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 6: Advanced SQL

One major disadvantage of the outer join is that information is easily lost.

An equi-join is a join in which one of the duplicate columns is eliminated in the result table.

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.

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

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 materialized view is not persistent.

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

A dynamic query is created by the user.

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

A ________ is a temporary table used in the FROM clause of an SQL query.

The MERGE command:

A new set of analytical functions added in SQL:2008 is referred to as:

The most commonly used form of join operation is the:

User-defined data types:

Explain how to combine queries using the UNION clause.

A join operation:

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

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

________ use the result of the inner query to determine the processing of the outer query.

A join in which the joining condition is based on equality between values in the common column is called an equi-join.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters