Relational Databases: Multiple Choice Questions

What is the purpose of indexes in relational databases?

• Encrypt data

• Speed up searches and provide order

• Generate passwords

• Create backups

What happens when a record is added or deleted?

• Table structure changes

• Indexes are updated automatically

• All keys reset

• Table is duplicated

What do keys and indexes help establish?

• User accounts

• Code formatting

• Relationships between tables

• Query length

What is a data schema?

• A) A group of related tables

• B) A programming function

• C) A single row

• D) A type of key

What is metadata?

• Information about tables, fields, keys, etc.

• Data stored in XML

• Only passwords

• Video file attributes

What must primary key values be?

• Random and null

• Unique and non-empty

• Equal to each other

• Set to zero

What type of relationship links one record in one table to one record in another?

• One-to-One

• Many-to-Many

• One-to-Many

• Self-referencing

What is a One-to-Many relationship?

• One record links to only one other

• One record links to many in another table

• Many records link to none

• Many-to-self

What is a Many-to-Many relationship?

• Every record is isolated

• Records in both tables link to multiple records in the other

• Only keys are linked

• Keys must be null

What is one advantage of relational databases?

• Slower performance

• Avoids redundancy and improves organization

• Supports only one user