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

Character string length is maximum 2000 bytes.

There are no reference data types defined for Oracle database.

The array data type is ordered type.

long raw comes under the collection data types.

Both (2) and (4)

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

It is used to store log records for recovery process.

Log writer is responsible for writing the redo log buffer to the redo log files.

The typical size of log writer is up to a few hundred kilobytes.

All of the above

Both (1) and (2)

Multitier Architecture contains one or more application servers.

An application server acts as an interface between clients and multiple database servers.

Multitier architecture enables application server to validate the credentials of a client, such as a web browser.

All of the above

Both (1) and (3)

Oracle instance is a major component in the Oracle database server.

Oracle instance is a set of memory and process structures.

It is responsible for translating SQL calls given by the client.

Oracle instance may exist without being associated with an Oracle database.

None of the above