Question 1

Using Oracle , a designer can write a PL/SQL code block by enclosing the commands inside BEGIN and END clauses.

Accepted Answer

The answer of Using Oracle , a designer can write...

Question 2

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

Accepted Answer

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

Question 3

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

Accepted Answer

A)  8 
B)  18 
C)  26 
D)  144 
A)  8 
B)  18 
C)  26 
D)  144

Question 4

Which of the following is a feature of a correlated subquery?

Accepted Answer

A) 	The inner subquery executes first. 
B)  The outer subquery initiates the process of execution in a subquery. 
C) 	The inner subquery initiates the process of 
D) 	The outer subquery executes independent
execution in a subquery.	of the inner subquery 
A) 	The inner subquery executes first. 
B)  The outer subquery initiates the process of execution in a subquery. 
C) 	The inner subquery initiates the process of 
D) 	The outer subquery executes independent
execution in a subquery.	of the inner subquery

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.

Accepted Answer

A) True 
 B)False

Question 7

Stored procedures help reduce code duplication by means of code isolation and code sharing.

Accepted Answer

A) True 
 B)False

Question 8

One of the disadvantages of stored procedures is that they increase network traffic.

Accepted Answer

A) True 
 B)False

Question 9

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 10

The data type is compatible with NUMBER.

Accepted Answer

A)  VARCHAR(15) 
B)  SMALLINT 
C)  DATE 
D)  CHAR(10) 
A)  VARCHAR(15) 
B)  SMALLINT 
C)  DATE 
D)  CHAR(10)

Question 11

The syntax for the UNION query is .

Accepted Answer

A)  query + query 
B)  UNION (query, query) 
C)  UNION: query query 
D)  query UNION query 
A)  query + query 
B)  UNION (query, query) 
C)  UNION: query query 
D)  query UNION query

Question 12

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

Accepted Answer

The answer of A(n) subquery is a subquery that executes...

Question 13

Describe the characteristics of an Oracle sequence.

Accepted Answer

- Oracle sequences are an independent ob

Question 14

A join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.

Accepted Answer

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

Question 15

A(n) is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server.

Accepted Answer

A)  PSM 
B)  PLS 
C)  SQL Statement 
D)  PMR 
A)  PSM 
B)  PLS 
C)  SQL Statement 
D)  PMR

Question 16

Cursor-style processing involves retrieving data from the cursor, one row at a time.

Accepted Answer

A) True 
 B)False

Question 17

is the term used to describe an environment in which the SQL statement is not known in advance and is generated at run time.

Accepted Answer

The answer of is the term used to describe an...

Question 18

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

Accepted Answer

The answer of A row-level trigger requires use of the...

Question 19

The IN subquery uses a(n) operator.

Accepted Answer

The answer of The IN subquery uses a(n) operator....

Question 20

The statement combines the output of two SELECT queries.

Accepted Answer

The answer of The statement combines the output of two...

Using Oracle , a designer can write a PL/SQL code block by enclosing the commands inside BEGIN and END clauses.

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

Which of the following is a feature of a correlated subquery?

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

A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.

Stored procedures help reduce code duplication by means of code isolation and code sharing.

One of the disadvantages of stored procedures is that they increase network traffic.

The data type is compatible with NUMBER.

The syntax for the UNION query is .

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

Describe the characteristics of an Oracle sequence.

A join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.

A(n) is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server.

Cursor-style processing involves retrieving data from the cursor, one row at a time.

is the term used to describe an environment in which the SQL statement is not known in advance and is generated at run time.

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

The IN subquery uses a(n) operator.

The statement combines the output of two SELECT queries.

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

Using Oracle , a designer can write a PL/SQL code block by enclosing the commands inside BEGIN and END clauses.

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

Which of the following is a feature of a correlated subquery?

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

A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.

Stored procedures help reduce code duplication by means of code isolation and code sharing.

One of the disadvantages of stored procedures is that they increase network traffic.

The data type is compatible with NUMBER.

The syntax for the UNION query is .

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

Describe the characteristics of an Oracle sequence.

A join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.

A(n) is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server.

Cursor-style processing involves retrieving data from the cursor, one row at a time.

is the term used to describe an environment in which the SQL statement is not known in advance and is generated at run time.

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

The IN subquery uses a(n) operator.

The statement combines the output of two SELECT queries.

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