Database Concepts and Architecture Multiple Choice Questions 1 PDF Download

Learn database concepts and architecture multiple choice questions (MCQs), DBMS test 1 for online course prep 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 for online information technology degree test prep.

Free database concepts and architecture quiz online, study guide has multiple choice question on state in database management system which satisfies constraints and specified schema structure is classified as with options extension state, valid state, intension state and attribution state to test online e-learning skills for viva exam prep and job's interview questions with answers key. Study to learn schemas instances and database state quiz questions with online learning 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