Database Basics MCQs with Answers

Which database object allows you to view, change, and analyze data in various ways?

• A.Table
• B.Form
• C.Query
• D.Report

In a database, which field type would you choose for storing lengthy text entries?

• A.Text
• B.Memo
• C.Varchar
• D.Char

What type of data does an employee address represent?

• A.Numeric data
• B.Non numeric data
• C.Boolean data
• D.Binary data

What is the term used in a database management system (DBMS) to describe the unnecessary repetition of data?

• A.Redundancy
• B.Normalization
• C.Consistency
• D.Integrity

How many tables are typically used to create a form wizard in a database application?

• A.2
• B.3
• C.4
• D.5

Which type of rollback requires the system to retain additional information about the state of all running transactions?

• A.Total rollback
• B.Partial rollback
• C.Cascading rollback
• D.Automatic rollback

What action cannot be performed by a Business Intelligence (BI) reporting system?

• A.Generate reports
• B.Analyze data trends
• C.Modify data
• D.Visualize data through dashboards

Past Paper MCQ

What is the term for the organizational capability to ensure high-quality data?

• A.Data integrity
• B.Data governance
• C.Data validation
• D.Data warehousing

What is the main function of a data pipeline in data modeling?

• A.To store raw data permanently in a data warehouse
• B.To prepare and transform data for analysis
• C.To design the graphical user interface of a database
• D.To establish physical network connections between servers

Which type of report generator requires more disk space compared to indexed/report generators?

• A.Indexed/Report generators
• B.Sort/Report generators
• C.Query/Report generators
• D.None of these