Quiz

Database Fundamentals

0% completed

Quiz

Question 1

What is the primary purpose of indexing in a database?

A

To compress data for storage optimization

B

To improve the speed of data retrieval

C

To maintain data consistency during transactions

D

To distribute data across multiple nodes

Question 2

What is the main advantage of a clustered index?

A

Reduces data redundancy

B

Requires no additional storage

C

Supports faster random access

D

Improves performance for range queries

Question 3

How does a bloom filter handle false positives?

A

By storing exact data for validation

B

By using additional hash functions for resolution

C

By probabilistically returning false positives

D

By maintaining multiple replicas of the data

Question 4

Which of the following is true about hash-based indexing?

A

It provides constant-time complexity for equality searches

B

It guarantees that no collisions occur

C

It organizes data sequentially for range queries

D

It is unsuitable for primary indexes

Question 5

What is a secondary index used for?

A

Enforcing primary key constraints

B

Allowing queries on non-primary key attributes

C

Storing metadata about tables

D

Organizing records in sorted order

.....

Like the course? Get enrolled and start learning!