Font size
WorksheetsDatabase System DKC4312
Total questions: 25
Worksheet time: 8mins
What are databases mainly used for?
To store archived data
To store and organise data
To analyse data
Which of the following statements best defines the word 'database'?
A database is a collection of data or information which is stored in a logical and structured way
A database is a collection of statistics stored only for computers.
A database does not collect data or information.
What is the difference between an entity and an attribute?
An attribute is a table in a database and an entity is a field
An attribute is a record in a database and an entity is a table
An attribute is a field in a database and an entity is a table
Why would you create a primary key?
To make each record in a database unique
To make each field in a database unique
To make each query in a database unique
In a TABLE, a row is known as a...
Information
Column
Data
Record
The best data type to choose for a memberID would be
Number
Date/Time
Text
Currency
The best data type to choose for date of birth would be
Number
Date/Time
Text
Currency
In a database, data is stored in
Queries
Forms
Reports
Tables
Which of the following can add a row to a table?
Add
Insert
Update
Alter
What does DML stand for?
Data Manipulation Language
Data Modeling Language
Data Markup Language
Data Migration Language
Which of the following is not a valid aggregate function?
COUNT
MIN
COMPUTE
MAX
SQL is not case sensitive. SELECT is the same as select.
TRUE
FALSE
The _________ statement is used to delete a table.
DROP TABLE
DELETE TABLE
DEL TABLE
REMOVE TABLE
Which one of the following sorts rows in SQL?
SORT BY
ALIGN BY
GROUP BY
ORDER BY
The SQL statement that queries or reads data from a table is __________ .
USE
SELECT
READ
QUERY
Which SQL statement is used to return only different values?
SELECT DISTINCT
SELECT UNIQUE
SELECT DIFF
SELECT DIFFERENT
With SQL, how do you select all the columns from a table named "Persons"?
SELECT * FROM Persons
SELECT Persons
SELECT [all] FROM Persons
SELECT *.Persons
The SQL keyword BETWEEN is used:
For ranges.
To limit the columns displayed.
As a wildcard.
None of the above
Which clause is used to “Filters out unwanted data”?
FROM
SELECT
ORDER BY
WHERE
Write a query to display first_name and last_name of all employees who have their first_name starting with 'A'.
Select first_name from employess where first_name LIKE '%A';
Select first_name from employess where first_name LIKE "'A'%";
Select first_name from employess where first_name LIKE 'A%';
Select first_name from employess where first_name LIKE '%A%';
