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 PL/SQL block starts with the _____ section.

A) IS
B) OPEN
C) DECLARE
D) BEGIN

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

To make the SQL code more _____, most SQL programmers use one line per column (attribute) definition.

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

The DECLARE section in the trigger is used to declare any variables used inside the trigger code.

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

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

A _____ is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server.

A(n) _____ cursor is automatically created in procedural SQL when the SQL statement returns only one value.

A sequence is not associated with a table and can be dropped from a database with a DROP SEQUENCE command.

The Oracle equivalent to an MS Access AutoNumber is a(n) _____.

Which command is used to save changes to the database? What is the syntax for this command?

In an INSERT command, a user can indicate just the attributes that have required values by listing the _____ inside parentheses after the table name.

Oracle recommends _____ for creating audit logs.

When you create a new database, the RDBMS automatically creates the data_____ tables in which to store the metadata and creates a default database administrator.

To delete an index, one must use the _____ command.

A statement-level trigger is assumed if a designer omits the FOR EACH ROW keywords.

If the NOT NULL and UNIQUE specifications are not supported when using a command sequence, use _____ without the specifications.

Using the _____ command, SQL indexes can be created on the basis of any selected attribute.

A persistent stored module is stored and executed on the database client machine.

SQL requires the use of the _____ command to enter data into a table.

In MS Access, a designer can use the _____ data type to define a column in his table that will be automatically populated with unique numeric values.