Simple DBMS Quiz

ROLLBACK is a Transaction Control Language (TCL) command that undoes transactions, while GRANT and REVOKE are Data Control Language (DCL) commands used for permissions. TCL includes COMMIT, ROLLBACK, and SAVEPOINT for managing database transactions.

PL/SQL cursors have attributes like %ISOPEN (checks if cursor is open) and %NOTFOUND (checks if the last fetch returned no rows). %CURSORSOPEN is not a valid cursor attribute. Other attributes include %FOUND and %ROWCOUNT.

File management systems suffer from all these problems: they are difficult to update, lack data independence (programs must know data structure), have data redundancy (same data stored in multiple files), and show program dependence (changes require program updates).

The network data model's key advantage is that it allows many-to-many relationships between records, unlike hierarchical models which only allow one-to-many. Option A is incorrect because it's a logical model, not physical. Option C is incorrect - network models are complex.

DBMS can export and import data to and from various applications including spreadsheets (for analysis), word processors (for reports), and graphics programs (for visualization). Modern DBMS support multiple data export/import formats.

DB/DC Dictionary (Database/Data Communications Dictionary) is a data dictionary software tool that stores metadata about the database structure. TOTAL, ACCESS, Datapac, and Data Manager are database management systems or related products, not data dictionary tools.

Data hierarchy in ascending order is: bit (smallest) → byte → field (combination of bytes) → record (combination of fields) → file (combination of records) → database (collection of files). Option C correctly orders these from smallest to largest.