Database Management System (DBMS)

41. ___________ is a collection of application programs that interacts with the database along with DBMS:

  1. A database system
  2. A database application
  3. Both
  4. None

Correct answer: (A)
A database system

42. In which services the processes of database management and data management are complementary:

  1. Database associated
  2. Database administrator
  3. Database application
  4. Database management system

Correct answer: (D)
Database management system

43. ACID stands for:

  1. Atomicity, consistency, isolation, and durability
  2. Atomicity, command, integrity, and data
  3. Atomicity, control, integrated, and direct
  4. None of these

Correct answer: (A)
Atomicity, consistency, isolation, and durability

44. A DBMS provides users with the conceptual representation of:

  1. Register
  2. Data
  3. Logical view
  4. Physical view

Correct answer: (B)
Both

45. Which structure of data clearly is one of the main features of the database approach:

  1. Logical view
  2. Physical view
  3. Both
  4. None

Correct answer: (C)
Physical view

46. A ___________ view of data expresses the way a user thinks about data

  1. Logical view
  2. Physical view
  3. Both
  4. None

Correct answer: (A)
Logical view

47. A physical view of data refers to the way data is handled at a ___________ its storage and retrieval:

  1. High level
  2. Low level
  3. Medium level
  4. All of these

Correct answer: (B)
Low level

48. In logical and physical view of data the set of principles that defines a data model may be divided into how many parts:

  1. 1
  2. 2
  3. 3
  4. 4

Correct answer: (C)
3

49. In logical and physical view of data the set of principles that defines a data model may be divided into which part:

  1. Data definition
  2. Data manipulation
  3. Data integrity
  4. All of these

Correct answer: (D)
All of these

50. The overall description of a database is called ___________:

  1. Data definition
  2. Data manipulation
  3. Data integrity
  4. Database schema

Correct answer: (D)
Database schema

Page 5 of 45