Lecture 10 - COMP1551

Lecture 10 - COMP1551

University

10 Qs

quiz-placeholder

Similar activities

Kuis Webinar Cerdas Bertelekomunikasi OTP Fraud

Kuis Webinar Cerdas Bertelekomunikasi OTP Fraud

6th Grade - Professional Development

10 Qs

CHAPTER 1: COMPUTER SECURITY REVIEW

CHAPTER 1: COMPUTER SECURITY REVIEW

University

10 Qs

Komponen Jaringan & Pengkabelan

Komponen Jaringan & Pengkabelan

University

15 Qs

Quiz Webinar GNS3

Quiz Webinar GNS3

10th Grade - University

13 Qs

Enterprise development - JEE

Enterprise development - JEE

University

10 Qs

kuis cepat sejarah perkembangan komputer

kuis cepat sejarah perkembangan komputer

University

10 Qs

AIJ (Memahami Fairewall)

AIJ (Memahami Fairewall)

University

10 Qs

Evaluasi Pertemuan 12 DRPL TI-3B

Evaluasi Pertemuan 12 DRPL TI-3B

University

15 Qs

Lecture 10 - COMP1551

Lecture 10 - COMP1551

Assessment

Quiz

Computers

University

Practice Problem

Hard

Created by

Long Nguyen

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?