
Lecture 10 - COMP1551
Quiz
•
Computers
•
University
•
Practice Problem
•
Hard
Long Nguyen
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What is the primary purpose of SQL?
To develop graphical applications
To create machine learning models
To manipulate data in relational databases
To write low-level system programs
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which SQL category includes the `CREATE TABLE` statement?
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Data Control Language (DCL)
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which of the following SQL statements retrieves data from a table?
INSERT
UPDATE
SELECT
DELETE
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What is the purpose of the `JOIN` operation in SQL?
To delete data from two tables simultaneously
To insert values into multiple tables
To combine rows from two or more tables based on a related column
To modify the schema of a table
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which SQL join returns only the matching rows from both tables?
LEFT JOIN
RIGHT JOIN
FULL JOIN
INNER JOIN
6.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which SQL function returns the total number of rows that match a condition?
SUM()
COUNT()
AVG()
MIN()
7.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which SQL clause is used to group rows based on a specific column?
ORDER BY
HAVING
GROUP BY
DISTINCT
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
11 questions
Access
Quiz
•
10th Grade - University
15 questions
tik kelas 7
Quiz
•
1st Grade - University
10 questions
Firewall & IDS
Quiz
•
University
10 questions
Blockchain
Quiz
•
1st Grade - University
15 questions
Dasar Desain Grafis
Quiz
•
12th Grade - University
10 questions
TPG Basics of web3 and programming
Quiz
•
University
10 questions
UTS Aplikasi Komputer 4C
Quiz
•
University
10 questions
Client/Server Network Model
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
