Advance Database Systems 1st Quiz

What is a state where every relation in a database remains consistent?

• Consistency

• Less Redundancy

• Isolation of data

• Relation-based

What stores data in such a way that it becomes easier to retrieve, manipulate, and produce information?

• Database

• DBMS

• Information

• Datasystems

What is a collection of related data and data is a collection of facts and figures that can be processed to produce information?

• Data

• Database

• DBMS

• RDBMS

What is D in ACID stands for?

• Di pinili

• Durability

• Durable

• Data

DBMS supports multi-user environment and allows them to access and manipulate data in parallel.

• TRUE

• FALSE

What DBMS characteristic that allows entities and relations among them to form tables?

• Relation-based tables

• Real-world entity

• Less redundancy

• Consistency

What type of user maintain the DBMS and are responsible for administrating the database?

• Administrator

• End-user

• Designer

What type of users are those who actually reap the benefits of having a DBMS?

• Administrator

• Designer

• End-user

DBMS offers methods to impose constraints while entering data into the database and retrieving the same at a later stage

• TRUE

• FALSE

A modern DBMS is less realistic and uses real-world entities to design its architecture

• TRUE

• FALSE