NEW
Font size
S
M
L
XL
WorksheetsDatabase Coding
Total questions: 33
Worksheet time: 16mins
Name
Class
Date
1.
A programming language designed to manipulate and manage data stored in relational databases.
a)
relational database
b)
SQL
c)
table
d)
statement
2.
A collection of data organized into rows and columns.
a)
relational database
b)
ALTER TABLE
c)
table
d)
statement
3.
What are individual pieces of data?
a)
forms
b)
fields
c)
tables
d)
queries
4.
____________ is a group of fields.
a)
database
b)
fields
c)
query
d)
table
5.
A field containing a unique identifier.
a)
report
b)
query
c)
primary key
d)
table
6.
What field type would a birthday be classified as?
a)
text
b)
integer
c)
date
d)
number
7.
Types include text, integer, date, and decimal...
a)
field type
b)
report
c)
field
d)
query
8.
What is the purpose of the * character?
a)
It selects new values in a table.
b)
It only selects columns where values are not null
c)
It selects every column in a table.
d)
It fills in for missing values.
9.
What does the INSERT statement do?
a)
Insert a new table into a database.
b)
Insert new values to fetch from a database.
c)
Insert new columns into a table.
d)
Insert new rows into a table.
10.
What would you need to complete the this UPDATE statement?
a)
The word INTO following the UPDATE statement
b)
A row name
c)
A table name
d)
A column name
11.
What clause is used with the ALTER TABLE statement.
a)
INTO
b)
ADD COLUMN
c)
SELECT
d)
JOIN
12.
What is SQL?
a)
Standard Query Language
b)
Statistical Querying Language
c)
Structured Query Language
d)
Static Querying Language
13.
What are common data types in SQL?
a)
Image, Year, Name, Parameter
b)
Integer, Text, Date , Real
c)
Bit, Int, Char, Varchar
d)
Integer, Text, Date, Year
14.
What would be correct syntax for a CREATE TABLE statement?
a)
CREATE NEW TABLE means (id INTEGER, name TEXT, rating INTEGER);
b)
CREATE meals (id INTEGER, name TEXT rating INTEGER);
c)
CREATE TABLE meals (id INTEGER, name TEXT, rating INTEGER);
d)
CREATE TABLE meals (id INTEGER name TEXT rating INTEGER)
15.
Which of the following statements is correct?
a)
DELETE icecreams WHERE flavor NULL;
b)
DELETE ALL icecreams WHERE flavor is NULL;
c)
DELETE FROM icecreams WHERE flavor IS NULL;
d)
SELECT and DELETE icecreams WHERE flavor IS NULL;
16.
What is a relational database?
a)
A relational database is a program that lets you create, update, and administer a database.
b)
A relational database is a database that organizes information into one or more tables.
c)
A relational database is a programming language used to interact with data.
d)
A relational database is another word for a single table.
17.
What is a NULL value?
a)
A false value.
b)
An outdated value.
c)
A value of 0.
d)
A value that represents missing or unknown data.
18.
Complete the statement: UPDATE celebs SET twitter_handle = '@taylorswift13' WHERE __________
a)
row = 4;
b)
name = 'Swift';
c)
row = twitter_handle;
d)
id = 4;
19.
A clause that lets you select which rows you want to delete.
a)
DELETE FROM
b)
WHERE
c)
SELECT * FROM
d)
IS NULL
20.
A collection of data organized into rows and columns.
a)
relational database
b)
SQL
c)
statement
d)
table
21.
This clause creates a new table.
a)
ALTER TABLE
b)
CREATE NEW TABLE
c)
INSERT TABLE
d)
CREATE TABLE
22.
This clause adds a new row to a table.
a)
UPDATE
b)
SELECT
c)
INSERT INTO
d)
ADD NEW
23.
This clause queries data from a table.
a)
SELECT
b)
UPDATE
c)
ALTER
d)
SQL
24.
Databases are sorted for __________.
a)
records
b)
fields
c)
data
d)
information
25.
This clause changes an existing table.
a)
EDIT TABLE
b)
DELETE FROM
c)
ALTER TABLE
d)
UPDATE
26.
A string of characters that the database recognizes as a valid command.
a)
date, text, integer
b)
query
c)
clause
d)
statement
27.
What does the INSERT statement do?
a)
Insert new columns into a table.
b)
Insert new rows into a table.
c)
inset new values to fetch from a database.
d)
insert a new table into a database
28.
Which of the following statements is correct?
a)
DELETE FROM icecreams WHERE flavor IS NULL;
b)
DELETE ALL icecreams WHERE flavor is NULL;
c)
DELETE icecreams WHERE flavor = NULL
d)
SELECT and DELETE icecreams WHERE flavor IS NULL;
29.
What clause is used with the ALTER TABLE statement?
a)
SELECT
b)
JOIN
c)
INTO
d)
ADD COLUMN
30.
What is the proper format for the following date:
December 1, 1998.
December 1, 1998.
a)
December 1, 1998
b)
1998, 01, 12:
c)
1998-01-12
d)
1998-12-01
31.
Databases are searched for _________.
a)
records
b)
fields
c)
data
d)
information
32.
What is another name for a record?
a)
column
b)
table
c)
statement
d)
row
33.
What is another name for a field?
a)
column
b)
table
c)
statement
d)
row
Reset
