Question 1

The syntax of the DECODE function starts with .

Accepted Answer

DECODE(e,x,y,d)

Question 2

The statement SELECT * FROM T1,T2 produces a(n)join.

Accepted Answer

A) cross 
B) natural 
C) equi- 
D) full 
A) cross 
B) natural 
C) equi- 
D) full A

Question 3

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 A

Question 4

Subqueries cannot be used in combinations with joins.

Accepted Answer

A) True 
 B)False

Question 5

The syntax for a left outer join is .

Accepted Answer

A) SELECT column-list FROM table1 OUTER JOIN table2 LEFT
WHERE join-condition 
B) SELECT column-list FROM table1 LEFT [OUTER] JOIN table2
ON join-condition 
C) SELECT column-list WHERE LEFT table1 = table 2 
D) SELECT column-list FROM table1 LEFT table2 [JOIN]
WHERE join-condition 
A) SELECT column-list FROM table1 OUTER JOIN table2 LEFT
WHERE join-condition 
B) SELECT column-list FROM table1 LEFT [OUTER] JOIN table2
ON join-condition 
C) SELECT column-list WHERE LEFT table1 = table 2 
D) SELECT column-list FROM table1 LEFT table2 [JOIN]
WHERE join-condition

Question 6

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

Accepted Answer

A) True 
 B)False

Question 7

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 the...

Question 8

BEFORE means before the changes are made in memory but after the changes are permanently saved to disk.

Accepted Answer

A) True 
 B)False

Question 9

The Oracle function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

Accepted Answer

A) NVL 
B) TO_CHAR 
C) DECODE 
D) CONVERT 
A) NVL 
B) TO_CHAR 
C) DECODE 
D) CONVERT

Question 10

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 be...

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

The following SQL statement uses a(n). SELECT P_CODE,P_DESCRIPT,P_PRICE,V_NAME FROM PRODUCT,VENDOR
WHERE PRODUCT.V_CODE = VENDOR.V_CODE;

Accepted Answer

A) set operator 
B) natural join 
C) "old­style" join 
D) procedural statement 
A) set operator 
B) natural join 
C) "old­style" join 
D) procedural statement

Question 13

functions extract a value of a given data type and convert it to the equivalent value in another data type.

Accepted Answer

The answer of functions extract a value of a given...

Question 14

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 15

Assume a designer is using the UNION 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 Jenna and Howard are included in the CUSTOMER table as well as in the CUSTOMER_2 table.How many records are returned when using the UNION operator?

Accepted Answer

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

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

An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.

Accepted Answer

A) True 
 B)False

Question 18

A(n)join will select only the rows with matching values in the common attribute(s).

Accepted Answer

A) natural 
B) cross 
C) full 
D) outer 
A) natural 
B) cross 
C) full 
D) outer

Question 19

The function returns the current system date in MS Access.

Accepted Answer

A) TO_DATE() 
B) SYSDATE() 
C) DATE() 
D) TODAY() 
A) TO_DATE() 
B) SYSDATE() 
C) DATE() 
D) TODAY()

Question 20

MySQL allows multiple triggering conditions per trigger.

Accepted Answer

A) True 
 B)False

The syntax of the DECODE function starts with .

The statement SELECT * FROM T1,T2 produces a(n)join.

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

Subqueries cannot be used in combinations with joins.

The syntax for a left outer join is .

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

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.

BEFORE means before the changes are made in memory but after the changes are permanently saved to disk.

The Oracle function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

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

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

The following SQL statement uses a(n). SELECT P_CODE,P_DESCRIPT,P_PRICE,V_NAME FROM PRODUCT,VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;

functions extract a value of a given data type and convert it to the equivalent value in another data type.

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

An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.

A(n)join will select only the rows with matching values in the common attribute(s).

The function returns the current system date in MS Access.

MySQL allows multiple triggering conditions per trigger.

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

The syntax of the DECODE function starts with .

The statement SELECT * FROM T1,T2 produces a(n)join.

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

Subqueries cannot be used in combinations with joins.

The syntax for a left outer join is .

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

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.

BEFORE means before the changes are made in memory but after the changes are permanently saved to disk.

The Oracle function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

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

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

The following SQL statement uses a(n). SELECT P_CODE,P_DESCRIPT,P_PRICE,V_NAME FROM PRODUCT,VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;

functions extract a value of a given data type and convert it to the equivalent value in another data type.

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

An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.

A(n)join will select only the rows with matching values in the common attribute(s).

The function returns the current system date in MS Access.

MySQL allows multiple triggering conditions per trigger.

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