Database Management Systems

The group OSDBA has a specific name 'dba' for Unix user group.

For the member of the OSDBA group with the SYSDBA, the system privilege will be SYSDBA while connecting to the database.

For the member of the SYSOPER group with the SYSDBA, the system privilege will be SYSOPER while connecting to the database.

The CONNECT command fails in case of no member from the groups SYSDBA or SYSOPER found while connecting to the database.

All of the above

There must be sufficient memory available to start the oracle database instance.

There must be sufficient disk storage space must be available for the planned database.

The operating system privileges must be associated with a fully operational database administrator.

All of the above

Both (2) and (3)

The name of the password file

The password

The maximum number of distinct DBAs and OPERs

To check whether to overwrite existing file

Both (3) and (4)

SYSDBA authorizes ALTER DATABASE ARCHIVELOG.

SYSDBA authorizes DROP DATABASE.

SYSOPER privilege performs STARTUP and SHUTDOWN operations.

SYSOPER privilege authorizes ALTER DATABASE ARCHIVELOG.

All of the above

The database can be shutdown instantaneously by this clause.

After this clause, uncommitted transactions are not rolled back.

After this clause, the database implicitly disconnects all connected users.

All of the above

Both (1) and (3)

SWISS-PROT and PROSITE

SWISS-PROT and Genbank

PROSITE and Genbank

PROSITE and Pfam

Genbank and Pfam

TRANSFAC

RefSeq

ModBASE

TreeBASE

InterPro

EMBL

PDB

Sequin

BioOne

ModBase

The data of the logical database structures physically stores in the datafiles.

The datafile can be associated with more than one database.

The data in datafiles is stored in the memory cache of Oracle.

All of the above

Both (1) and (3)

Control files specify the physical structure of the database.

A control file has information about the name of the database.

A control file is responsible for identification of the database during database operation.

A control file can be used for database recovery operation.

None of the above

Tablespaces group related database structures together.

Data files physically store the data of all logical structures in a tablespace.

Each database is logically divided into one or more tablespaces.

All of the above

Both (1) and (2)

The data segment defines the logical structure of the database.

Each partition has a data segment for a partitioned table in the database.

Database segments are created when a SQL statement needs temporary database area to complete execution.

Every table in the cluster stores its data in the cluster's data segment.

None of the above

These files can be used to record the changes made in the database.

Oracle allows a multiplex redo log operation for Redo log files.

Redo log file contains the information that is used only to recover the database from a system or media failure.

Redo log file contains the information about the Time stamp of database creation.

Every Oracle database can have set of two or more Redo log files.

Schema objects define the logical structures of the database.

There is a relationship between a tablespace and a schema.

The schema objects contain structures like tables, views, and indexes.

All of the above

Both (1) and (3)

Clusters can affect application design.

The data stored in a clustered table is accessed by SQL.

Clustering is used to order the physical placement of tables on a disk drive.

Cluster key determines the value of cluster key columns for a particular row.

Cluster also improves retrieval performance of the database operation.