Database Management Systems

This option of the STARTUP command is used when you want only users who possess the privilege to access the database.

It consists of the memory components of oracle and various background processes.

This file can be used when you use database authentication.

It can be reorganized, backed up and so forth with minimal impact to other users whose data may be in other thablespaces.

Blocks that need to be modified, are modified in memory and are written back to disk periodically.

This logical object is the smallest unit of storage in a oracle database.

This answer is correct. 'Dbtimezone' is the keyword to get the timezone of the current DB. It gives the current timezone in which the database is existing.

It is the transformation of a string of characters into a usually shorter fixed-length value or key that represents the original string.

RAID system configuration increases the disk storage capacity and availability by combining multiple disks in one unit logically.

Yes, all the above options are disadvantages

It s a stored query and creates virtual columns from table in memory.

Correct option

If only the primary is active, the transaction is allowed to commit as soon as its commit log record is written to stable storage at the primary site.

This term relates to the size of objects that are locked with a single lock operation.

The problem with this classification of degree of durability is that transaction processing can not proceed if either the primary or the backup site is down.