Test: Database Concepts- 3 - Humanities/Arts MCQ

The Database management system can also considered as the set of programs that enables users to create and maintain the database.

As we all know that while working with the Transactions, the Transaction Control Language is used. To restore the database to the last committed state ( or to undo the latest changes), the "rollback" command is used that belongs to the Transaction Control Language.

The collection of data (or information) stored in a database at a particular moment is known as the instance of the database. Therefore the correct answer is B.

The term"DFD" stands for the Data Flow Diagram, and to represent the flow of the data( or information), the data flow diagram is used. The data flow diagram also helps in understanding how the data is managed in the application. Therefore the correct answer is C.

The term "Data independence" refers that the program should not be dependent on either the logical attributes of data or physical attributes of data.

The term "SQL" stands for the structured query language, which is one of the most widely, used programming languages for relational databases. It can also be used for managing and organizing data in all sorts of systems in which different data relationships exist. Therefore the correct answer is C.

The conceptual view refers to the total view of the content available in the database. Therefore the correct answer is A.

In database management systems, relation calculus is a type of non-procedural query language that describes what data needs to be retrieved. However, it does not explain how to retrieve the data.

The term "ODBC" refers to the Open Database Connectivity that is a SQL based programming interface introduced by Microsoft.

The term "DML" refers to the data manipulation language, which is commonly used to perform basic operations such as insert data, delete, and update data in a database. So the correct answer will be B.

In the relation model, the relations are also referred to as the tables because the relations are considered as the technical name of the table. So the correct answer is D.

A database's architecture can be viewed as the three levels of abstraction that are named as the internal level, external level, and the conceptual level. Therefore the correct answer is C.

To represent the relationships between the various tables in the database, generally, the foreign key is used. Therefore the correct answer is the foreign key.

The database's external level is the one and only level that is considered the closest level to the end-users. So the correct answer will be the B.

The database management query language is generally designed by keeping in mind that it must support the end-users who are familiar with the English-like commands. It should also boost the process of development of the complex applications software and helps in specifying the structure of the database.