DBMS Learning Notes & Technology Articles

Database Concepts and Architecture Multiple Choice Questions Test 1 Tests pdf Download

Practice database concepts and architecture multiple choice questions (MCQs), DBMS test 1 online to learn. Practice schemas instances and database state MCQs questions and answers on schemas instances and database state, database management system classification, three schema architecture, database system environment, data models categories with answers. Free database concepts and architecture study guide has answer key with choices as extension state, valid state, intension state and attribution state of multiple choice questions (MCQ) as state in database management system which satisfies constraints and specified schema structure is classified as to test learning skills. Study to learn schemas instances and database state quiz questions to practice MCQ based online exam preparation test.

MCQ on Database Concepts and Architecture Quiz pdf Download Test 1

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

  1. valid state
  2. extension state
  3. intension state
  4. attribution state

A

MCQ. Database system which supports majority of concurrent users is classified as

  1. multiuser system
  2. multi-function system
  3. multi transaction system
  4. client and disk server system

A

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

  1. functional server
  2. transaction server
  3. application server
  4. disk server

C

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

  1. module software
  2. communications software
  3. host software
  4. client software

B

MCQ. 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

  1. representational data models
  2. implementation data models
  3. clientele data models
  4. both a and b

D

DMCA.com Protection Status