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.

A) is used to generate appropriate SQL code on the fly as an application is processing. B) is quite volatile. C) is not used widely on the Internet. D) creates a less flexible application. A) is used to generate appropriate SQL code on the fly as an application is processing. B) is quite volatile. C) is not used widely on the Internet. D) creates a less flexible application.

Exam 7: Advanced SQL

The following query will execute without errors. select customer.customer_name, salesman.sales_quota from customer where customer.salesman_id = (select salesman_id where lname = 'SMITH');

(True/False)

4.9/5

(79)

Question 41

IF-THEN-ELSE logical processing cannot be accomplished within an SQL statement.

(True/False)

4.7/5

(85)

Question 42

What strategies can be used to write queries that run more efficiently?

(Essay)

4.9/5

(71)

Question 43

A join operation:

(Multiple Choice)

4.8/5

(79)

Question 44

Transaction integrity commands are not used to identify whole units of database changes that must be completed in full for the database to retain integrity.

(True/False)

4.7/5

(89)

Question 45

What are some tips for developing queries?

(Essay)

4.9/5

(82)

Question 46

________ takes a value of TRUE if a subquery returns an intermediate results table which contains one or more rows.

(Multiple Choice)

4.8/5

(93)

Question 47

A named set of SQL statements that are considered when a data modification occurs are called:

(Multiple Choice)

4.8/5

(71)

Question 48

Discuss some of the SQL:2008 enhancements and extensions to SQL.

(Essay)

4.9/5

(81)

Question 49

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

(Multiple Choice)

4.8/5

(85)

Question 50

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

(True/False)

4.8/5

(80)

Question 51

Dynamic SQL:

(Multiple Choice)

4.8/5

(78)

Question 52

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

(True/False)

4.8/5

(76)

Question 53

The joining condition of an equi-join is based upon an equality.

(True/False)

5.0/5

(88)

Question 54

The following code is an example of a(n): SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T. CustomerID;

(Multiple Choice)

4.9/5

(94)

Question 55

Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by:

(Multiple Choice)

4.8/5

(89)

Question 56

EXISTS takes a value of false if the subquery returns an intermediate result set.

(True/False)

4.9/5

(75)

Question 57

The following code would include: SELECT Customer_T.CustomerID,CustomerName, OrderID FROM Customer_T LEFT OUTER JOIN Order_T ON Customer_T.CustomerID = Order_T.CustomerID;

(Multiple Choice)

4.8/5

(80)

Question 58

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

(True/False)

5.0/5

(74)

Question 59

The natural join is very rarely used.

(True/False)

4.9/5

(80)

Question 60

Showing 41 - 60 of 107

The following query will execute without errors. select customer.customer_name, salesman.sales_quota from customer where customer.salesman_id = (select salesman_id where lname = 'SMITH');

IF-THEN-ELSE logical processing cannot be accomplished within an SQL statement.

What strategies can be used to write queries that run more efficiently?

A join operation:

Transaction integrity commands are not used to identify whole units of database changes that must be completed in full for the database to retain integrity.

What are some tips for developing queries?

________ takes a value of TRUE if a subquery returns an intermediate results table which contains one or more rows.

A named set of SQL statements that are considered when a data modification occurs are called:

Discuss some of the SQL:2008 enhancements and extensions to SQL.

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

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

Dynamic SQL:

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

The joining condition of an equi-join is based upon an equality.

The following code is an example of a(n): SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T. CustomerID;

Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by:

EXISTS takes a value of false if the subquery returns an intermediate result set.

The following code would include: SELECT Customer_T.CustomerID,CustomerName, OrderID FROM Customer_T LEFT OUTER JOIN Order_T ON Customer_T.CustomerID = Order_T.CustomerID;

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

The natural join is very rarely used.

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