Database Basics MCQs with Answers

Which of the following is not considered a database object in MS Access?

• A.Tables
• B.Queries
• C.Forms
• D.Worksheets

What kind of platform is Oracle considered to be in terms of system dependency?

• A.Independent
• B.Dependent
• C.Neutral
• D.None of these

Which type of table constraint is used in a database to ensure that no two rows have the same value in a specified column?

• A.Primary Key
• B.Foreign Key
• C.Unique
• D.Check

How can you determine the location of rows in a database table efficiently?

• A.By using cursor
• B.By using view
• C.By using trigger
• D.By using index

What types of data can a database contain?

• A.Text and numbers only
• B.Images and multimedia only
• C.Structured records only
• D.All of these

In database terminology, a column is referred to as what?

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

Past Paper MCQ

How many main sections are typically present in a database table?

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

Which of the following is not considered a NoSQL database type?

• A.Document-oriented
• B.Key-value
• C.Relational
• D.Graph-based

In relational database terminology, what is another name for an attribute?

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

Who is responsible for the design, implementation, maintenance, and repair of entire databases?

• A.Database Administrator
• B.System Analyst
• C.Network Administrator
• D.Software Engineer