Database Management Systems Quiz

What is an advantage of using indexes in a DBMS?

• They are always free.

• They require no training.

• They enable fast lookups.

• They eliminate redundancy.

What does a schema with constraints enforce?

• User access levels.

• Data redundancy.

• Common formats.

• File storage.

What is a feature of files regarding layout?

• They require a server.

• They are always encrypted.

• They support complex queries.

• Everyone uses the same flat layout.

What is a natural way to perform ad hoc queries?

• Using SQL or filters.

• Using spreadsheets.

• Using CSV files.

• Using manual scanning.

What is a limitation of a DBMS?

• Allows easy data sharing.

• Supports multiple formats.

• Requires admin/training to manage.

• Is always online.

What is a risk associated with a single point of failure?

• File format inconsistencies.

• Server downtime.

• Data redundancy.

• User access issues.

What is a feature of files regarding data storage?

• Multiple CSVs stored in different folders.

• All data in one table.

• Automatic backups.

• Role-based access.

What is an advantage of role-based views in a DBMS?

• They eliminate redundancy.

• They are always accurate.

• They require no training.

• They show different slices of data.

What is a limitation of using a DBMS for small tasks?

• It is always more efficient.

• Overhead is unnecessary for tiny one-off tasks.

• It requires complex queries.

• It is less secure.

What is the main method to update data in files?

• Database transactions.

• Automated scripts.

• Direct editing.

• Copy-paste.