Question 1

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 2

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

Question 3

The PL/SQL block starts with the section.

Accepted Answer

A) IS 
B) OPEN 
C) DECLARE 
D) BEGIN 
A) IS 
B) OPEN 
C) DECLARE 
D) BEGIN

Question 4

When using a subquery,the output of a(n)query is used as the input for the outer query.

Accepted Answer

The answer of When using a subquery,the output of a(n)query...

Question 5

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 6

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 7

Cursors are held in a reserved memory area in the client computer.

Accepted Answer

A) True 
 B)False

Question 8

Oracle recommends for creating audit logs.

Accepted Answer

A) triggers 
B) stored procedures 
C) stored functions 
D) tables 
A) triggers 
B) stored procedures 
C) stored functions 
D) tables

Question 9

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 10

The statement combines rows from two queries and excludes duplicates.

Accepted Answer

A) UNION 
B) UNION ALL 
C) INTERSECT 
D) MINUS 
A) UNION 
B) UNION ALL 
C) INTERSECT 
D) MINUS

Question 11

An explicit cursor must return two or more rows.

Accepted Answer

A) True 
 B)False

Question 12

The IN subquery uses a(n)operator.

Accepted Answer

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

Question 13

The Oracle string concatenation function is .

Accepted Answer

A) CONCAT 
B) + 
C) || 
D) && 
A) CONCAT 
B) + 
C) || 
D) &&

Question 14

Describe the characteristics of an Oracle sequence.

Accepted Answer

- Oracle sequences are an independent ob

Question 15

Oracle uses the function to extract the various parts of a date.

Accepted Answer

The answer of Oracle uses the function to extract the...

Question 16

A sequence is not associated with a table and can be dropped from a database with a DROP SEQUENCE command.

Accepted Answer

A) True 
 B)False

Question 17

A stored function is another name for a stored procedure.

Accepted Answer

A) True 
 B)False

Question 18

Stored procedures must have at least one argument.

Accepted Answer

A) True 
 B)False

Question 19

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

Question 20

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

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

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

The PL/SQL block starts with the section.

When using a subquery,the output of a(n)query is used as the input for the outer query.

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

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

Cursors are held in a reserved memory area in the client computer.

Oracle recommends for creating audit logs.

The statement combines rows from two queries and excludes duplicates.

An explicit cursor must return two or more rows.

The IN subquery uses a(n)operator.

The Oracle string concatenation function is .

Describe the characteristics of an Oracle sequence.

Oracle uses the function to extract the various parts of a date.

A sequence is not associated with a table and can be dropped from a database with a DROP SEQUENCE command.

A stored function is another name for a stored procedure.

Stored procedures must have at least one argument.

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

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

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

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

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

The PL/SQL block starts with the section.

When using a subquery,the output of a(n)query is used as the input for the outer query.

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

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

Cursors are held in a reserved memory area in the client computer.

Oracle recommends for creating audit logs.

The statement combines rows from two queries and excludes duplicates.

An explicit cursor must return two or more rows.

The IN subquery uses a(n)operator.

The Oracle string concatenation function is .

Describe the characteristics of an Oracle sequence.

Oracle uses the function to extract the various parts of a date.

A sequence is not associated with a table and can be dropped from a database with a DROP SEQUENCE command.

A stored function is another name for a stored procedure.

Stored procedures must have at least one argument.

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

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

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