DBMS Quiz

What does DBMS stand for?

• Database Management System

• Data Base Management Software

• Database Management Software

• Data Base Management System

Which of the following is NOT a characteristic of the database approach?

• Data redundancy

• Support of multiple views

• Insulation between programs and data

• Self-describing nature

What type of data does a DBMS primarily manage?

• Structured data

• Semi-structured data

• All of the above

• Unstructured data

What is the purpose of a database schema?

• To manage user access

• To define the structure of the database

• To store data

• To perform data manipulation

Which level of the three-schema architecture describes the physical storage structure?

• External level

• Conceptual level

• User level

• Internal level

What is logical data independence?

• Changing the conceptual schema without affecting external schemas

• Changing the internal schema without affecting the conceptual schema

• Changing the external schema without affecting the conceptual schema

• Changing the physical storage without affecting the database

Which of the following is a type of data manipulation language (DML)?

• Storage Definition Language

• High-level DML

• View Definition Language

• Data Definition Language

What is a weak entity set?

• An entity set with a key attribute

• An entity set that has multiple relationships

• An entity set without any key attributes

• An entity set that depends on another entity

In an ER diagram, how is a relationship represented?

• Diamond

• Oval

• Rectangle

• Circle

What does a multivalued attribute represent in an ER diagram?

• Rectangle

• Dashed oval

• Double oval

• Single oval