Flashcards
Paper 2
Cards in this deck (6)
- 1Which SQL statement allows users to find records with similar attributes.FROM allows users to find records with similar attributes.
- 2Which SQL statement allows a user to add a new record.INSERT INTO allows a user to add new record.
- 3Which SQL statement allows a user to sort records into order?ORDER allows a user to sort records into order.
- 4Which SQL statement defines the fields that will be looked at in the query?SELECT defines the fields that will be looked at in a query.
- 5In SQL, what does the code 'Title varchar(20)' mean?Create a field called 'Title' with a string data type and a length of 20 characters
- 6in SQL, whats the difference between char and varchar?Char makes the data type a fixed length.
Varchar makes the data type a variable length
Information
- Description
- Flashcards on Paper 2, created by Lewis Harper on 25/06/2019.
- Created by
- Lewis Harper
- Views
- 0
- Rating