Computer Knowledge

Database Management Systems

5,344 Questions

Database Management Systems (DBMS) form the core framework for data storage, retrieval, and security in modern software applications. Concepts such as the E-R model, backup planning, SQL integration, and big data architecture are essential for computer knowledge sections. This hub offers a comprehensive set of practice questions to master DBMS fundamentals and advanced database operations.

E-R Model ConceptsBackup and RecoverySQL Server UpgradesJDBC and ODBCBig Data CharacteristicsData VirtualizationOracle Database

Database Management Systems Questions

Multiple choice

The QUEL query language belongs to

  1. Oracle

  2. Ingress

  3. Mysql

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Quel was the original query language for the Ingres dbms. It is now called SQL.

Multiple choice

What does multilevel indexing use?

  1. It uses a binary search tree.

  2. It uses binary search.

  3. Both (1) and (2)

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In binary search tree, it goes according to the root element. If item to be searched is less than root, then it seaches to the left of root otherwise to the right.

Multiple choice

Duplicate data is also referred to as ________ .

  1. storage data

  2. control data

  3. redundant data

  4. accurate data
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Dulpicate data in database is called as data redundancy in database. In order to avoid redundancy we use the technique of normalization.

Multiple choice

What are the additional features included in EER modelling?

  1. Generalization

  2. Specialization

  3. Categorization

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

EER is an Enhanced Entity Relationship. EER model includes all the modelling constructs of the ER model. In ER model, all the types of superclass and sub class relationship are expressed but ISA (IS - A) relationship is denoted by triangle. EER model additional specialization and generalization relationship notations are for defining the superclass and subclass.

Multiple choice

Controlled vocabulary in indexing is called

  1. a thesaurus

  2. a language dictionary

  3. a dictionary of syononyms

  4. a list of subject headings
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A thesaurus is a controlled vocabulary tool used in information retrieval to organize terms and show relationships between concepts.

Multiple choice

PRECIS is a

  1. pre-coordinate indexing system

  2. post-coordinate indexing system

  3. management system

  4. classification system
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

PRECIS (Preserved Context Indexing System) is a pre-coordinate indexing system developed by Derek Austin for the British National Bibliography.

Multiple choice

KWIC indexing technique is based on

  1. titles

  2. citations

  3. abstract

  4. full text
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

KWIC (Keyword-in-Context) indexing is a computer-based system that generates index entries by permuting the words in the title of a document.

Multiple choice

When do we use rollback of transaction?

  1. To repeat the transaction

  2. To update transaction

  3. To save all transactions

  4. To recover from transaction failure
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Rollback is used to recover from transaction failure. We make savepoints, like checkpoints to save our transactions.

Multiple choice

Which of the following is true by means of 4NF?

  1. Join dependency

  2. Transitive dependency

  3. Multivalued dependency

  4. None of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Relation is same as in BCNF but additionally, it has more than one multivalued dependencies.

Multiple choice

Which of the following statements is true by the mean of BCNF?

  1. Not less join but dependency preserving

  2. Loss less join but not dependency preserving

  3. Loss less join and dependency preserving

  4. None of these
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

 For every functional dependency, X->Y in a set F of functional dependencies are over. Unfortunately, BCNF is not dependency preserving. Dependency preserving is not a condition for BCNF decomposition.

Multiple choice

In which of the following models the SET concept is used?

  1. Network model

  2. Hierarchical model

  3. Relational model

  4. None of these
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

 A data type as used in a typical relational database might be the set of integers. The popularity of the network data model coincided with the popularity of the hierarchical data model.Thus, the Network model uses SET .