Database Basics MCQs with Answers

Which data type is used in a database table to store a picture?

• A.OLE
• B.BLOB
• C.CLOB
• D.VARCHAR

Past Paper MCQ

A set of possible data values in a database is called what?

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

In a consolidated data distribution strategy, where is all the data typically located?

• A.All data are located at a single site
• B.Data is distributed across multiple remote sites
• C.Data is partitioned and replicated across all nodes
• D.Data is stored only on cloud servers

In database terminology, what is the term used for a category of information within a table?

• A.Tuple
• B.Record
• C.Field
• D.Attribute

In database terminology, what is a collection of related fields called?

• A.Database
• B.Table
• C.File
• D.Record

What type of database schema establishes a top-to-bottom relationship among items?

• A.Hierarchical schema
• B.Network schema
• C.Relational schema
• D.Flat schema

What is a primary function of a Report generated in a Database Management System (DBMS)?

• A.To provide an on-screen document from the database
• B.To store raw data in tables
• C.To establish relationships between entities
• D.To encrypt database files for security

What term is used to refer to the columns in a Microsoft Access table?

• A.Attributes
• B.Records
• C.Tuples
• D.Fields

In a relational database environment, which of the following is not considered a component?

• A.Tables
• B.Queries
• C.Separate files
• D.Reports

What does a database consist of in terms of file organization?

• A.A single large file containing all records
• B.Many different files linked with each other for retrieval
• C.Only indexed sequential files stored on disk
• D.Unorganized collection of unrelated flat files