Question 1

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

Question 2

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 3

"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 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)   full
B)   inner
C)   outer
D)   setE) A) and C)
F) All of the above

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

The syntax for a left outer join is ____.

Accepted Answer

A)   SELECT column-listFROM table1 OUTER JOIN table2 LEFTWHERE join-condition
B)   SELECT column-listFROM table1 LEFT [OUTER] JOIN table2ON join-condition
C)   SELECT column-listWHERE LEFT table1 = table 2
D)   SELECT column-listFROM table1 LEFT table2 [JOIN]WHERE join-conditionE) C) and D)
F) A) and D)

Question 12

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)   CONVERTE) A) and B)
F) A) and C)

Question 13

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 statementE) All of the above
F) B) and C)

Question 14

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)   144E) A) and D)
F) A) and C)

Question 15

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

Accepted Answer

A)   UNION
B)   UNION ALL
C)   INTERSECT
D)   MINUSE) B) and C)
F) A) and B)

Question 16

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

Accepted Answer

A)   subquery
B)   range query
C)   join
D)   set queryE) A) and B)
F) A) and C)

Question 17

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 SQLE) A) and B)
F) A) and C)

Question 18

The Oracle ____ function returns the current date.

Accepted Answer

A)   DATE
B)   SYSDATE
C)   CURRENT_DATE
D)   TO_DATEE) B) and C)
F) All of the above

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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 ONE) C) and D)
F) None of the above

Exam 8: Advanced SQL

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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;

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

The syntax for a left outer join is ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The Oracle ____ function returns the current date.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified