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
Data Structure
C
Instance of Database
D
Database Schema
Question 2
Overall design of the database is called as _________.
A
Database Instance
B
Database Schema
C
Database Abstraction
D
None of these
Question 3
Database supports _______ types of database schema's.
A
4
B
2
C
1
D
3
Question 4
Which of the following are valid types of Database Schema's ?
A
Practical Schema
B
Physical and Logical Schema
C
Logical Schema
D
Physical and Practical Schema
E
Physical Schema
Question 5
Which of the following schema is present at highest level ?
A
Sub-Schema
B
None of these
C
Logical Schema
D
Physical Schema
Question 5 Explanation: 
Sub-Schema is at highest level. i.e at View Level
There are 5 questions to complete.