FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Advanced SQL

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

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

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

E) B) and D)
F) All of the above

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following is a feature of oracle sequences?

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.

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

"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 syntax of the MINUS statement in Oracle is .

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.

The most useful feature of PL/SQL blocks is that they let a designer create code that can be named,stored,and executed by the DBMS.

is a relational set operator.

The clause is used to restrict the output of a GROUP BY query by applying a conditional criteria to the grouped rows.

Variables can be declared inside a stored procedure.

Every PL/SQL block must be given a name.

In the context of SELECT subquery types,a is returned when an UPDATE subquery is used.

Numeric functions take one numeric parameter and return one value.

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

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

The statement can be used to combine rows from two queries,returning only the rows that appear in both sets.

If the DBMS does not support the INTERSECT statement,one can use a(n)subquery to achieve the same result.

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

In subquery terminology,the first query in the SQL statement is known as the query.

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

is a cursor attribute that returns TRUE if the last FETCH returned a row,and FALSE if not.