1. Which of the following are components of the Storage Manager: a) Authorization and integrity manager b) Transaction Manager c) File Manager d) Buffer Manager   All of these   c   c,d   None of these   Hint Half-n-half Clue   2. One of the requirements of transaction management is that after the successful execution of the transaction, the new values in the database must persist even if there is a system failure. This requirement is termed as _______.   atomicity   isolation   durability   consistency   Half-n-half Clue   3. The security features of the database are set up by the _______.   Online Users   Application Programmer   Database Administrator   Naive Users   Half-n-half Clue   4. The collection of data stored in a database at a particular moment is called the _______ of the database.   records   schema   instance   view   Half-n-half Clue   5. Which of the following are the roles of the Database Administrator: a) Managing security issues b) Storage structure definition c) Develop application programs d) Take backups of the database   a   a,b,c   a,b,d   All of these   Half-n-half Clue   6. The _______ DML requires the user to state the information required and how to retrieve it.   information   declarative   procedural   non-procedural   Half-n-half Clue   7. Which component of the DBMS translates DML instructions into DBMS understandable statements?   Query Processor   Data Manager   Storage Manager   Transaction Processor   Half-n-half Clue