Topic : Architecture

What database object type can be used to generate a series of sequential numbers?


Answer :

A sequence can be used to generate a series of sequential numbers.

Show Answer Discuss

What is the Oracle Enterprise Manager?


Answer :

The Oracle Enterprise Manager is the new graphical administration tool designed to help the DBA manage one or more Oracle systems.

Show Answer Discuss

What is the different between a fixed and a variable record load file?


Answer :

The fixed record load file has data in columns where the same column in each record has the same length. The variable record datafile has different records where the same column may be a different length.

Show Answer Discuss

What type of key can be used to enforce referential integrity between two tables in a database?


Answer :

A foreign key can be used to enforce referential integrity between two tables.

Show Answer Discuss

What is the primary duty of the DBA?


Answer :

The primary duty of the DBA is to protect the database and provide continuous (if required) access to that data for the user community.

Show Answer Discuss