SQL - Test 2 (FSD46)

What is SQL?

• A programming language used to create and manipulate databases.
• A language used to communicate with relational databases.
• A markup language used to create web pages.
• A scripting language used for website development.

What is a database?

• A collection of spreadsheets.
• A collection of data organized in a structured manner.
• A collection of images.
• A collection of documents.

What is a table in a database?

• A collection of rows and columns that represent a spreadsheet.
• A collection of related data organized in a structured manner.
• A collection of images.
• A collection of documents.

What is a primary key?

• A foreign key that references another table.
• A column in a table that uniquely identifies each row.
• A column in a table that can contain NULL values.
• A constraint that ensures that a column contains unique values.

What is a foreign key?

• A column in a table that references the primary key of another table.
• A column in a table that uniquely identifies each row.
• A constraint that ensures that a column contains unique values.
• A constraint that ensures that a column cannot contain NULL values.

Which SQL keyword is used to create a new database?

• CREATE TABLE
• CREATE ROW
• CREATE DATABASE
• CREATE SCHEMA

Which SQL keyword is used to create a new table?

• CREATE ROW
• CREATE TABLE
• CREATE COLUMN
• CREATE RECORD

Which SQL keyword is used to add a new column to an existing table?

• ADD ROW
• ADD COLUMN
• ALTER TABLE
• CREATE COLUMN

Which SQL keyword is used to delete a table?

• DROP ROW
• DROP DATABASE
• DROP TABLE
• DELETE TABLE

Which SQL keyword is used to delete a database?

• DROP ROW
• DROP DATABASE
• DROP TABLE
• DELETE DATABASE