NEW
Font size
WorksheetsInformation Management - QUIZ
Total questions: 20
Worksheet time: 10mins
What does SQL stand for?
Structured Language Query
Simple Query Language
Structured Query Language
Sequential Query Language
Which SQL keyword is used to retrieve data from a database?
GET
FETCH
EXTRACT
SELECT
Which SQL command is used to insert data into a database?
INSERT
ADD
UPDATE
PUT
What does the SQL acronym DDL stand for?
Database Design Language
Data Description Language
Data Declaration Language
Data Definition Language
Which SQL clause is used to filter the result set?
HAVING
FROM
WHERE
FILTER
Which SQL statement is used to delete records from a database
DELETE
REMOVE
ERASE
DROP
What does SQL JOIN do?
Updates existing rows in a table
Deletes rows from a table
Combines rows from two or more tables
Sorts the result set
Which SQL function is used to count the number of rows in a result set?
SUM()
MAX()
AVG()
COUNT()
What does SQL DML stand for?
Data Manipulation Language
Data Modification Language
Data Modeling Language
Data Mapping Language
Which SQL keyword is used to change data in a database?
ALTER
UPDATE
CHANGE
MODIFY
What does SQL CRUD stand for?
Create, Read, Use, Delete
Collect, Read, Use, Delete
Collect, Read, Update, Delete
Create, Read, Update, Delete
Which SQL statement is used to create a new table?
MAKE TABLE
NEW TABLE
CREATE TABLE
ADD TABLE
What does SQL NULL represent?
Zero value
Non-numeric value
Infinite value
Empty value
Which SQL keyword is used to specify the sorting order?
ORDER BY
GROUP BY
ARRANGE
SORT
Which SQL function is used to find the highest value in a column?
MAX()
HIGHEST()
PEAK()
TOP()
What does SQL RDBMS stand for?
Rational Database Management System
Robust Database Management System
Reliable Database Management System
Relational Database Management System
Which SQL command is used to make changes to the structure of a table?
CHANGE TABLE
MODIFY TABLE
ALTER TABLE
UPDATE TABLE
Which SQL function is used to find the sum of values in a column?
TOTAL()
SUM()
AGGREGATE()
ADD()
In a relational database, what is a primary key?
A unique identifier for each record in a table
A key used for sorting the records in a table
A key used for accessing the database management system
A key used for joining multiple tables together
What SQL command is used to delete an entire table from the database?
REMOVE
DELETE
DROP
TRUNCATE
