Table of Content

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

Pages: Page 1, Page 2, Page 3