Exam 8: Advanced SQL

Assume you are using the MINUS 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 MINUS operator?

(Multiple Choice)

4.8/5

(82)

Question 21

A persistent stored module is stored and executed on the database client machine.

(True/False)

4.9/5

(86)

Question 22

If a designer wishes to create an inner join,but the two tables do not have a commonly named attribute,he can use a(n)_____ clause.

(Multiple Choice)

4.8/5

(83)

Question 23

A relational join operation merges rows from two tables.

(True/False)

4.7/5

(87)

Question 24

The statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

(Multiple Choice)

4.8/5

(86)

Question 25

"Unioncompatible" means that the .

(Multiple Choice)

4.9/5

(78)

Question 26

The data type is considered compatible with VARCHAR(35).

(Multiple Choice)

4.9/5

(76)

Question 27

How are triggers critical to proper database operation and management?

(Essay)

4.9/5

(91)

Question 28

A view is a virtual table based on a SELECT query.

(True/False)

5.0/5

(85)

Question 29

The Oracle equivalent to an MS Access AutoNumber is a(n).

(Multiple Choice)

4.8/5

(77)

Question 30

The SELECT statement uses the attribute list to indicate what columns to project in the resulting set.

(True/False)

4.9/5

(85)

Question 31

A row-level trigger is assumed if we omit the FOR EACH ROW keywords and a statement-level trigger required the use of the FOR EACH ROW keyword.

(True/False)

4.9/5

(82)

Question 32

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

(Essay)

4.9/5

(76)

Question 33

A row-level trigger requires use of the keywords and is executed once for each row affected by the triggering statement.

(Short Answer)

4.8/5

(80)

Question 34

Describe the important features and applications of SQL functions

(Essay)

4.8/5

(74)

Question 35

The use of the operator allows you to compare a single value with a list of values returned by the first subquery (sqA)using a comparison operator other than EQUALS.

(Short Answer)

4.9/5

(72)

Question 36

A(n)subquery is a subquery that executes once for each row in the outer query.

(Short Answer)

5.0/5

(69)

Question 37

Triggers can only be used to update table values.

(True/False)

4.8/5

(87)

Question 38

String manipulation functions are rarely used in programming.

(True/False)

4.9/5

(89)

Question 39

A(n)join returns not only the rows matching the join condition (that is,rows with matching values in the common columns)but also the rows with unmatched values.

(Multiple Choice)

4.9/5

(74)

Question 40

Showing 21 - 40 of 95

A persistent stored module is stored and executed on the database client machine.

If a designer wishes to create an inner join,but the two tables do not have a commonly named attribute,he can use a(n)_____ clause.

A relational join operation merges rows from two tables.

The statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

"Unioncompatible" means that the .

The data type is considered compatible with VARCHAR(35).

How are triggers critical to proper database operation and management?

A view is a virtual table based on a SELECT query.

The Oracle equivalent to an MS Access AutoNumber is a(n).

The SELECT statement uses the attribute list to indicate what columns to project in the resulting set.

A row-level trigger is assumed if we omit the FOR EACH ROW keywords and a statement-level trigger required the use of the FOR EACH ROW keyword.

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

A row-level trigger requires use of the keywords and is executed once for each row affected by the triggering statement.

Describe the important features and applications of SQL functions

The use of the operator allows you to compare a single value with a list of values returned by the first subquery (sqA)using a comparison operator other than EQUALS.

A(n)subquery is a subquery that executes once for each row in the outer query.

Triggers can only be used to update table values.

String manipulation functions are rarely used in programming.

A(n)join returns not only the rows matching the join condition (that is,rows with matching values in the common columns)but also the rows with unmatched values.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Ermodeling

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

Big Data Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 8: Advanced SQL

A persistent stored module is stored and executed on the database client machine.

If a designer wishes to create an inner join,but the two tables do not have a commonly named attribute,he can use a(n)_____ clause.

A relational join operation merges rows from two tables.

The statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

"Union­compatible" means that the .

The data type is considered compatible with VARCHAR(35).

How are triggers critical to proper database operation and management?

A view is a virtual table based on a SELECT query.

The Oracle equivalent to an MS Access AutoNumber is a(n).

The SELECT statement uses the attribute list to indicate what columns to project in the resulting set.

A row-level trigger is assumed if we omit the FOR EACH ROW keywords and a statement-level trigger required the use of the FOR EACH ROW keyword.

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

A row-level trigger requires use of the keywords and is executed once for each row affected by the triggering statement.

Describe the important features and applications of SQL functions

The use of the operator allows you to compare a single value with a list of values returned by the first subquery (sqA)using a comparison operator other than EQUALS.

A(n)subquery is a subquery that executes once for each row in the outer query.

Triggers can only be used to update table values.

String manipulation functions are rarely used in programming.

A(n)join returns not only the rows matching the join condition (that is,rows with matching values in the common columns)but also the rows with unmatched values.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Ermodeling

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

Big Data Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters

"Unioncompatible" means that the .