Database Management System - DBMS Multiple Choice Questions and Answers

51. The overall description of a database is called………………

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

52. Disadvantages of File systems to store data is:

1. Data isolation
2. Data redundancy and inconsistency
3. Difficulty in accessing data
4. All of the above

53. Which is the central component of the DBMS software that can also be termed as the database control system?

1. Data sharing
2. Data consistency
3. Data integration
4. Data manager

54. Data are stored in………………as database:

1. Database
2. Data files
3. Data dictionary
4. Data administrator

55. Transaction is an action used to perform some manipulation on data stored in the………………

1. Database
2. Memory
3. Record
4. All of these

56. Which is stored information about description of data in the database:

1. Database
2. Data files
3. Data dictionary
4. Data administrator

57. In an Entity-Relationship Diagram Rectangles represents

1. Database
2. Entity sets
3. Attributes
4. Tables

58. DBA stands for:

1. Database backup
2. Database maintenance
3. Database administrator
4. Database designer

59. Which is the person responsible for overall control f the database system:

1. DBA
2. DDL
3. DBMS
4. SDL

60. ………... is a translates into low-level instruction that a query processor understands:

1. DBS
2. DBA
3. DBMS
4. DDL compiler