Chapter 01

Question 1. A data definition language (DDL) is a language for specifying the database schema and as well as other properties of the data.
True

Question 2. A data manipulation language (DML) is a language for specifying the database schema and as well as other properties of the data.
False

Question 3 A data model is a collection of conceptual tools for describing data, data relationships, data semantics, and data constraints.
True

Question 4 A database management system (DBMS) consists of a collection of interrelated data and a collection of programs to access that data.
True

Question 5 Data independence means “the applications have to be re-written and re-compiled accordingly if the storage structures or the access techniques of the data have some change”
False

Question 6 In a two-tier architecture, the application and DBMS are housed at the same computer.
False

Question 7 The query processor subsystem compiles and executes DDL and DML statements.
True

Question 8 The storage manager subsystem provides the interface between the low level data stored in the database and the application programs and queries submitted to the system.
True

Question 9 Database applications are typically brokenup into a front-end part that runs at client machines and a part that runs at the back end.
True

Question 10 In two-tier architectures, the front end directly communicates with a database running at the back end, while in three-tier architectures, the back end part is itself broken up into an application server and a database server.
True

Question 11 Querying the database and generating reports is assisted by the application generation subsystem.
False

Question 12 The field of data mining combines knowledge discovery techniques invented by artificial intelligence researchers and statistical analysts, with efficient implementation techniques that enable them to be used on extremely large databases.
True

Question 13 Transaction management ensures that the database remains in a consistent (correct) state despite system failures.
True

Question 14 The DBA can create user forms and menus using the
c. application generation subsystem.
The application generation subsystem provides tools to enable this task.

Question 15 Which one of the following is a procedural language?
b. Relational algebra
Domain and Tuple relational calculus are non-procedural language. Query language is a method through which database entries can be accessed.