Free Databases MCQs with Answers

1. In a relational database, a primary key is a field that:

• A. Stores the largest value in the table
• B. Uniquely identifies each record in a table
• C. Links two databases together
• D. Encrypts the contents of a table

Explanation: A primary key uniquely identifies every record in a table and cannot contain duplicate or null values. A foreign key, by contrast, is a field that references the primary key of another table to establish a relationship.

2. In database table, what does a column represent?

• A. Attributes
• B. Index
• C. Entity
• D. Relation

Explanation: A column represents an attribute, such as StudentName or DateOfBirth, while a row represents one entity or record. An index is an access structure, and a relation usually refers to the table itself.

3. Data in database at a particular point of time is called as?

• A. Intension
• B. Extension
• C. Back up
• D. Application

Explanation: An extension is the collection of records stored in a database at a particular time, also called the database state or instance. Intension refers to the database schema or structure.

4. A______________is a collection of data organized in a manner that allows access, retrieval and use of that data.

• A. File
• B. Recordset
• C. Database
• D. document

Explanation: A database is an organized collection of related data designed for efficient access, retrieval and use. A file or recordset may hold part of the data, but does not necessarily describe the complete organized collection.

5. SQL stands for ________?

• A. Straight Query Langauge
• B. Structured Query Langauge
• C. Structured Query Laison
• D. Structured Query Linear

Explanation: SQL means Structured Query Language, the standard language used to define, query and manipulate relational databases. The spelling in the options is incorrect, but option b is clearly intended.

6. MS-Access is program for____________?

• A. Presentation
• B. Documentation
• C. Calculation
• D. Data Base

Explanation: MS Access is a relational database management program used to create tables, queries, forms, and reports. Presentation, documentation, and calculation are associated more directly with other Office applications.

7. SQL is a query language and has types_______________?

• A. Data definition language
• B. Data manipulation language
• C. Data control language
• D. All of the above

Explanation: SQL includes data definition commands such as CREATE, data manipulation commands such as SELECT and UPDATE, and data control commands such as GRANT. Therefore, all three listed categories are represented.

8. DBMS stands for____________?

• A. Database management system
• B. Database maintaince system
• C. Database maintaince and storage
• D. Database management Sound

Explanation: DBMS stands for Database Management System, software that creates, stores, organizes, and controls access to databases. The other expansions are not standard computing terms.

9. Which of the following contains permanent data and gets updated during the processing of transactions?

• A. Operating System File
• B. Transaction file
• C. Software File
• D. Master file

Explanation: A master file holds relatively permanent information, such as customer or account records, and is updated using transaction data. A transaction file temporarily records the individual changes or events.