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

Making an index ____________ is an alternative method to make it unusable or dropping it.

• A) INVISIBLE
• B) MUTE
• C) UNREADABLE
• D) VISIBLE

_______________ statement is used to change or rebuild an existing index.

• A) CHANGE INDEX
• B) UPDATE INDEX
• C) REBUILD INDEX
• D) ALTER INDEX

How many types of views are utilized to control table-related information?

• A) 4
• B) 2
• C) 3
• D) 5

To alter an index, your schema must contain the index or you must have the ______________ system privilege.

• A) ANY INDEX ALTER
• B) ALTER PRIVILEGE
• C) ALTER INDEX
• D) ALTER ANY INDEX

A/an _________________ is a schema object that contains an entry for each value that appears in the column of the table or cluster and provides direct, fast access to rows.

• A) View
• B) Cluster Table
• C) Index
• D) Join

Which of the following table statement is used to delete only the table structure from the database?

• A) Delete
• B) Drop
• C) Update
• D) Create

Which of the following option is not a characteristic of PL/SQL?

• A) Embedded structured programming
• B) Executed on server without any network overhead
• C) Centrally accessible from single database
• D) Performed on client Machine

Which of the following language code is executed on server without any network overhead?

• A) PHP
• B) PL/SQL
• C) Python
• D) C++

Front end programming can be changed without affecting ____________ programming.

• A) Client
• B) Server and client
• C) SQL
• D) Server