CS430 Midterm 1 Exam Questions and Answers

CS430 Midterm 1 Exam Questions and Answers Match the component of a DBMS to its associated responsibility. A. Query optimizer B. File and access methods layer C. Buffer manager D. Disk space manager E. Transaction manager ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER 2024 Page 2/16 F. Lock manager G. Recovery manager - Ans:-A. Uses information about how the data is stored to produce an efficient execution plan for evaluating the query. B. Supports the concept of a file, which in a DBMS is a collection of pages or a collection of records. C. Brings pages in from disk to memory as needed in response to read requests. D. Deals with management of space on disk, where the data is stored. E. Ensures that transactions request and release locks according to a suitable locking protocol. F. Keeps track of requests for locks and grants locks on database objects when they become available. ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER 2024 Page 3/16 G. Responsible for maintaining a log and restoring the system to a consistent state after a crash. The types of access for a data manipulation language are: - Ans:-Insertion and deletion of data Retrieval of information What are the components of the query processor? - Ans:-DML Compiler DDL Interpreter Query Evaluation Engine A transaction is a single operation that performs multiple logical functions within a database. - Ans:- False A data dictionary contains ____________________, data about data. - Ans:-metadata Match the database users to their definition. ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER 2024 Page 4/16 A. Naive Users B. Application Programmers C. Sophisticated / Specialized Users D. Database Administrators - Ans:-A. Unsophisticated users accessing the system through application programs. B. Computer professionals who write packages that facilitate access for end users. C. Users who interact with the systems and/or write specialized database applications D. Professionals that design and maintain the database. A query is a statement requesting the retrieval of information. - Ans:-True ©GRACEAMELIA 2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED FIRST PUBLISH OCTOBER 2024 Page 5/16 A language in which a user specifies a database schema is called: - Ans:-A data definition language Entities are described in a database by which of the following? - Ans:-A set of attributes One very important advantage of using a DBMS is that it offers data independence. This is defined as what? - Ans:-Application programs are insulated from changes in the way data is structured and stored. An object-oriented data model permits the specification of data where individual data items of the same type many have different sets of attributes. - Ans:-False A relationship in a database is which of the following? - Ans:-An association between entities Which of the following are the data structures the storage manager implements as part of the physical system? - Ans:-Data Dictionary Indices Data Files In which phases does the design move from an abstract data mode to the design of the database - Ans:-Physical Design Phase