Question 1

A ____ is a query (SELECT statement)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 2

When using a(n)____ join,only rows that meet the given criteria are returned.

Accepted Answer

A)  full 
B)  inner 
C)  outer 
D)  set 
A)  full 
B)  inner 
C)  outer 
D)  set

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

In Oracle,you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

Accepted Answer

A) True 
 B)False

Question 5

PL/SQL functions are executed in the same way as functions such as MIN and AVG.

Accepted Answer

A) True 
 B)False

Question 6

The ____________________ join is the traditional join in which only rows that meet a given criteria are selected.

Accepted Answer

The answer of The ____________________ join is the traditional join...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

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 10

"Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL,C++,ASP,Java,or ColdFusion.

Accepted Answer

A) True 
 B)False

Question 11

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 12

The ____ query 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 13

To test a trigger,you should use the EXECUTE TRIGGER command.

Accepted Answer

A) True 
 B)False

Question 14

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 15

The ____________________ 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

The answer of The ____________________ function compares an attribute or...

Question 16

In Oracle,____ make(s)it possible to merge SQL and traditional programming constructs,such as variables,conditional processing (IF-THEN-ELSE),basic loops (FOR and WHILE loops,)and error trapping.

Accepted Answer

A)  triggers 
B)  indexes 
C)  embedded SQL 
D)  procedural SQL 
A)  triggers 
B)  indexes 
C)  embedded SQL 
D)  procedural SQL

Question 17

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 18

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 19

If you wish to create an inner join,but the two tables do not have a commonly named attribute,you 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 20

UNION,INTERSECT,and MINUS work properly only if relations are union-compatible,which means that the names of the relation attributes and their data types must be different.

Accepted Answer

A) True 
 B)False

A ____ is a query (SELECT statement)inside a query.

When using a(n)____ join,only rows that meet the given criteria are returned.

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

In Oracle,you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

PL/SQL functions are executed in the same way as functions such as MIN and AVG.

The ____________________ join is the traditional join in which only rows that meet a given criteria are selected.

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

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

The syntax for a left outer join is ____.

"Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL,C++,ASP,Java,or ColdFusion.

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;

The ____ query combines rows from two queries and excludes duplicates.

To test a trigger,you should use the EXECUTE TRIGGER command.

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.

The ____________________ 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.

In Oracle,____ make(s)it possible to merge SQL and traditional programming constructs,such as variables,conditional processing (IF-THEN-ELSE),basic loops (FOR and WHILE loops,)and error trapping.

The Oracle ____ function returns the current date.

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

If you wish to create an inner join,but the two tables do not have a commonly named attribute,you can use a(n)____ clause.

UNION,INTERSECT,and MINUS work properly only if relations are union-compatible,which means that the names of the relation attributes and their data types must be different.

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

A ____ is a query (SELECT statement)inside a query.

When using a(n)____ join,only rows that meet the given criteria are returned.

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

In Oracle,you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

PL/SQL functions are executed in the same way as functions such as MIN and AVG.

The ____________________ join is the traditional join in which only rows that meet a given criteria are selected.

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

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

The syntax for a left outer join is ____.

"Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL,C++,ASP,Java,or ColdFusion.

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;

The ____ query combines rows from two queries and excludes duplicates.

To test a trigger,you should use the EXECUTE TRIGGER command.

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.

The ____________________ 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.

In Oracle,____ make(s)it possible to merge SQL and traditional programming constructs,such as variables,conditional processing (IF-THEN-ELSE),basic loops (FOR and WHILE loops,)and error trapping.

The Oracle ____ function returns the current date.

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

If you wish to create an inner join,but the two tables do not have a commonly named attribute,you can use a(n)____ clause.

UNION,INTERSECT,and MINUS work properly only if relations are union-compatible,which means that the names of the relation attributes and their data types must be different.

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