Table of Content

DBMS MCQ : Instance and Schema (Multiple Choice Questions)


Question 1
Map of concepts and their relationships is represented by __________ Schema.
A
None of these
B
Logical Schema
C
Physical Schema
D
Conceptual Schema
Question 1 Explanation: 
Conceptual Schema and Sub-Schema are both are equal.
Question 2
A map of entities and their attributes and relations is represented by ____________.
A
None of these
B
Physical Schema
C
Conceptual Schema
D
Logical Schema
Question 3
The environment of database is said to be _____________.
A
Database Schema
B
Database Instance
Question 4
A database instance is a set of memory structure and background processes that access a set of database files.
A
False
B
True
Question 5
Arrange the database Schema's in Appropriate order -
  1. Logical Schema
  2. Conceptual Level
  3. Physical Level
A
2 3 1
B
1 2 3
C
3 2 1
D
3 1 2
There are 5 questions to complete.

Pages: Page 1, Page 2, Page 3