DBMS Concepts and Architecture Mcqs

Our collections of Multiple choice questions and answers focuses on study of DBMS Concepts and Architecture. These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate DBMS Concepts and Architecture comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. Concepts and Architecture Mcqs

State in database management system which satisfies constraints and specified schema structure is classified as

Valid state

Extension state

Intension state

Attribution state

Database system which supports majority of concurrent users is classified as

Multiuser system

Multi-function system

Multi transaction system

Client and disk server system

In three-tier architecture, intermediate layer between database and client servers is classified as

Functional server

Transaction server

Application server

Disk server

Software whose main function is to provide access database from remote location with help of work stations, local PCs and computer terminals is called

Module software

Communications software

Host software

Client software

Form of data model in which concepts provided are useful for end users and are also close to way it is stored in computer system is called

Representational data models

Implementation data models

Clientele data models

Both a and b

Objects in DBMS belongs to same structure and behaves in same way are considered as

Same class objects

Different structure objects

Behavioral structure objects

Classical structure objects

In relational database management system, server is classified as

SQL server

SQT server

SQR server

ODBC server

Architecture of database in which characteristics such as program insulations, multiple user support and use of catalogs are achieved is classified as

Multiple-schema architecture

Single-schema architecture

Two-schema architecture

Three-schema architecture

Data communication system and database management system is also considered as


MS ⁄ DC system

BM ⁄ CS system

All of above

Form of data model which focuses concepts in same way as data stored in computer system is classified as

Low level data models

High level data models

Dynamic data models

Medium level data models

Type of legacy data model in which data is represented as record types and limited one to many relationships is called

Network relational models

Legacy network model

Hierarchy models

Network model

Type of server in two-tier architectures which provides data to client stored on disk pages is called

Transaction server

Functional server

Disk server

Data server

In categories of data modeling, low level data models are also called

Conceptual data models

Physical data models

Triggered data models

Logical data models

Concepts of data models that are only useful to computer specialists rather than end users of programs are classified as

Triggered data models

Logical data models

Conceptual data models

Physical data models

Non-procedural language and procedural language are classified as types of

Data manipulation language

Internal mapping language

Logical path language

External mapping language

Scroll to Top