The technique for coding data in binary

The method of storing data in physical media

The process of organizing data to reduce redundancy

The process of creating redundant data

Stores multiple values in a single field

Uniquely identifies a record in a table

Links two tables together

Represents a common field in multiple tables

The relationship between two entities

The number of fields in a table

The type of data stored in a field

The physical storage location of data

One-to-many

Many-to-many

Many-to-few

One-to-one

A field that contains repeating values

A field that links two tables together

A field that cannot be null

A unique identifier for a record

Unicode

Binary

ASCII

EBCDIC

Simpler data access methods

Better data security and integrity

Increased data redundancy

Lower cost of implementation

Data can be duplicated across tables

Foreign key values must match primary key values

All data is stored in one table

All fields must be unique

It stores data in a single file

It is used for real-time transaction processing

It integrates data from multiple sources

It only contains structured data

To ensure data security and integrity

To create user interfaces for databases

To control database operations like storing and retrieving data

To define the structure of a database

One instance of an entity cannot relate to any other entity

One instance of an entity relates to one instance of another entity

Many instances of one entity can relate to many instances of another entity

One instance of an entity can relate to many instances of another entity

Creating the third normal form

Identifying functional dependencies

Eliminating repeating groups

Creating an unnormalized design

To design user interfaces for databases

To ensure data security and manage the database

To write data manipulation languages

To create physical storage devices

It reduces the amount of data stored

It helps find patterns and relationships in large datasets

It simplifies data entry processes

It eliminates the need for data warehousing

To manipulate data within a database

To define the structure and schema of a database

To ensure data integrity and security

To perform data analysis and reporting

Real-time transaction processing

Historical data analysis and reporting

Data entry and validation

Creating user interfaces for applications

To uniquely identify a record using multiple fields

To link two tables together

To store multiple values in a single field

To ensure all fields in a table are unique

To reduce data redundancy

To improve query performance

To ensure data integrity

To create additional tables

DELETE

DROP

REMOVE

TRUNCATE

To ensure data is unique

To speed up data retrieval

To store data in a compressed format

To maintain referential integrity

To store operational data

To support business intelligence activities

To manage real-time transactions

To create user interfaces for applications

Data is stored in a flat file

Data is organized in tables with relationships

Data cannot be queried

Data is stored in a hierarchical structure

Structured Query Language

Simple Query Language

Standard Query Language

Sequential Query Language

UPDATE

EDIT

CHANGE

ALTER

To ensure data is stored permanently

To group multiple operations into a single unit

To create backups of the database

To optimize query performance

Hierarchical

Flat-file

Network

All of the above

One instance of an entity can relate to multiple instances of another entity

One instance of an entity relates to exactly one instance of another entity

Many instances of one entity can relate to only one instance of another entity

One instance of an entity cannot relate to any other entity

To ensure that all values in a column are different

To link two tables together

To allow duplicate values in a column

To define the primary key of a table

SELECT

GET

FETCH

RETRIEVE

To increase data redundancy

To speed up data retrieval

To ensure data integrity

To simplify database design

To automate repetitive tasks

To create user interfaces

To store data in a file

To define the structure of a table

Data is stored in a flat file

Data can be easily queried and manipulated

It requires less storage space

It eliminates the need for data normalization

Hierarchical model

Flat file model

Network model

All of the above

To store user data

To define the structure of the database

To manage database security

To optimize query performance

UPDATE

MODIFY

CHANGE

ALTER

CREATE

ADD

INSERT

MAKE

To uniquely identify a record

To establish a relationship between two tables

To store large amounts of data

To ensure data integrity within a single table

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

All of the above

To link two tables together

To uniquely identify a record in a table

To store large amounts of data

To ensure data integrity within a single table