Database Concepts Quizs

Composite key

• A primary key composed of two or more columns.

• A unique identifier for a single column.

• A foreign key that references multiple tables.

• A key that allows duplicate values in a column.

Primary key

• A unique identifier for each record in a table.

• A field that can contain duplicate values.

• A field that is used to sort data in a table.

• A field that is optional in a database table.

Entity in a database

• A type of database management system

• An object or thing that can have data stored about it.

• A method for querying data

• A programming language used for database operations

Purpose of a foreign key

• To create a link between two tables.

• To store data in a single table.

• To delete records from a database.

• To increase the speed of data retrieval.

Multiple primary keys in a table

• True; a table can have multiple primary keys.

• False; a table can only have one primary key.

• A table can have primary keys in different columns.

• A table can have primary keys if it has foreign keys.

Normalization

• It reduces data redundancy and improves data integrity.

• It increases data redundancy and decreases data integrity.

• It eliminates all data from the database.

• It is a method to encrypt sensitive data.

SQL command to create a table

• CREATE TABLE

• INSERT INTO

• DROP TABLE

• SELECT * FROM

ERD

• An Entity-Relationship Diagram that visually represents entities and their relationships.

• A type of database that stores data in tables.

• A programming language used for database management.

• A diagram that shows the flow of data in a system.

Importance of data types in table design

• Data types specify the kind of data that can be stored and affect storage requirements.

• Data types are irrelevant to table design.

• Data types only affect the visual representation of data.

• Data types determine the speed of data retrieval.