1. The database oriented approach _______ the redundancy of data compared to the file oriented approach.   reduces   increases   2. The database oriented approach does not support multiple views of the same data.   True   False   3. One of the requirements of transaction management is that the transaction should occur completely or not occur at all. This requirement is termed as _______.   consistency   isolation   atomicity   durability   Hint Half-n-half Clue   4. Which component of the DBMS translates DML instructions into DBMS understandable statements?   Transaction Processor   Query Processor   Data Manager   Storage Manager   Half-n-half Clue   5. The DML is used for: a) Creating tables b) Retrieving data c) Deleting users d) Inserting data e) Deleting data   b,d,e   b,c,d   None of these   All of these   Half-n-half Clue   6. 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   Half-n-half Clue   7. The security features of the database are set up by the _______.   Naive Users   Application Programmer   Online Users   Database Administrator   Half-n-half Clue