Intro To Relational Database

What is a relational database?

• A collection of data organized in a hierarchy
• A collection of tables with related data
• A database that stores data in a single table
• A way to store data in files and folders

What is a table in a relational database?

• A place to store your physical documents
• A set of data elements organized using rows and columns
• A collection of related records
• A graphical representation of data

What is a record in a relational database?

• A single, complete set of related data fields in a table
• A type of database
• A command in SQL
• A collection of tables

What is a field in a relational database?

• A space for outdoor activities
• A single piece of data in a record
• A column in a table that represents a category of data
• A method to secure data

What is a primary key?

• The main entrance to a database
• A unique identifier for a record in a table
• A type of password
• A key to a physical lock

What does SQL stand for?

• Standard Query Language
• Structured Query Language
• Simple Quality Language
• Sequential Query List

What is the purpose of SQL?

• To create graphics
• To design web pages
• To install software
• To manage and manipulate relational databases

What is a foreign key?

• A key from another country
• A primary key in a text document
• A field in one table that uniquely identifies a row of another table
• A universal password

What is a relationship in a relational database?

• A friendship between users
• A link between websites
• A connection between tables based on matching data
• A social media feature

How can data integrity be maintained in a relational database?

• By using a strong password
• By frequently restarting the database server
• By enforcing data consistency through rules and constraints
• By limiting user access to the internet