Question 1

If the DBMS does not support the INTERSECT statement, one can use a(n) subquery to achieve the same result.

Accepted Answer

The answer of If the DBMS does not support the...

Question 2

Stored procedures must have at least one argument.

Accepted Answer

A) True 
 B)False

Question 3

A relational join operation merges rows from two tables.

Accepted Answer

A) True 
 B)False

Question 4

How are triggers critical to proper database operation and management?

Accepted Answer

- Triggers can be used to enforce constr

Question 5

The statement combines rows from two queries and excludes duplicates.

Accepted Answer

A)  UNION 
B)  UNION ALL 
C)  INTERSECT 
D)  MINUS 
A)  UNION 
B)  UNION ALL 
C)  INTERSECT 
D)  MINUS

Question 6

The syntax of the DECODE function starts with .

Accepted Answer

The answer of The syntax of the DECODE function starts...

Question 7

When using the Oracle TO_DATE function, the code represents a three-letter month name.

Accepted Answer

A)  MON 
B)  MM3 
C)  MONTH 
D)  MM 
A)  MON 
B)  MM3 
C)  MONTH 
D)  MM

Question 8

The most useful feature of PL/SQL blocks is that they let a designer create code that can be named, stored, and executed by the DBMS.

Accepted Answer

A) True 
 B)False

Question 9

When using a(n) join, only rows that meet the given criteria are returned.

Accepted Answer

A)  full 
B)  inner 
C)  outer 
D)  set 
A)  full 
B)  inner 
C)  outer 
D)  set

Question 10

In MS Access, a designer can use the data type to define a column in his table that will be automatically populated with unique numeric values.

Accepted Answer

The answer of In MS Access, a designer can use...

Question 11

All join conditions are connected through a(n) logical operator.

Accepted Answer

A)  NOR 
B)  OR 
C)  AND 
D)  NOT 
A)  NOR 
B)  OR 
C)  AND 
D)  NOT

Question 12

In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

Accepted Answer

A) True 
 B)False

Question 13

"Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL, C++, ASP, Java, or ColdFusion.

Accepted Answer

A) True 
 B)False

Question 14

Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.

Accepted Answer

A) True 
 B)False

Question 15

is a relational set operator.

Accepted Answer

A)  MINUS 
B)  PLUS 
C)  ALL 
D)  EXISTS 
A)  MINUS 
B)  PLUS 
C)  ALL 
D)  EXISTS

Question 16

When using the Oracle TO_NUMBER function to convert a character string into a number, represents a digit.

Accepted Answer

A)  0 
B)  9 
C)  $ 
D)  # 
A)  0 
B)  9 
C)  $ 
D)  #

Question 17

Summarize the hierarchy of steps involved in creating and running an executable program with embedded SQL statements.

Accepted Answer

While the steps required to create and e

Question 18

Assume you are using the UNION ALL operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION ALL operator?

Accepted Answer

A)  7 
B)  10 
C)  15 
D)  17 
A)  7 
B)  10 
C)  15 
D)  17

Question 19

A(n) view is a view that can be used to update attributes in the base table(s) that are used in the view.

Accepted Answer

The answer of A(n) view is a view that can...

Question 20

A statement-level trigger is assumed if a designer omits the FOR EACH ROW keywords.

Accepted Answer

A) True 
 B)False

If the DBMS does not support the INTERSECT statement, one can use a(n) subquery to achieve the same result.

Stored procedures must have at least one argument.

A relational join operation merges rows from two tables.

How are triggers critical to proper database operation and management?

The statement combines rows from two queries and excludes duplicates.

The syntax of the DECODE function starts with .

When using the Oracle TO_DATE function, the code represents a three-letter month name.

The most useful feature of PL/SQL blocks is that they let a designer create code that can be named, stored, and executed by the DBMS.

When using a(n) join, only rows that meet the given criteria are returned.

In MS Access, a designer can use the data type to define a column in his table that will be automatically populated with unique numeric values.

All join conditions are connected through a(n) logical operator.

In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

"Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL, C++, ASP, Java, or ColdFusion.

Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.

is a relational set operator.

When using the Oracle TO_NUMBER function to convert a character string into a number, represents a digit.

Summarize the hierarchy of steps involved in creating and running an executable program with embedded SQL statements.

A(n) view is a view that can be used to update attributes in the base table(s) that are used in the view.

A statement-level trigger is assumed if a designer omits the FOR EACH ROW keywords.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 8: Advanced Sql

If the DBMS does not support the INTERSECT statement, one can use a(n) subquery to achieve the same result.

Stored procedures must have at least one argument.

A relational join operation merges rows from two tables.

How are triggers critical to proper database operation and management?

The statement combines rows from two queries and excludes duplicates.

The syntax of the DECODE function starts with .

When using the Oracle TO_DATE function, the code represents a three-letter month name.

The most useful feature of PL/SQL blocks is that they let a designer create code that can be named, stored, and executed by the DBMS.

When using a(n) join, only rows that meet the given criteria are returned.

In MS Access, a designer can use the data type to define a column in his table that will be automatically populated with unique numeric values.

All join conditions are connected through a(n) logical operator.

In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

"Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL, C++, ASP, Java, or ColdFusion.

Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.

is a relational set operator.

When using the Oracle TO_NUMBER function to convert a character string into a number, represents a digit.

Summarize the hierarchy of steps involved in creating and running an executable program with embedded SQL statements.

A(n) view is a view that can be used to update attributes in the base table(s) that are used in the view.

A statement-level trigger is assumed if a designer omits the FOR EACH ROW keywords.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters