Structured Query Language (SQL) (AQA A-Level Computer Science): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
SQL acronym meaning
SQL acronym meaning
Structured Query Language
CREATE TABLE command purpose
CREATE TABLE command purpose
Creates new table with specified structure
PRIMARY KEY purpose
PRIMARY KEY purpose
Identifies field that uniquely identifies each record
Varchar vs character efficiency
Varchar vs character efficiency
Varchar stores variable-length text, character pads with spaces
INSERT INTO statement purpose
INSERT INTO statement purpose
Adds new records/data to a table
UPDATE statement purpose
UPDATE statement purpose
Modifies existing records in a table
WHERE clause purpose in SQL
WHERE clause purpose in SQL
Sets conditions that records must meet to be included
Asterisk (*) wildcard in SELECT means
Asterisk (*) wildcard in SELECT means
All attributes/columns
DBMS definition
DBMS definition
Software that controls all aspects of a database
When concurrent access problems occur
When concurrent access problems occur
When multiple users write to same location simultaneously