Font size
WorksheetsSQL Basic
Total questions: 10
Worksheet time: 6mins
Which clause is used with the ALTER TABLE statement?
JOIN
SELECT
INTO
ADD COLUMN
What is a relational database?
A database that organizes information into one or more tables.
A set of data values of a particular type.
A single record in a table
A collection of data organized into rows and columns.
What would you need to complete the associated UPDATE statement?
UPDATE ________
SET height = 6
WHERE id = 1;
A column name.
A table name.
The keyword INTO.
A row name.
What are common data types in SQL?
PDF, JPEG, GIF, MP3
id, name, age
Row, Column
Integer, Text, Date, Real
What does the INSERT statement do?
Fetch data from a database.
Insert a new table into a database
Insert new rows into a table
Insert new columns into a table
What is a NULL value?
A value that represents missing or unknown data.
A numerical value.
An outdated value.
A known value.
What is the purpose of the * character?
SELECT *
FROM celebs;
It selects new values in the table.
It only selects columns where values are not empty in the table.
It selects the leftmost column in the table.
It selects every column in the table.
What does SQL stand for?
(a)
Which of the following statements is correct and complete?
DELETE FROM icecream WHERE flavor IS NULL;
DELETE icecream WHERE flavor NULL;
WHERE flavor IS NULL DELETE FROM icecream
WHERE flavor IS NULL
What would be correct syntax for a CREATE TABLE statement?
NEW TABLE meals ( name TEXT, rating INTEGER) ;
CREATE TABLE meals ( name TEXT, rating INTEGER) ;
CREATE meals name TEXT INTEGER
CREATE meals ( name TEXT, rating INTEGER);
