Database Management Systems

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)

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.

Ordinary tables are stored with all rows in no particular order.

In ordinary tables, rows of the table are stored in different segments.

In partitioned tables, rows of the table are stored in one segment.

All of the above

Both (1) and (2)

In Application architecture, client application is also responsible for data processing.

Oracle database provides better performance to its client applications.

Oracle database provides better concurrency and data integrity.

Client applications are not dependent on the physical location of the data.

None of the above

System Global Area (SGA) has no direct access from the clients.

System Global Area (SGA) is a called a shared memory segment.

The dictionary cache in SGA caches Oracle own internal information.

None of the above

Both (1) and (3)

The log buffer is responsible for records all the changes made to the buffer cache.

The log buffer is a part of SGA (System Global Area).

The serve process makes an entry to log buffer to execute the SQL statements.

The log buffer is not responsible to redo the changes in case of a recovery process.

None of the above