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

What do we call a view of a database that appears in an application program?

  1. Schema

  2. Database instance

  3. Sub-schema

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

View is like a window to the table in the database or of the database, through which we can see the database. VIEW is a command to make a view of some essential attributes or columns of a database or table, so it is also called a sub-schema.

Multiple choice

How can we resolve the problem of data concurrency?

  1. Redundancy

  2. Versioning

  3. Transition

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

Versioning involves recording and managing changes to a multi-user GEO database by creating a 'version' of the database—an alternative, independent, persistent view of the database that does not involve in creating a copy of the data and supports multiple concurrent.

Multiple choice

Which of the following statements are FALSE regarding PSIBLAST?

  1. PSIBLAST uses PSSMs to score matches between query and database sequences.
  2. PSIBLAST is a statistically driven search method that finds regions of similarity between your query sequence and database sequences and produces ungapped alignments of those regions.
  3. The number of scoring matrices available for use with PSIBLAST is limited.

  1. Only 1

  2. Only 2

  3. Only 3

  4. Only 1 and 2

  5. Only 2 and 3
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

PSIBLAST is a statistically driven search method that finds regions of similarity between your query sequence and database sequences and produces gapped alignments of those regions. Within these aligned regions, the calculated score is a level higher than you would normally expect.

Multiple choice

Which of the following databases integrates information from PROSITE, Pfam, PRINTS, ProDom and SMART databases?

  1. COG

  2. CDART

  3. InterPro

  4. ProDom

  5. ProtoNet
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Yes, it is the correct answer. InterPro is an integrated pattern database designed to unify multiple databases for protein domains and functional sites. The database integrates information from PROSITE, Pfam, PRINTS, ProDom and SMART databases. The sequence patterns from the five databases are further processed. Only overlapping motifs and domains in a protein sequence derived by all five databases are included.

Multiple choice

Which of the following information does Metadata contain?

  1. It is used to store the information for the CLI specific.

  2. It is used to provide the application specific features to the assembly.

  3. It has the data attributes in the application.

  4. It allows the creator of the class, the ability to adorn it with extra information that consumers of the class can use in various meaningful ways depending on the application domain.

  5. All of these
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Yes this is the correct answer.

Multiple choice

What is a data record?

  1. Total information

  2. Complete set of related information

  3. All font styles

  4. Alignments
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Complete test of selected information

Multiple choice

The entity- relationship model comes under

  1. object based logical model

  2. record based logical model

  3. physical data model

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

The E-R model is classified as an object-based logical model because it describes data in terms of entities and relationships rather than tables or records.

Multiple choice

Loss of data integrity implies that data is

  1. not suitable for running in an integrated environment

  2. inconsistent

  3. repeated

  4. outdated

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Data integrity refers to the accuracy, completeness, and consistency of data over its lifecycle. When data is inconsistent, it means the integrity has been compromised.

Multiple choice

In a hospital data base system, the data relationship between the entity “Patient” and the entity “ward” would be

  1. one-to-one

  2. one-to-many

  3. many-to-one

  4. many-to-many
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In a hospital database, one ward contains many patients, and a patient is typically assigned to one ward. However, if the system tracks patient history across multiple wards or multiple patients per ward, it is often modeled as a many-to-many relationship depending on the specific business rules.

Multiple choice

Data integrity stands for

  1. thoroughly validated data

  2. data stored in different files showing consistency

  3. data fields integrated to provide summary

  4. none of these
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Data integrity refers to the accuracy and consistency of data. Since none of the provided options fully define the concept, 'None of these' is the most appropriate choice.