Computer Knowledge

Database Management Systems

5,543 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 interface between low-level data stored in the data base and the application program is provided by

  1. storage manager

  2. query processor

  3. data model

  4. only 2 and 3

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

A storage manager is a program module that provides the interface between low-level data stored in the data base and the application program, and the queries submitted by the system. The storage manager is responsible for the interaction with the file manager.

Multiple choice

What is represented by double rectangles?

  1. Weak entity sets

  2. Total participation of an entity in a relationship set

  3. Relationship set

  4. Link attribute to entity set and entity set to the relationship set

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

They are represented by the double rectangles.

Multiple choice

DDL and DML statements are compiled and executed by

  1. query processor

  2. storage manager

  3. data model

  4. only 1 and 3

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

The components of query processor are 1) DDL interpreter 2) DML compiler 3) Query evalution engine  The DDL interpreter interprets DDL statements and records the definition in the data dictionary .The DML compiler translates the DML statements in a query language into an evaluation plan consisting of low-level instruction that the query evaluation engine understands.

Multiple choice

What is/are instance(s) of database?

  1. The relationship among data

  2. The collection of conceptual tools for describing data

  3. The collection of information stored at a particular moment

  4. Only 1 and 3

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

This is the definition of instance of database.

Multiple choice

Which type of command is DROP?

  1. Data Definition Language (DDL) command

  2. Transaction Control Language (TCL) command

  3. Data Query Language (DQL) command

  4. Data Manupulation Language (DML) command

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

It is a Data Definition Language (DDL) command.

Multiple choice

What function(s) is/are done by the Transaction Control Language (TCL) command?

  1. Used for managing data within schema objects

  2. Used to manage the changes made by DML statements and allows statements to be grouped together into logical transactions.

  3. Statements are used to define the database structure or schema.

  4. Only 1 and 2

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

It is done by Transaction Control Language (TCL) commands.

Multiple choice

Which type of command is GRANT?

  1. Transaction Control Language (TCL) command

  2. Data Query Language (DQL) command

  3. Data Control language (DCL) command

  4. Data Definition Language (DDL) command

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

It is a Data Control Language (DCL) command.

Multiple choice

Which of the following databases is/are not Nucleotide Sequence Database (INSD)?

  1. VectorBase
  2. ENA
  3. GenBank
  4. PROSITE

  1. 1 and 4

  2. 1 and 3

  3. 1 and 2

  4. 3 and 4

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

This option is correct because PROSITE is a protein database consisting of entries describing the protein families, domains and functional sites as well as amino acid patterns and profiles in them and VectorBase is an NIAID Bioinformatics Resource Center dedicated to providing data to the scientific community for Invertebrate Vectors of Human Pathogens.

Multiple choice

Which among the following is/are protein databases?

  1. UniProt
  2. InterPro
  3. SCOP
  4. ModBase
  5. OMIM

  1. Only 1

  2. 1, 2 and 3

  3. 2, 3 and 4

  4. 1, 2, 3 and 4

  5. Only 4
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This option is correct because UniProt is a comprehensive, high-quality and freely accessible database of protein sequence and functional information. InterPro is a database of protein families, domains and functional sites in which identifiable features found in known proteins can be applied to new protein sequences in order to functionally characterise them. The Structural Classification of Proteins (SCOP) database is a largely manual classification of protein structural domains based on similarities of their structures and amino acid sequences. ModBase is a database of annotated comparative protein structure models, containing models for more than 3.8 million unique protein sequences.

Multiple choice

Which of the following databases gives information of interactions between environmental chemicals and gene products and their relationships to diseases?

  1. TRANScription FACtor database

  2. CT Database

  3. P-HI database

  4. PhenomicDB

  5. Dryad
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Comparative Toxicogenomics Database (CTD) describes relationships between chemicals, genes and human diseases. CTD promotes understanding about the effects of environmental chemicals on human health by integrating data from curated scientific literature to describe chemical interactions with genes and proteins and associations between diseases and chemicals and diseases and genes/proteins.

Multiple choice

_____________ selects mysqldatabase.

  1. mysql_select_database

  2. mysql_select_db

  3. mysql_connect_db

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

mysql_select_db is the deprecated PHP MySQL function that selects the active database for subsequent queries. After connecting to MySQL with mysql_connect, you must select a specific database before running queries. Option A is a common but incorrect variation of the function name.