TestUstad

Free Database Systems MCQs with Answers

49 Database Systems MCQs from Software Engineering, each with the correct answer and a written explanation of why it is correct. Free and unlimited, with no account needed.

Last updated

49 questions · page 3 of 3

41. Which part of a computer helps to store information ?

  • A. Disk drive
  • B. Keyboard
  • C. Monitor
  • D. Printer

Explanation: A disk drive stores information on magnetic or solid-state media and allows it to be retrieved later.

Read the full explanation →
Correct answer: Disk drive

42. A data warehouse is which of the following ?

  • A. Contains only current data
  • B. Organised around important subject areas
  • C. Contains numerous naming conventions and formats
  • D. Can be updated by end users

Explanation: A data warehouse is organised around major subject areas such as sales, customers, or products to support analysis.

Read the full explanation →
Correct answer: Organised around important subject areas

43. The letter and number of the intersecting column and row is the__________________?

  • A. cell address
  • B. cell coordinates
  • C. cell position
  • D. cell location

Explanation: A cell address combines the column letter and row number, such as B4 or C10, to identify a spreadsheet cell.

Read the full explanation →
Correct answer: cell address

44. _________________is the maximum amount of data that can be stored on a storage medium ?

  • A. Magnetic storage
  • B. Optical storage
  • C. Solid-state storage
  • D. Storage capacity

Explanation: Storage capacity is the maximum amount of data a storage medium can hold, usually measured in bytes such as GB or TB.

Read the full explanation →
Correct answer: Storage capacity

45. Which of the following is a data problem ?

  • A. hardware problem
  • B. record organisation problems
  • C. heavy computational demands
  • D. loss of comments

Explanation: Record organisation is a data problem because the structure, format, or arrangement of stored records can hinder processing and…

Read the full explanation →
Correct answer: record organisation problems

46. ETL stands for____________________?

  • A. Data Extraction Transformation & Loading
  • B. Data Execution Transformation & Loading
  • C. Extraction Transformation & Loading
  • D. Execution Transformation & Loading

Explanation: ETL means Extract, Transform, Load: data is taken from sources, converted into the required form, and loaded into a target store such as a…

Read the full explanation →
Correct answer: Data Extraction Transformation & Loading

47. Who designs and implement database structures ?

  • A. Programmers
  • B. Project managers
  • C. Technical writers
  • D. Database administrators

Explanation: Database administrators design, implement, maintain, and secure database structures.

Read the full explanation →
Correct answer: Database administrators

48. The records of each patient that is receiving or has received treatment resembles which security concept ?

  • A. Asset
  • B. Threat
  • C. Vulnerability
  • D. Control

Explanation: Patient treatment records have value to the healthcare organisation and therefore qualify as information assets requiring protection.

Read the full explanation →
Correct answer: Asset

49. Which of the following 4GLs invented at IBM and subsequently adopted by ANSI and ISO as the standard language for managing structured data?

  • A. SQL
  • B. PROLOG
  • C. C
  • D. JAVA

Explanation: SQL, originally developed at IBM, became the widely adopted standard language for defining, querying, and manipulating structured…

Read the full explanation →
Correct answer: SQL
Start Free Database Systems Practice MCQs Test