01 Databases Overview

Which of these is not a type of database?

• Key-value
• Relational 
• Spreadsheet Database
• back-end

Why is it good to put all the data in one place?

• It makes it easier to query the data
• It makes it easier to save data
• It's not good to have all the data in one place

What language does the Relational Model use?

• Java
• Python
• SQL
• C++

In Relational Database what way is the data stored?

• Boxes and Queries
• Tables
• Tables, Columns and Rows
• Rows & Keys

What is an essential piece of a relational model?

• Keys
• Code

Each Table in the Database must have one column that can uniquely identify a row. What is the column called

• Main Column
• Primary Column
• Main Key
• Primary Key

If related data exists in more than one table they can be joined by using the Primary Key link to the same key in the other table what is this related key called?

• Related Key
• Primary Key
• Foreign Key
• Multi Key

What is SQL?

• Structured Query Language
• Suitable Query Language
• Sustainable Question Language
• Suitable Question Language

What does a SQL Command usually begin with?

• Adjective
• Noun
• Verb
• Pronoun

Example of an SQL Command?

• REMOVE
• SELECT
• BIN
• NUMBER