NEW
Font size
WorksheetsSQL Quiz
Total questions: 20
Worksheet time: 20mins
Which SQL command is used to manage user permissions?
Data Control Commands
Data Definition Commands
Data Manipulation Commands
Aggregate Commands
What is the purpose of aggregate functions in SQL?
To perform calculations on a set of values and return a single value
To define database structure
To manage user permissions
To execute triggers
What is the purpose of nested queries in SQL?
To use a query inside another query
To define database structure
To manage user permissions
To perform string operations
What is the purpose of domain constraints in SQL?
To restrict the type of data that can be stored in a column
To ensure relationships between tables remain consistent
To define database structure
To execute triggers
What is the purpose of check constraints in SQL?
To ensure that a column's value meets a specific condition
To define database structure
To manage user permissions
To execute triggers
What is the purpose of nested and complex queries in SQL?
To perform advanced data retrieval operations
To define database structure
To manage user permissions
To execute triggers
What is the purpose of the "group by" clause in SQL?
To organize data into groups based on a column
To define database structure
To manage user permissions
To execute triggers
What is the purpose of the "having" clause in SQL?
To filter grouped data
To define database structure
To manage user permissions
To execute triggers
Which would find pupils with "er" anywhere in their name?
SELECT * FROM Pupils Where Name = "%er"
SELECT * FROM Pupils Where Name = "$er$"
SELECT * FROM Pupils Where Name = "%er%"
SELECT * FROM Pupils Where Name = "er%"
What will be the output?
SELECT ROUND(36.7894,2)
36.78
38.79
36.7
36
What will be the output?
SELECT TRUNCATE(36.5643,2);
36.56
36.57
36.5643
36
Which of the following SELECT query returns the department number with maximum salary compensated to an employee? (Consider the table structure as given)
SELECT department_id , max(salary ) FROM employees ;
SELECT department_id , max(salary ) FROM employees GROUP BY department_id ;
SELECT max(salary ) FROM employees GROUP BY department_id ;
SELECT max(salary ) FROM employees ;
Predict the outcome of the below query
SELECT department_id ,avg(salary ) FROM employees HAVING avg(salary )>2000 GROUP BY department_id ORDER BY department_id
It executes successfully.
It throws error because HAVING clause precedes the GROUP BY clause.
It throws error because HAVING clause uses the aggregate function.
It executes but no results are displayed because HAVING clause precedes the GROUP BY clause.
How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?
SELECT * FROM Items ORDER BY Price ASCENDING
SELECT * FROM Items ORDER BY Price ASC
SELECT * FROM Items BY Price LOWEST TO HIGHEST
SELECT * FROM Items ORDER BY Price DESC
SQL query to find all the cities whose humidity is 95.
SELECT city WHERE humidity = 95
SELECT city FROM weather WHERE humidity = 95
SELECT humidity = 89 FROM weather
SELECT city FROM weather
Which character returns all the data found in a table?
%
#
*
/
You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?
UPDATE Designer SET PhoneNo = '01224123456'
UPDATE Designer (PhoneNo) VALUES ('01224123456')
UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'
UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'
Which SQL statement would add a record to the database?
INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')
INSERT VALUES ('SMI01', 'M Smith', 'mail@msmith.com', 01224123456') INTO Designer
INSERT ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') INTO Designer
INSERT Designer INTO VALUES (''SMI01', 'M Smith', 'mail@msmith.com', '01224123456')
