Database 1

Major components of Database Systems Environment are:

• Software

• People

• Procedures

• All

Application logic consists of _______ components.

• one

• two

• three

• four

________ is responsible for data storage & retrieval from physical storage devices.

• Presentation logic

• Processing logic

• Storage logic

• Input

In Two-tier Client Server, client (tier 1) manages user interface and runs applications.

• TRUE

• FALSE

There are three types of data independence.

• TRUE

• FALSE

ANSI-SPARC Architecture consists of ___________ levels.

• 1

• 2

• 3

• 4

______________ refers to immunity of conceptual schema to changes in the internal schema.

• Logical Data Independence

• Physical Data Independence

User’s view of the database.

• External Level

• Conceptual Level

• Internal Level

Community view of the database.

• External Level

• Conceptual Level

• Internal Level

Describe how data are to be represented and stored in the database.

• External Level

• Conceptual Level

• Internal Level