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

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

A) DROP
B) DELETE
C) MODIFY
D) ERASE

E) C) and D)
F) None of the above

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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

A) column
B) table
C) index
D) cell

E) None of the above
F) A) and B)

Correct Answer

verified

Show Answer

Question 43

Short Answer

Review LaterAdd Note

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

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

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

The Oracle string concatenation function is _____.

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.

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

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

Every PL/SQL block must be given a name.

Triggers can only be used to update table values.

Stored procedures must have at least one argument.

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

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.

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.