Practice Questions

---

Question 1

Which database object is used to store data in rows and columns?

A. View
B. Table
C. Index
D. Schema

✅ Answer: B

Explanation:
Tables are the primary objects used to store structured data.

---

Question 2

Which database object provides a virtual representation of data without storing it physically?

A. Table
B. Index
C. View
D. Constraint

✅ Answer: C

Explanation:
Views display data based on a query but typically do not store data themselves.

---

Question 3

What is the primary purpose of an index?

A. Store data
B. Enforce relationships
C. Improve query performance
D. Organize database objects

✅ Answer: C

Explanation:
Indexes speed up data retrieval operations.

---

Question 4

Which database object allows you to store and reuse a set of SQL statements?

A. View
B. Stored procedure
C. Schema
D. Index

✅ Answer: B

Explanation:
Stored procedures contain reusable SQL logic and can include parameters and control flow.

---

Question 5

Which database object is used to logically group other database objects?

A. Table
B. Schema
C. Index
D. Constraint

✅ Answer: B

Explanation:
Schemas organize database objects and help manage permissions.

---

Question 6

Which object ensures that each row in a table is uniquely identified?

A. Foreign key
B. Index
C. Primary key
D. View

✅ Answer: C

Explanation:
A primary key uniquely identifies each record in a table.

---

Question 7

Which database object enforces relationships between tables?

A. Schema
B. Foreign key
C. Index
D. Stored procedure

✅ Answer: B

Explanation:
Foreign keys link tables and enforce referential integrity.

---

Question 8

Which constraint prevents duplicate values in a column?

A. NOT NULL
B. CHECK
C. UNIQUE
D. FOREIGN KEY

✅ Answer: C

Explanation:
The UNIQUE constraint ensures all values in a column are distinct.

---

Question 9

Which database object is MOST useful for restricting access to specific columns of data?

A. Table
B. Index
C. View
D. Primary key

✅ Answer: C

Explanation:
Views can limit which columns or rows are exposed to users.

---

Question 10

Which object may slightly decrease write performance due to maintenance overhead?

A. View
B. Index
C. Schema
D. Constraint

✅ Answer: B

Explanation:
Indexes improve read performance but can slow down inserts and updates.

---

✅ Quick Exam Takeaways

For DP-900, remember:

✔ Tables → store data
✔ Views → virtual tables (security + simplicity)
✔ Indexes → improve performance (reads ↑, writes ↓ slightly)
✔ Stored procedures → reusable SQL logic
✔ Schemas → organize objects
✔ Primary keys → unique identifiers
✔ Foreign keys → relationships
✔ Constraints → enforce rules (NOT NULL, UNIQUE, etc.)

---

Go to the DP-900 Exam Prep Hub main page.