Database Concepts and Architecture Multiple Choice Questions and Answers 1 pdf eBooks Download

Learn database concepts and architecture multiple choice questions (MCQs), DBMS test 1 online for exams. 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 quiz, online study guide has helping 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 for viva exam preparation and job's interview questions. Study to learn schemas instances and database state quiz questions to practice online MCQs for competitive 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