Explanation: An external database refers to a database that is created using a DBMS (Database Management System) package. Therefore, the correct option is (b) Database created using DBMS package.
Explanation: The ability to find an individual item in a file immediately is called direct access. Therefore, the correct option is (c) direct access.
Explanation: A collection of unprocessed items is data.
Explanation: Data represents raw facts, whereas information is data made meaningful
Explanation: The correct answer is (c) database. A collection of interrelated records is called a database. In database management systems, data is organized into one or more tables, with each table containing a collection of related records or data entities. The purpose of a database is to provide a structured and organized way to store, manage, and retrieve data, allowing users to easily access and manipulate the data for a variety of purposes.
Explanation: The correct answer is (c) row of a table. In database management systems, a tuple is a row of a table that represents a single record or instance of an entity. Each tuple contains a set of attributes, which are the columns or fields of the table that describe the characteristics of the entity being represented.
Explanation: Periodically adding, changing and deleting file records is called file updating.
Explanation: Dr. E.F. Codd represented 12 rules that a database must obey if it has to be considered truly relational. Therefore, the correct option is (c) 12.
Explanation: Queries can be saved in a database, unlike filters that are used to temporarily sort, filter or modify data. Therefore, the correct option is (a) objects.
Explanation: TCL (Transaction Control Language) statement. ROLLBACK is a TCL statement that is used to undo changes made in a transaction and to restore the database to its previous state before the transaction started. TCL statements are used to control the changes made by transactions in a database. The other TCL statements are COMMIT and SAVEPOINT.