wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Three level architecture

Total questions: 15

Worksheet time: 5mins

Name
Class
Date
1.

DBTG developed proposal for DB

a)

1970

b)

1975

c)

1971

2.

Entity attributes relationship are defined at

a)

External level

b)

Conceptual level

c)

Internal level

3.

Extension is performed after——— of database has been finalized

a)

Intension

b)

Structure

c)

Storage of DB

4.

Sub schemas is another name of

a)

Conceptual schemas

b)

External schemas

c)

Internal schemas

5.

Virtual data is observed at

a)

External level

b)

Conceptual level

c)

Internal level

6.

Internal level is responsible to store data on

a)

Storage media

b)

Files orgnization

c)

Data structure

d)

All

7.

Conceptual level contain

a)

Definition of data

b)

Structure of data

c)

Type of data

d)

All

8.

Three level are depicted by three models known

a)

External schemas

b)

Internal schemas

c)

Three level schemas

d)

Conceptual schemas

9.

Database schemas is also called

a)

Extension of database

b)

Intension of database

c)

Three level schemas

10.

Space utilisation is performed by

a)

Encoding scheme

b)

Data compression

c)

Indexing

11.

Conceptual level is described in

a)

External schemas

b)

Conceptual schemas

c)

Internal schemas

12.

Permanent structure of database is

a)

Extension of database

b)

Intension of database

c)

Three level schemas

13.

Database instance is also called

a)

Extension of database

b)

Intension of database

c)

Three level schemas

14.

Security can be maintained by

a)

Password

b)

DBA

c)

Data encryption

15.

Data stored in

a)

Binary format

b)

Operating system

c)

Storage device