SQL Basics and Commands

Front

What is SQL?

Back

Structured Query Language (SQL) is a computer language that makes relational databases work.

Front

What does CRUD stand for in database tasks?

Back

CRUD stands for Create, Read, Update, and Delete.

Front

What is the purpose of the CREATE TABLE command?

Back

The CREATE TABLE command can add a new table to an existing database.

Front

What does the ALTER TABLE command do?

Back

ALTER TABLE is used to add, change, or remove fields on an existing table and define primary and foreign keys.

Front

What is the function of the DROP TABLE command?

Back

The DROP TABLE command deletes an entire table, including all the data stored in it.

Front

How do you start a new database in SQL?

Back

Use the CREATE DATABASE command to begin a brand-new database.

Front

What does the CREATE VIEW command do?

Back

The CREATE VIEW command creates a virtual table populated from an SQL statement result-set.

Front

What is the purpose of the CREATE INDEX command?

Back

The CREATE INDEX command creates an index within a table to accelerate the speed of query retrieval time.

Front

How do INSERT INTO and VALUES commands work together?

Back

INSERT INTO tells the database which table should store the new record, and VALUES tells the database what to write in each field.

Front

What is the SELECT command used for?

Back

The SELECT command lets you view the specific information you want from the database.