0

Data Base Management Systems (CBSE (UGC) NET)

Description: Data Base Management System
Number of Questions: 15
Created by:
Tags: Data Base Management System Data Base Management Systems
Attempted 0/15 Correct 0 Score 0

Which of the following is an advantage of the hierarchical data model?

  1. Complication in implementation

  2. Structural reliance

  3. Database integrity

  4. Hardware expense

  5. None of these


Correct Option: C
Explanation:

This is an advantage of the hierarchical data model as it is based on inbuilt structure of parent and child relationship.

Which of the following is utilised for running user interface?

  1. Data model

  2. Database client

  3. Database server

  4. Network data model

  5. Database


Correct Option: B
Explanation:

The machine which is utilised for running user interface is considered as database client.

Which of the following is the most extensively accepted criterion for the classification of a database?

  1. Based on the number of users

  2. Based on the number of sites

  3. Based on cost

  4. Based on purpose

  5. Based on data model


Correct Option: E
Explanation:

This criterion is most extensively accepted for the classification of a database.

Which of the following is/are capable of reading, but cannot perform updation of local data items?

  1. Local-read protocol

  2. Local transactions

  3. Global-read protocol

  4. Global transactions

  5. Primary-copy locking


Correct Option: C
Explanation:

It can read, but cannot perform updation of local data items.

Which of the following is used by data grids to offer better quality of service (QoS) to users and applications?

  1. Adaptive query processing in data grid

  2. Adaptive query processing in internet applications

  3. Adaptive query processing in web-based data integration

  4. Adaptive query processing in wide area database systems

  5. Detecting and correcting optimiser


Correct Option: A
Explanation:

Adaptive query processing is essentially used by data grids to offer better quality of service (QoS) to users and applications, inspite of dynamically changing resources and environments.

Which of the following offers the information needed to handle organisations in an efficient and effective manner?

  1. DBA

  2. CODASYL

  3. IMS

  4. ODBMS

  5. ERP


Correct Option: C
Explanation:

Integrated Management System is a concept that offers the information needed to handle organisations in an efficient and effective manner.

Which of the following is/are used by the recovery process when the transaction operations do not update the physical database instantly?

  1. Write-ahead

  2. Redundant transaction logs

  3. Database buffer

  4. Deferred-write and deferred-update

  5. Write-through


Correct Option: D
Explanation:

Deferred-write and deferred-update are used by the recovery process when the transaction operations do not update the physical database instantly.

Which of the following databases is prepared for assisting one client and offers him some quality of data proficiency?

  1. Personal database

  2. Two-tier client/server database

  3. Multi-tier client/server database

  4. Enterprise application

  5. Enterprise resource planning


Correct Option: A
Explanation:

Personal database is prepared for assisting one client and offers him some quality of data proficiency.

Merging of the sorted runs is carried out over in one or more phases in which of the following?

  1. Sorting phase

  2. Linear search

  3. Merging phase

  4. Hash key

  5. None of these


Correct Option: C
Explanation:

In this phase, merging of the sorted runs is carried out over in one or more phases.

Which of the following methodologies is used for optimising a group of SQL queries with the help of common sub-expressions to save cost and time?

  1. Greedy algorithm

  2. Mobile database system

  3. Query optimisation

  4. Multi-query optimisation

  5. Query tree


Correct Option: D
Explanation:

Multi-query optimisation is a methodology of optimising a group of SQL queries with the help of common sub-expressions to save cost and time.

On the failing of the transaction, the system is required to return to the situation that it was in before the transaction was initiated. It is called as

  1. recovery schedule

  2. managing rollback using locking

  3. deadlock detection by timeout

  4. cascading rollback

  5. view serialisability


Correct Option: D
Explanation:

On the failing of a transaction, the system is required to return to the situation that it was in before the transaction was initiated. It is called as cascading rollback.

In which of the following approaches do the client processors of OODBMS have an interaction with a network file service for reading and writing database pages?

  1. Object server approach

  2. Page server approach

  3. File server approach

  4. Object clustering

  5. Heterogeneous operation


Correct Option: C
Explanation:

In this approach, the client processors of OODBMS have an interaction with a network file service for reading and writing database pages.

Which of the following means executing different independent queries simultaneously on separate CPUs?

  1. Degree of parallelism

  2. Intra-query parallelism

  3. I/O parallelism

  4. Inter-query parallelism

  5. None of these


Correct Option: D
Explanation:

Inter-query parallelism means executing different independent queries simultaneously on separate CPUs.

In which of the following approaches is one operation's output streamed into the input of some other operator and these two operators can function simultaneously in a series?

  1. Pipelined parallelism

  2. Partitioned parallelism

  3. Shared memory multiprocessor

  4. Shared nothing multiprocessor

  5. Shared disk multiprocessor


Correct Option: A
Explanation:

In pipelined parallelism approach, one operation's output is streamed into the input of some other operator and these two operators can function simultaneously in a series.

Which of the following keeps data sorted and allows searches, sequential access, insertions and deletions in logarithmic time?

  1. B-tree index

  2. Concurrency control

  3. Database element

  4. Database recovery

  5. Scheduler


Correct Option: A
Explanation:

It keeps data sorted and allows searches, sequential access, insertions and deletions in logarithmic time.

- Hide questions