0

Advanced DBMS (UGC/NET)

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

Which of the following is generally used to find and sort elements and text in an Extensible Markup Language (XML) document?

  1. XQuery

  2. Quilt

  3. XML-QL

  4. XQL

  5. Lorel


Correct Option: D
Explanation:

It is generally used to find and sort elements and text in an Extensible Markup Language (XML) document.

__________ is/are abstract and can have further subclasses.

  1. Multiple inheritance

  2. Relationships

  3. Data model

  4. Directed acyclic graph

  5. Non-leaf classes


Correct Option: E
Explanation:

Non-leaf classes are abstract and can have further subclasses.

_________ is/are considered a full backup of the database or dump of the database.

  1. Full database backup

  2. Differential backup

  3. Transaction log backup

  4. Redundant transaction logs

  5. Database buffers


Correct Option: A
Explanation:

Full database backup is considered a full backup of the database or dump of the database.

Which of the following object oriented data model concepts comprise(s) of a state and behaviour, where a state is the group of values for the object's attributes and behavoiur is the group of methods?

  1. Object and object identifier

  2. Attributes and methods

  3. Class

  4. Class hierarchy and inheritance

  5. Procedures


Correct Option: B
Explanation:

Each object comprises of a state and behaviour.

Which of the following signifies a relation that relates database element with information regarding locking?

  1. Lock table

  2. Lock

  3. Two-phase locking

  4. Database recovery

  5. Scheduler


Correct Option: A
Explanation:

Lock table signifies a relation that relates database element with information regarding locking.

Which of the following approaches grants all S locks waiting, then one U lock and grants X lock if others are waiting?

  1. First-come-first-served

  2. Shared lock priority

  3. Upgrading priority

  4. Timestamp resolution

  5. None of these


Correct Option: B
Explanation:

This approach grants all S locks waiting, then one U lock and grants X lock if others are waiting.

__________ considers intervals of estimates and proposes heuristics to identify robust plans.

  1. EAO (Error-Aware Optimisation)

  2. LRU (Least Recently Used)

  3. QOS (Quality of Service)

  4. XML (Extensible Markup Language)

  5. Ripple joins


Correct Option: A
Explanation:

EAO (Error-Aware Optimisation) considers intervals of estimates and proposes heuristics to identify robust plans.

Which of the following are accessible from any of the processors through the communication network?

  1. Iterators

  2. Scanning tables

  3. Shared disks

  4. Shared memories

  5. None of these


Correct Option: C
Explanation:

Shared disks are accessible from any of the processors through the communication network.

A/An _________ system is a technique that allows you to take action automatically to events.

  1. active rules

  2. active database

  3. dynamic buffer allocation

  4. multimedia database

  5. None of these


Correct Option: B
Explanation:

An active database system is a technique that allows you to take action automatically to events.

Which of the following is used to store multimedia data such as videos, images and audios in binary format only?

  1. Abstract data type

  2. CLOB

  3. BLOB

  4. ODMG smalltalk binding

  5. ALOB


Correct Option: C
Explanation:

BLOB (Binary Large Object) is generally used to store multimedia data such as video, images and audio, and it stores data in binary format only.

Which of the following transparencies resides when the user should recognise the data fragment names, but has no need to declare at which locations these fragments are situated?

  1. Fragmentation transparency

  2. Location transparency

  3. Local mapping transparency

  4. Horizontal fragmentation

  5. Failure transparency


Correct Option: B
Explanation:

Location transparency resides when the user should recognise the data fragment names, but has no need to declare at which locations these fragments are situated.

Which of the following components of ODMG-93 standard determines how the various objects are represented for exchanging them between different OODBMS?

  1. Object model

  2. Object definition language

  3. Object interchange format

  4. Object query language

  5. Access mode


Correct Option: C
Explanation:

This determines how the various objects are represented for exchanging them between different OODBMS.

_________ simplifies data sharing between different users.

  1. Data fragmentation

  2. Distributed database

  3. Distributed transaction

  4. Distributed transaction coordinator

  5. Homogeneous database


Correct Option: E
Explanation:

Homogeneous database simplifies the data sharing between different users.

Which of the following is/are the main criterion for the accuracy of simultaneous transaction executions and a main objective for concurrency control?

  1. Recoverability

  2. Transaction

  3. Serialisability

  4. Workflow systems

  5. Online transaction processing system


Correct Option: C
Explanation:

Serialisability is the main criterion for the accuracy of simultaneous transaction executions and a main objective for concurrency control.

Which of the following has the ability to subdivide a single query into a number of parts and replicate them concurrently using either intra-partition parallelism or inter-partition parallelism or both?

  1. Degree of parallelism

  2. Intra-query parallelism

  3. Parallel database system

  4. Parallel I/O

  5. None of these


Correct Option: B
Explanation:

Intra-query parallelism has the ability to subdivide a single query into a number of parts and replicate them concurrently using either intra-partition parallelism or inter-partition parallelism or both.

- Hide questions