0

RDBMS

Description: RDBMS
Number of Questions: 15
Created by:
Tags: RDBMS Database
Attempted 0/15 Correct 0 Score 0

Which of the following databases in RDBMS contains data assisting needs of middle management to monitor and control business activities by effective and efficient management of men, machines and money?

  1. Strategic planning database

  2. Control database

  3. Operational database

  4. Single global database

  5. Storage database


Correct Option: B
Explanation:

This type of database in RDBMS contains data assisting needs of middle management to monitor and control business activities by effective and efficient management of men, machines and money.

Which of the following modules in transaction model moves data between memory and disk using some page replacement policy?

  1. Recovery manager

  2. Scheduler

  3. Buffer manager

  4. Transaction manager

  5. Area manager


Correct Option: C
Explanation:

This module in transaction model moves data between memory and disk using some page replacement policy.

Which of the following approaches in database design starts with enterprise level model preparing data model for the entire application domain?

  1. Bottom-up approach

  2. Top-down approach

  3. Multiple database approach

  4. Step-down approach

  5. Project approach


Correct Option: B
Explanation:

This approach in database design starts with enterprise level model preparing data model for entire application domain.

Which of the following forms of indexes in index sequential files contains one anchor per cylinder and is stored in separate areas?

  1. Track index

  2. Cylinder index

  3. Master index

  4. Cluster index

  5. Primary index


Correct Option: B
Explanation:

This form of index in index sequential files contains one anchor per cylinder and it is stored in separate areas.

Which of the following HDBMS (Hierarchical DBMS) modules processes HSQL query statement and translates them into intermediate tree representation containing algebraic operations?

  1. Terminal interface

  2. Schema processor

  3. Query processor

  4. Query optimiser and Access planner

  5. Query Execution module


Correct Option: C
Explanation:

This HDBMS module processes HSQL query statement and translates them into an intermediate tree representation containing algebraic operations.

Which of the following utilities of DBMS refers to dumping entire database on tapes for recovery from media failures, may be online or offline?

  1. Loading

  2. Performance monitoring

  3. File reorganisation

  4. Backup

  5. Schema


Correct Option: D
Explanation:

This utilities of DBMS refers to dumping entire database on tapes for recovery from media failures, may be online or offline.

Which of the following structures of the database consists of datafiles, redo log files and control files?

  1. Database block

  2. Extent

  3. Segment

  4. Physical structure

  5. Schema


Correct Option: D
Explanation:

The physical structure of the database consists of datafiles, redo log files and control files.

Which of the following parameters in evaluating performance of a file organisation specifies what percentage of records are added, modified and deleted over a period of time?

  1. Hit ratio

  2. Access keys

  3. Volatility

  4. Frequency

  5. Response time


Correct Option: C
Explanation:

This parameter in evaluating performance of a file organisation specifies what percentage of records are added, modified and deleted over a period of time.

Which of the following objects in Oracle is a set of tables and views that are used as a read only reference about the database?

  1. Tuple

  2. Cardinality

  3. Data dictionary

  4. Schema

  5. Member methods


Correct Option: C
Explanation:

This object in Oracle is a set of tables and views that are used as a read only reference about the database.

Which of the following operators in relational algebra, selects a subset of tuples of the relation that satisfy a select condition?

  1. Project

  2. Select

  3. Cartesian product

  4. Join

  5. Divide


Correct Option: B
Explanation:

This operator in relational algebra selects a subset of tuples of the relation that satisfy a select condition.

Which of the following forms of normalisation states that non-key attributes are functionally dependent on the key attributes?

  1. 1 NF

  2. 2 NF

  3. 3 NF

  4. BCNF

  5. 5 NF


Correct Option: B
Explanation:

This form of normalisation states that non-key attributes are functionally dependent on the key attributes.

Which of the following forms of data integrity refers to the range of valid entries for a given column?

  1. Referential integrity

  2. Entity integrity

  3. Domain integrity

  4. Select

  5. Semi-Join


Correct Option: C
Explanation:

This form of data integrity refers to the range of valid entries for a given column.

Which of the following files in physical data organisation of data storage devices holds instances of many different record types?

  1. Homogeneous file

  2. Master file

  3. Non-Homogeneous file

  4. Transaction file

  5. Reference file


Correct Option: C
Explanation:

This file in physical data organisation of data storage devices holds instances of many different record types.

Which of the following layer decomposes the distributed calculus query into an algebraic query on global relations?

  1. Data localisation

  2. Global query optimisation

  3. Query decomposition

  4. Local query optimisation

  5. Query processor


Correct Option: C
Explanation:

This layer decomposes the distributed calculus query into an algebraic query on global relations.

Which of the following method is used to store varying length records in the database which allocate maximum length required by a field and use spaces/null for shorter values?

  1. Using pointers

  2. Combined method

  3. Reserved space

  4. B-Tree

  5. Chaining method


Correct Option: C
Explanation:

This method is used to store varying length records in the database which allocate maximum length required by a field and use spaces/null for shorter values.

- Hide questions