Knowledge check: Databases and data
What is a Database in computing? a. A collection of tables of data stored and accessed electronically. b. A collection of organized data stored and accessed electronically.
b. A collection of organized data stored and accessed electronically. A database is a collection of data that can be accessed and managed electronically.
Which database model uses only tables to store data? a. Relational databases b. Flat Files databases c. NoSQL databases
a. Relational databases In relational databases all data must be stored in tables.
Big data contains a wide variety of data, arriving in increasing volumes and at high velocity. a. True b. False
a. True Big Data refers to data sets that are exceptionally large in volume, contain a wide variety of data and are retrieved with a high velocity.
The foreign key can be used to identify a specific record of data in a relational database. a. True b. False
b. False A primary key is used to uniquely identify each record in a table.
Which of the following is a key advantage of organizing data in tables? a. To store a large amount of data b. To protect data c. To provide a clear view of data
c. To provide a clear view of data Tables consists of rows and columns, which makes it easy to organize and understand data.