DBMS Day 2

Which of the following data models represents data in a tree-like structure?

• Relational model

• Network model

• Hierarchical model

• Object-oriented model

Which of the following data models is based on the mathematical set theory and uses tables to store data?

• Relational model

• Network model

• Hierarchical model

• Object-oriented model

What is the basic client/server architecture, one has to deal with?

• Large number of PCs

• Web servers

• Database Servers

• All of the above

How many types of DBMS architectures are there?

• 1

• 2

• 3

• 4

What is TRUE about 1-tier architecture?

• It is directly not available to the user

• Changes are not done on the database

• No handy tool is provided for the end user

• It is not used for the development of local application

Which type of data independence allows changes in the conceptual schema without affecting external schemas?

• Physical data independence

• Logical data independence

• External data independence

• Internal data independence

What is a schema?

• A way of representing the structure of a database

• A way of accessing data in a database

• A way of backing up data in a database

• A way of managing data in a database

What is a data model?

• A way of representing data in a database

•  A way of managing data in a database

• A way of accessing data in a database

• A way of backing up data in a database

Which layer of DBMS architecture is responsible for communication with the end-users?

• Physical layer

• Logical layer

• External layer

• Storage layer

Which component of the DBMS architecture provides services to the users and applications?

• Storage Manager

• Query Processor

• Data Definition Language (DDL)

• Data Manipulation Language (DML)