FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Managing Databases With Oracle Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

Which type of trigger is commonly used to update views?

A) BEFORE triggers
B) AFTER triggers
C) SELECT triggers
D) INSTEAD OF triggers

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

SOONER and LATER triggers are placed on tables.

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

Sequences are most often used to provide values for surrogate keys.

In Oracle Database,indexes are created using the ALTER command.

Instead of creating a new database instance in Oracle Database,it is preferable to create a new tablespace.

When creating a new database in Oracle Database,two new account passwords are automatically created in the database.

You can include single line comments in an Oracle Database stored procedure by starting each comment line with the /* symbol.

Which of the following commands does Oracle Database not support?

Which of the following can Oracle Database not support?

Which of the following is true about stored procedures in Oracle Database?

The PL/SQL keyword DECLARE is used to begin the basic PL/SQL block structure.

Which of the following Oracle Database ReDo files are stored on disk and contain the rollback segments from recent database changes?

The PL/SQL keyword RETURN is used to exit a block of code and terminate whatever code structure is running.

The PL/SQL keyword BEGIN is used to define a group of PL/SQL statements.

Copying spreadsheet data into a database is part of a larger data warehousing process known as ________.

The GUI tool for creating a new index is the Oracle SQL Developer ________.

In Oracle Database security,a Role can have many system privileges.

An Oracle Database tablespace is a logical subdivision of an Oracle database instance that is used to group related tables,views,and other similar objects.

During the data import process in Oracle,if some of the spreadsheet cells in a column of the source data are empty,________.

Control files,as used by Oracle Database's backup and recovery features,contain records of database changes.