Database Questions ch1-2 PDF

Database Questions: Ch-(1,2) 1. What is a database? a) A software system b) A collection of related data c) A programming language d) A hardware component Correct What does DBMS stand for? a) Data Backup Management System b) Database Manipulation System c) Database Management System d) Data Busin...

Database Questions: Ch-(1,2) 1. What is a database? a) A software system b) A collection of related data c) A programming language d) A hardware component Correct What does DBMS stand for? a) Data Backup Management System b) Database Manipulation System c) Database Management System d) Data Business Management Software 2. Which of the following is NOT a limitation of file-based systems? a) Separation and isolation of data b) Duplication of data c) Data independence d) Data dependence 3. What is a mini-world in database context? a) A small database b) A toy model of a database c) A representation of some aspects of the real world d) A miniature computer system 4. What is a transaction in database terms? a) A financial operation b) An executing program or process that includes database accesses c) A table in the database d) A user interface for the database 5. Which of the following is NOT a typical type of database? a) Multimedia database b) Geographic information system c) Data warehouse d) File-based system 6. What is meta-data? a) Big data b) Data about data c) Unstructured data d) Raw data 7. What is data abstraction in database systems? a) Hiding storage details and presenting a conceptual view of the database b) Extracting data from the database c) Compressing data to save storage space d) Deleting unnecessary data from the database 8. What is OLTP? a) Online Learning and Teaching Platform b) Offline Data Processing c) Online Transaction Processing d) Operational Level Testing Procedure 9. Who is responsible for authorizing access to the database and monitoring its use? a) End-users b) Database designers c) Database administrators d) System analysts 10. What is a "canned transaction"? a) A cancelled transaction b) A stored food item c) A well-defined, predetermined database function d) A corrupted data entry 11. Which of the following is NOT an advantage of using the database approach? a) Controlling redundancy b) Restricting unauthorized access c) Providing multiple user interfaces d) Increasing data duplication 12. What is the purpose of a recovery subsystem in a DBMS? a) To create backups of the database b) To restore the database to a consistent state after a failure c) To optimize query performance d) To manage user access rights 13. What does "program-data independence" mean? a) Programs and data are stored separately b) Programs can function without data c) Changes in data structure don't require changes in programs that access the data d) Each program has its own dedicated data 14. Which of the following is NOT a category of end-users? a) Casual users b) Naive or parametric users c) Sophisticated users d) Database administrators 15. What is a view in database systems? a) A graphical representation of data b) A subset of the database that appears as a virtual table c) A user interface for the database d) A backup of the database 16. What is concurrency control in a DBMS? a) Controlling user access to the database b) Managing simultaneous access to the database by multiple users c) Controlling the speed of database operations d) Managing the order of transactions 17. Which of the following is NOT a main characteristic of the database approach? a) Self-describing nature b) Insulation between programs and data c) Data abstraction d) Data dependence 18. What is the primary role of a database designer? a) To maintain the database b) To use the database for queries and reports c) To define the content, structure, and constraints of the database d) To manage database security 19. What is an integrity constraint in a database? a) A limitation on database size b) A rule that the database must comply with c) A security measure to prevent unauthorized access d) A performance optimization technique 20. Which of the following is NOT a typical DBMS functionality? a) Defining data types and structures b) Manipulating the database c) Processing and sharing by concurrent users d) Designing the user interface 21. What is the purpose of indexing in databases? a) To sort the data alphabetically b) To compress the data c) To provide efficient access to data d) To encrypt sensitive information 22. In what situation might using a DBMS be unnecessary? a) When dealing with complex, constantly changing data b) When multiple users need to access the data simultaneously c) When the database and applications are simple and well-defined d) When data integrity is crucial 23. What is the difference between data and information? a) There is no difference; the terms are interchangeable b) Data is raw facts, while information is processed data with meaning c) Information is raw facts, while data is processed information d) Data is always digital, while information can be analog 24. What is a data model? a) A physical representation of the database b) A conceptual representation of the data in a database c) A backup of the database d) A user's view of the database 25. Which of the following is NOT a type of database user mentioned in the text? a) Database administrator b) Naive user c) Sophisticated user d) Database engineer 26. What is the purpose of a database catalog? a) To store customer information b) To keep track of database backups c) To store metadata about the database structure d) To log all database transactions 27. What does "support of multiple views of the data" mean? a) The ability to view the database on multiple devices b) The ability for different users to see different subsets or representations of the database c) The ability to create multiple copies of the database d) The ability to view the data in multiple formats (e.g., tables, graphs) 28. What is a stand-alone user in the context of database systems? a) A user who works offline b) A user who maintains a personal database using packaged applications c) A user who doesn't need any help using the database d) A user who only reads data from the database 29. Which of the following is an advantage of using the database approach? a) Increased data redundancy b) Decreased data sharing c) Applying integrity constraints d) Simplified system architecture