Question 1

Each statement inside the PL/SQL code must end with a period (".").

Accepted Answer

A) True 
 B)False

Question 2

is a string function that returns the number of characters in a string value.

Accepted Answer

A)  LENGTH 
B)  SUBSTRING 
C)  CONCAT 
D)  UCASE 
A)  LENGTH 
B)  SUBSTRING 
C)  CONCAT 
D)  UCASE

Question 3

PL/SQL blocks have a section used to declare variables.

Accepted Answer

A) True 
 B)False

Question 4

A is a query inside a query.

Accepted Answer

A)  subquery 
B)  range query 
C)  join 
D)  set query 
A)  subquery 
B)  range query 
C)  join 
D)  set query

Question 5

An alternate syntax for a join is: SELECT column-list FROM table1 JOIN table2 (common-column).

Accepted Answer

The answer of An alternate syntax for a join is:...

Question 6

The Oracle function returns the current date.

Accepted Answer

A)  DATE 
B)  SYSDATE 
C)  CURRENT_DATE 
D)  TO_DATE 
A)  DATE 
B)  SYSDATE 
C)  CURRENT_DATE 
D)  TO_DATE

Question 7

"Union-compatible" means that the .

Accepted Answer

A)  names of the relation attributes can be different, but the data types must be alike 
B)  names of the relation attributes must be the same, but the data types can be different 
C)  names of the relation attributes must be the same and their data types must be alike 
D)  number of attributes must be the same, but the names and data types can be different 
A)  names of the relation attributes can be different, but the data types must be alike 
B)  names of the relation attributes must be the same, but the data types can be different 
C)  names of the relation attributes must be the same and their data types must be alike 
D)  number of attributes must be the same, but the names and data types can be different

Question 8

In an Oracle sequence, the pseudo-column retrieves the current value of a sequence.

Accepted Answer

The answer of In an Oracle sequence, the pseudo-column retrieves...

Question 9

A(n) routine pools multiple transactions into a single batch to update a master table field in a single operation.

Accepted Answer

The answer of A(n) routine pools multiple transactions into a...

Question 10

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.

Accepted Answer

A)  OF 
B)  USING 
C)  HAS 
D)  JOIN ON 
A)  OF 
B)  USING 
C)  HAS 
D)  JOIN ON

Question 11

To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the SQL-99 standard defined the use of persistent stored modules.

Accepted Answer

A) True 
 B)False

Question 12

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?

Accepted Answer

A)  0 
B)  2 
C)  8 
D)  10 
A)  0 
B)  2 
C)  8 
D)  10

Question 13

Just like database triggers, stored procedures are stored in the database.

Accepted Answer

A) True 
 B)False

Question 14

SQL supports the conditional execution of procedures (IF-THEN-ELSE statements) that are typically supported by a programming language.

Accepted Answer

A) True 
 B)False

Question 15

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 16

The operator could be used in place of INTERSECT if the DBMS does not support it.

Accepted Answer

A)  IN 
B)  OF 
C)  AND 
D)  UNION 
A)  IN 
B)  OF 
C)  AND 
D)  UNION

Question 17

A trigger definition consists of the triggering timing, the triggering event, the triggering level, and the triggering action.

Accepted Answer

A) True 
 B)False

Question 18

A stored function is another name for a stored procedure.

Accepted Answer

A) True 
 B)False

Question 19

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 20

Which of the following is a feature of oracle sequences?

Accepted Answer

A) 	Oracle sequences are tied to columns and tables. 
B) 	Oracle sequences generate a character string
that can be assigned to tables. 
C) 	An oracle sequence uses the identity column 
D) 	An oracle sequence can be created and deleted
property to automatically number rows.		anytime. 
A) 	Oracle sequences are tied to columns and tables. 
B) 	Oracle sequences generate a character string
that can be assigned to tables. 
C) 	An oracle sequence uses the identity column 
D) 	An oracle sequence can be created and deleted
property to automatically number rows.		anytime.

Each statement inside the PL/SQL code must end with a period (".").

is a string function that returns the number of characters in a string value.

PL/SQL blocks have a section used to declare variables.

A is a query inside a query.

An alternate syntax for a join is: SELECT column-list FROM table1 JOIN table2 (common-column).

The Oracle function returns the current date.

"Union-compatible" means that the .

In an Oracle sequence, the pseudo-column retrieves the current value of a sequence.

A(n) routine pools multiple transactions into a single batch to update a master table field in a single operation.

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.

To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the SQL-99 standard defined the use of persistent stored modules.

Just like database triggers, stored procedures are stored in the database.

SQL supports the conditional execution of procedures (IF-THEN-ELSE statements) that are typically supported by a programming language.

The function returns the current system date in MS Access.

The operator could be used in place of INTERSECT if the DBMS does not support it.

A trigger definition consists of the triggering timing, the triggering event, the triggering level, and the triggering action.

A stored function is another name for a stored procedure.

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;

Which of the following is a feature of oracle sequences?

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

Each statement inside the PL/SQL code must end with a period (".").

is a string function that returns the number of characters in a string value.

PL/SQL blocks have a section used to declare variables.

A is a query inside a query.

An alternate syntax for a join is: SELECT column-list FROM table1 JOIN table2 (common-column).

The Oracle function returns the current date.

"Union-compatible" means that the .

In an Oracle sequence, the pseudo-column retrieves the current value of a sequence.

A(n) routine pools multiple transactions into a single batch to update a master table field in a single operation.

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.

To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the SQL-99 standard defined the use of persistent stored modules.

Just like database triggers, stored procedures are stored in the database.

SQL supports the conditional execution of procedures (IF-THEN-ELSE statements) that are typically supported by a programming language.

The function returns the current system date in MS Access.

The operator could be used in place of INTERSECT if the DBMS does not support it.

A trigger definition consists of the triggering timing, the triggering event, the triggering level, and the triggering action.

A stored function is another name for a stored procedure.

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;

Which of the following is a feature of oracle sequences?

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