A/an ____________ is a collection of column information corresponding to a single record.

• A) Entity
• B) Attribute
• C) Row
• D) Table

A/an ________ is a logical representation of a table or combination of tables.

• A) Function
• B) Index
• C) Join
• D) View

Which of the following database provide the concept of partitions as tablespaces?

• A) MS Excel
• B) MS Access
• C) Clipper
• D) Oracle

Which of the following archive destination status indicates whether there was a problem accessing the destination?

• A) Valid/Invalid
• B) Active/Inactive
• C) Enabled/Disabled
• D) Archiving/ Non-Archiving

__________ is the basic unit of data storage in an Oracle Database.

• A) Table
• B) Function
• C) Index
• D) Join

You can use views in almost the same way as __________.

• A) Join
• B) Table
• C) Function
• D) Index

The structure consists of two or more pre-allocated files that store all changes made to the database as they occur, known as ______________.

• A) Change store log
• B) Undo Log
• C) Backup Log
• D) Redo Log

_______­­­­­__ determines if the information about the disc location or the service name is specified and valid.

• A) Active/Inactive
• B) Valid/Invalid
• C) Archiving/ Non-Archiving
• D) Enabled/Disabled

To create a new group of redo log files, use the SQL statement ALTER DATABASAE with the ______________ clause with Group number.

• A) ADD LOGFILE
• B) ADD GROUP FILE
• C) ADD REDO LOGFILE
• D) ADD GROUP LOG FILE

Redo records are buffered in a __________ fashion in the redo log buffer of the SGA.

• A) LIFO
• B) Linear
• C) Circular
• D) FIFO

The Average number of transactions processed per minute is called __________.

• A) Multiplexing
• B) Transaction Throughput
• C) Space Utilization
• D) Speed

______________________ is referred as the time that a database transaction takes to run and obtains a response.

• A) Throughput
• B) Speed
• C) Multiplexing
• D) Response Time

Redo records are written to one of the redo log files by the ______________.

• A) Log Writer
• B) File Writer
• C) Record Writer
• D) Redo Writer

____________ are redo log files that are necessary for instance recovery.

• A) Redo instance files
• B) Active Redo instance files
• C) Active Redo log files
• D) Redo log files

__________ is the process of converting redo log files into archived redo log files.

• A) Multiplexing
• B) Archiving
• C) Archive process
• D) Non-Archiving

A/an _________ derives its data from the table on which it is based. This table is known as base table.

• A) Index
• B) Join
• C) Function
• D) View

A _______________ is the point at which the database stops writing to one redo log file and begins writing to another.

• A) Log switch
• B) Log change
• C) Redo file switch
• D) Redo switch

To create new redo log members for an existing group, use the SQL statement ALTER DATABASE with the ________________ clause.

• A) ADD LOGFILE MEMBER
• B) ALTER LOGFILE MEMBER
• C) ADD MEMBER
• D) ALTER MEMBER

Which of the following option display all redo log groups for the database and indicates which group need to be archived?

• A) V$LOG_HISTORY
• B) V$LOG
• C) V$BACKUP_REDOLOG
• D) V$DATABASE

Which of the following option display information about the state of various archive processes for an instance?

• A) V$DATABASE
• B) V$LOG
• C) V$LOG_HISTORY
• D) V$ARCHIVE_PROCESSES