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 41

Multiple Choice

Review LaterAdd Note

Review Later

Which SQL format would be best used for a small, numeric data type?

A) INTEGER
B) SMALLINT
C) NUMERIC(L,D)
D) CHAR(L)

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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

A) %ROWCOUNT
B) %NOTFOUND
C) %FOUND
D) %ISOPEN

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

Triggers can only be used to update table values.

Stored procedures must have at least one argument.

A table can be deleted from the database by using the _____ TABLE command.

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

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.

If a user adds a new column to a table that already has rows, the existing rows will default to a value of _____ for the new column.

The CREATE TABLE command lets you define constraints when you use the CONSTRAINT keyword, known as a(n) _____ constraint.

A(n) _____ is a logical group of database objects, such as tables and indexes, that are related to each other.

In a 1:M relationship, a user must always create the table for the "_____" side first.

The Oracle string concatenation function is _____.

A(n) _____ routine pools multiple transactions into a single batch to update a master table field in a single operation.

A row-level trigger is assumed if we omit the FOR EACH ROW keywords and a statement-level trigger required the use of the FOR EACH ROW keyword.

Every PL/SQL block must be given a name.