Database Management System Quiz

What is the main purpose of a database management system (DBMS)?

• To create and manage files on a computer system

• To write computer programs for data access

• To store and manage data in a structured and efficient way

• To access data directly from the storage device

What is a database schema?

• The interface between the database and end users

• A mechanism to retrieve data from files

• The design of a database that represents the structure and relationships among the tables

• A set of programs to access, modify, and retrieve data from a database

What is a downside of a file system in managing data?

• Data redundancy

• Controlled data sharing

• Data isolation

• Difficulty in data access

What is data inconsistency in a school's student record system?

• When student data are stored in a specific format or structure

• When same student data maintained in different places do not match

• When student records are generated by different people at different times

• When student data are accessed through school application programs

What is the purpose of GUID in the GUARDIAN table for students like Aanya, Naira, and Rahul?

• To relate the guardian's data with the student's data

• To store the guardian's address

• To maintain the guardian's phone number

• To identify the student's roll number

What is the purpose of a database schema?

• To organise related data in a database

• To create and manage databases

• To maintain data in a file system

• To provide an abstract view of the data

What is the main advantage of using a database management system for Ananya, Sanya, and Eshaan?

• Data redundancy

• Data isolation

• Efficient and easy management of data

• Controlled data sharing

What is the purpose of a database system?

• To write computer programs for data access

• To access data directly from the storage device

• To store and manage data in a structured and efficient way

• To create and manage files on a computer system

What is a downside of a file system in managing data?

• Data redundancy

• Data inconsistency

• Data isolation

• Difficulty in data access

What is the purpose of a database view?

• To maintain data in separate files on a computerized system

• To create and manage databases

• To provide an abstract view of the data

• To write application programs for data access