DBMS MCQ : Instance and Schema (Multiple Choice Questions)


Question 1
Collection of information stored in database at particular instance of time is called as __________.
A
Objects in Database
B
Instance of Database
C
Database Schema
D
Data Structure
Question 2
Overall design of the database is called as _________.
A
Database Schema
B
Database Abstraction
C
None of these
D
Database Instance
Question 3
Database supports _______ types of database schema's.
A
4
B
3
C
2
D
1
Question 4
Which of the following are valid types of Database Schema's ?
A
Practical Schema
B
Physical and Logical Schema
C
Physical Schema
D
Physical and Practical Schema
E
Logical Schema
Question 5
Which of the following schema is present at highest level ?
A
Physical Schema
B
Logical Schema
C
None of these
D
Sub-Schema
Question 5 Explanation: 
Sub-Schema is at highest level. i.e at View Level
There are 5 questions to complete.