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

Which of the following tasks in data transformation includes a large variety of rudimentary conversions of single fields for two primary reasons; one to standardise among data extractions from disparate source systems, and the other to make the fields usable and understandable to the users?

  1. Selection

  2. Splitting / Joining

  3. Conversion

  4. Summarization

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

This task in data transformation includes a large variety of rudimentary conversions of single fields for two primary reasons; one to standardise among the data extractions from disparate source systems, and the other to make the fields usable and understandable to the users.

Multiple choice

Which of the following is widely used in data warehousing environment, which typically have large amounts of data and ad hoc queries, but a low level of concurrent DML transactions?

  1. B-tree index

  2. Bitmap index

  3. View

  4. Clustered index

  5. B+-tree
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Bitmap indexes are widely used in data warehousing environment, which typically have large amounts of data and ad hoc queries, but a low level of concurrent DML transactions.

Multiple choice

Which of the following is not true about data dictionary in software engineering?

  1. It contains the representation and the definition of the data elements.

  2. It is created during the requirement analysis phase in SDLC (Software Development Life Cycle).

  3. It provides the relationship between the entities.

  4. It describes the database or collection of databases.

  5. None of the above
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

All of the above are true statements.

Multiple choice

Which of the following is the role of system administrator?

  1. Verification/validation of the data

  2. Installation, configuration and maintain the database

  3. Develop a plan to back up the database and recovery routines

  4. All of the above

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

Yes, all of the above are the roles of a system administrator.

Multiple choice

Which of the following statement(s) is/are false?

  1. Data Flow Diagram shows the data transfer between the entities in the system.

  2. A DFD shows a lower level view of the system.

  3. DFD is made by a software analyst of designer.

  4. DFD shows the functionality of the system.

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

This is a false statement as a DFD shows a higher level view of a system as it shows the actual transfer of the data in the system whereas a flow chart shows a lower level view of the system as it shows only the data transfer activities in the system and not the transfer of the data.

Multiple choice

Which of the following statement(s) is/are false?

  1. A physical DFD is used to describe the set of items that appears in each level.

  2. A physical DFD can have duplicate or redundant data.

  3. A logical DFD can not have duplicate data or redundancy.

  4. A logical DFD shows the data flows to operate the system.

  5. None of the above
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Yes, all of the above are the true statements.