Databases & Big Data

Define Attribute in a database table.

• An attribute is a unique identifier for a database table.

• An attribute is a column in a database table that describes a data field.

• An attribute is a relationship between two tables.

• An attribute is a stored procedure in a database.

What is Big Data?

• A large volume of data that can be structured or unstructured, and is generated at high velocity.

• A small amount of data that is easy to process.

• A type of data that is only found in large corporations.

• A specific software used for data analysis.

A Composite Key in a database is:

• A single attribute that uniquely identifies a record

• A combination of two or more attributes that uniquely identifies a record

• A foreign key that references a primary key

• A key that is not unique

Concurrency Control in databases is:

• A method to manage simultaneous operations without conflicts

• A way to store data persistently

• A technique to backup data

• A process to delete data securely

Data Integrity in databases ensures that data is:

• Accurate and consistent

• Stored in multiple locations

• Encrypted and secure

• Easily accessible

Data Redundancy in a database is:

• The process of storing the same data in multiple locations

• A method to reduce data storage

• A technique to enhance data security

• A way to improve data retrieval speed

A Database is a structured collection of data. What is a Database?

• A type of software

• A structured collection of data

• A programming language

• A hardware device

What is Distributed Processing in databases?

• A method to store data in a single location

• A technique to process data across multiple databases

• A way to process data using a single processor

• A method to store data in a cloud environment

An Entity in a database is:

• a table that stores data

• a field in a table

• a unique identifier for a record

• a relationship between tables

Entity Relationship Diagram (ERD) is a tool used for:

• Designing databases

• Creating user interfaces

• Developing algorithms

• Writing code