DBMS Quiz 1

What does DIKW in the DIKW Pyramid stand for?

• Data, Information, Knowledge, Wisdom

• Data, Integration, Knowledge, Work

• Data, Intelligence, Knowledge, Wisdom

• Database, Information, Knowledge, Workflow

What is a database?

• A software application for document processing

• An organized collection of interrelated data

• A hardware device for storing large files

• A programming language

Which database system does Facebook use for storing user information and timeline details?

• Cassandra

• MySQL

• Haystack

• Varnish

What type of data is stored in a structured format?

• Word Documents

• XML files

• SQL Tables

• Audio files

Which of the following is NOT an advantage of a DBMS?

• Controlling redundancy

• Data inconsistency

• Concurrent access

• Data integrity

Which of the following is NOT a type of data organization?

• Structured

• Semi-structured

• Unstructured

• Mixed-structured

Which of the following is NOT a disadvantage of file systems compared to DBMS?

• Data redundancy

• Data inconsistency

• Enhanced security

• Unshareable data

What is a database schema?

• A database backup file

• The skeleton structure that represents the logical view of the database

• A snapshot of the database

• A data manipulation technique

What is a database instance?

• A programming language

• A snapshot of the database at a specific moment

• The physical storage of a database

• A user interface for databases

How many levels are there in the Three-Schema Architecture?

• One

• Two

• Three

• Four