1. ROLLBACK in a database is ________ statement ?

TCL

DCL

DML

DDL

Answer: TCL

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.


2. Unlike filters queries can be saved as in a database ?

objects

filters

database

Any of the above

Answer: objects

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.


3. Dr. E.F. Codd represented ______ rules that a database must obey if it has to be considered truly relational ?

10

8

12

6

Answer: 12

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.


4. Periodically adding, changing and deleting file records is called file ?

updating

upgrading

restructiring

renewing

Answer: updating

Explanation:

Periodically adding, changing and deleting file records is called file updating.


5. A tuple is a ?

column of a table

two-dimensional table

row of a table

key of a table

Answer: row of a table

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.


6. A collection of interrelated records is called a ?

management information system

spreadsheet

database

text file

Answer: database

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.


7. __________ represents raw facts, whereas __________ is data made meaningful ?

Information, reporting

Data, information

Information, bits

Records, bytes

Answer: Data, information

Explanation:

Data represents raw facts, whereas information is data made meaningful.


8. A collection of unprocessed items is ________ ?

information

data

memory

reports

Answer: data

Explanation:

A collection of unprocessed items is data.


9. The ability to find an individual item in a file immediately ?

sequential access

file allocation table

direct access

directory

Answer: direct access

Explanation:

The ability to find an individual item in a file immediately is called direct access. Therefore, the correct option is (c) direct access.


10. External database is ?

Database created in EXCEL

Database created using DBMS package

Database created in MS-Word

All of the above

Answer: Database created using DBMS package

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.