DBMS04a_Database Concepts and SQL Flashcard - P.Sellapan

Front

What is a database?

Back

A collection of related tables for an application.

Front

What does SQL stand for?

Back

Structured Query Language

Front

What does the SQL command CREATE TABLE do?

Back

Create a new table in a database

Front

What does the SQL command INSERT INTO do?

Back

Insert records into a table

Front

What does the SQL command DELETE FROM do?

Back

Delete records from a table

Front

What does the SQL command UPDATE...SET do?

Back

Update records in a table

Front

What does the SQL command SELECT FROM WHERE do?

Back

Query a database

Front

What is a primary key in a database table?

Back

A key used for sorting and searching records

Front

What is the purpose of a foreign key in a database table?

Back

To access another table where it is the primary key

Front

What does the SQL command DROP TABLE do?

Back

Delete a table from a database