Database Basics MCQs with Answers

In database terminology, what is a row commonly referred to as?

• A.Tuple
• B.Attribute
• C.Domain
• D.Entity

In a flat file database, what does each line of text typically represent?

• A.One record
• B.One field
• C.One table
• D.One database

What does the abbreviation RDBMS stand for?

• A.Relational Database Management System
• B.Rapid Database Management System
• C.Relational Data Backup Management System
• D.Redundant Database Management System

Past Paper MCQ

Which of the following is an example of a Database Management System (DBMS)?

• A.Chrome
• B.Linux
• C.Apache
• D.ORACLE

Which database is commonly used in Android applications for data storage?

• A.MySQL
• B.PostgreSQL
• C.SQLite
• D.MongoDB

Where is the data stored in a database system?

• A.RAM of the database server
• B.Hard disk of database server
• C.Cache memory of the CPU
• D.Monitor of the client machine

In a database, what are the individual records or tuples commonly referred to as?

• A.Tables
• B.Columns
• C.Rows
• D.Schemas

What type of file does a flat file database use to store data?

• A.Plain text file
• B.Binary file
• C.XML file
• D.Encrypted file

What is a defining characteristic of a non-clustered index in a database?

• A.The physical order of rows is different from the index order
• B.The physical order of rows matches the index order
• C.The index is automatically created on the primary key column
• D.The index stores the actual data rows at the leaf level

What component maintains a detailed record of all database activities over a specific period?

• A.Data dictionary
• B.Transaction log
• C.Checkpoint file
• D.Index file