Database Management System MCQ : Introduction, file system : Link1
Compiler Construction MCQ & Answers
Are you worried about the answers to Database Management System questions :/introduction to DBMS, File system vs DBMS? We have arranged the Show Answer button under the each question. Candidates can click on it to know the right option among the given alternatives. Furthermore, the applicants can check our web portal @ www.totalmcq.com to take part in more MCQ on various subject. Wish, the given information about the Database Management System MCQ will helpful to the advance and can learn the various types of questions and answers.
Q.1. Database is collection of------------.
A. Programs
B. Modules
C. Data D. None of the above
Q.2.-------is collection of interrelated data and set of program to access them.
A. Database Management System
B. Programming language
C. Database D. Data Structure
Q.3. DBMS should provide following feature(s)---------.
A. Safety of the information stored
B. Protect data from system crash
C. Authorized access D. All of the above
Q.4. Which of the following is the example of DBMS?
A. Foxpro
B. Access
C. Oracle D. All of the above
Q.5. Before use of DBMS information was stored using ---------.
A. File Management System
B. Cloud Storage
C. Data System
D. None of the above
Q.6. The DBMS acts as an interface between what two components of an database system?
A. Database and User
B. Data and Database
C. Database and SQL
D. Database and SQL
Q.7. The DBMS acts as an interface between what two components of an enterprise-class database system?
A. Database application and the database
B. Data and the database
C. The user and the database application
D. Database application and SQL
Q.8. The following are components of a database except-------
A. user data
B. Reports
C. metadata
D. indexes
Q.9. An application where only one user accesses the database at a given time is an example of-------------.
A. single-user database application
B. multiuser database application
C. data mining database application
D. e-commerce database application
Q.10. The following are functions of a DBMS except-------.
A. creating and processing forms
B. creating databases
C. processing data
D. administrating databases
Q.11. The DBMS is the software that interacts with the ……………….and thedatabase.
A. User’s system database
B. User’s system programs
C. User’s application programs D. None of the above
Q.12. An advantage of the database management approach is--------
A. Data is dependent on programs.
B. Data redundancy increases.
C. Data is integrated and can be accessed by multiple programs.
D. None of the above.
Q.13. Which two files are used during operation of the DBMS?
A. Query languages and utilities
B. Data dictionary and transaction log
C. DML and query language
D. None of the above
Q.14. Disadvantages of File systems to store data is: ---------.
A. Data isolation
B. Data redundancy and inconsistency
C. Difficulty in accessing data
D. All of the above
Q.15. DBMS is a collection of..........that enables user to create and maintain a database.
A. Keys
B. Translators
C. Program D. Language Activity