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

Which of the following approaches in OODBMS architecture is the one in which the client processes 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
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This approach in OODBMS architecture is the one in which the client processes of OODBMS have an interaction with a network file service for reading and writing database pages.

Multiple choice

Which of the following DBMS software modules verify parse queries, DML retrieval statements and database update statements and also check the catalog to verify whether all the schema names referenced in these statements are valid?

  1. DDL compilers

  2. Query and DML compilers

  3. Query and DML optimiser

  4. Authorisation and security checking

  5. Query and DML parser
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Query and DML parser verify parse queries, DML retrieval statements and database update statements and also check the catalog to verify whether all the schema names referenced in these statements are valid.

Multiple choice

Which of the following components of distributed database management system should be there with every data requesting workstation so as to receive and process the request for data, both local and remote?

  1. Workstations

  2. Network hardware and software

  3. Data processor

  4. Transaction processor

  5. Replicated data management
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This component of distributed database management system should be there with every data requesting workstation so as to receive and process the request for data, both local and remote.

Multiple choice

Which of the following views in Three Schema Architecture is the information model of the enterprise and contains the view of the whole enterprise without any concern for the physical implementation?

  1. External view

  2. Conceptual view

  3. Internal view

  4. Physical view

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

This view in Three Schema Architecture is the information model of the enterprise and contains the view of the whole enterprise without any concern for the physical implementation.

Multiple choice

Which of the following techniques used for denormalisation is the one in which the database table is split by rows, due to which the number of records per table will be reduced?

  1. Duplicate data

  2. Summary data

  3. Horizontal partitioning

  4. Vertical fragmentation

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

This technique used for denormalisation is the one in which the database table is split by rows, due to which the number of records per table will be reduced.

Multiple choice

Full form of DDL

  1. Data Dictionary language

  2. Data derival language

  3. Data Definition language

  4. Data directed language

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

Concept

Multiple choice

Which of the following is/are the correct statement is database programming?

  1. A SQL GRANT is a command used to provide access or privileges on the database objects to the users.

  2. A System privileges allows the user to CREATE, ALTER, or DROP the database objects.

  3. The REVOKE command is used to remove the user access rights or privileges to the database objects.

  4. All of the above

  5. Only (1) and (2)
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Yes, all are correct.

Multiple choice

Which of these refers to the centralized repository of information about data?

  1. Semantic spectrum

  2. Record

  3. Data hierarchy

  4. Metadata repository

  5. Controlled vocabulary
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A data dictionary, or metadata repository, as defined in the IBM Dictionary of Computing, is a centralized repository of information about data such as meaning, relationships to other data, origin, usage and format.

Multiple choice

____________ model in system development is an approach to data modelling that includes information about the meaning of the data and that allows a better abstract model to be produced.

  1. Data flow

  2. Object

  3. Inheritance

  4. Semantic

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

This model in system development is an approach to data modelling that includes information about the meaning of the data and that allows a better abstract model to be produced.