DBMS_MCQ

The data present in the database are

• Interrelated
• unrelated
• Complex
• numerical

Data Redundancy may lead to

• Inconsistency
• Failure
• isolation
• consistency

Hiding certain details to simplify the users interaction with the system is called

• Abstraction
• Inheritence
• Encapsulation
• overriding

The lowest level of abstraction that describes how the data are actually stored is

• Physical Level
• Logical Level
• View Level
• user Level

The level of abstraction that describes what data are stored in the database

• Logical Level
• Physical Level
• View Level
• user Level

The highest level of abstraction that describes only part of the entire database

• View Level
• Physical Level
• Logical Level
• Conceptal Level

The collection of information stored in the database at a particular moment is called

• Instance
• Schema
• table
• relation

The Overall design of the database is called

• Schema
• Instance
• table
• relation

A collection of conceptual tool for describing data ,data relation ship ,semantics and consistency is called

• Data Model
• Design
• Package
• Program

The langusge which enables the users to access or manipulate data

• DML
• DDL
• DCL
• TCL