Database Concepts and Architecture Multiple Choice Questions 1 PDF Download

Learn database concepts and architecture multiple choice questions (MCQs), DBMS test 1 for online 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 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 with online learning MCQs for competitive exam preparation test.

MCQ on Database Concepts and Architecture Quiz PDF Download Test 1

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

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

A

MCQ. The database system which supports the 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 the three-tier architecture, the intermediate layer between database and client servers is classified as

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

C

MCQ. The software whose main function is to provide the access the database from remote location with the 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. The form of data model in which the concepts provided are useful for end users and are also close to the 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