Database quiz 3 SQL

Quiz
•
Computers
•
12th Grade
•
Medium
W Deng
Used 2+ times
FREE Resource
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the function of != operator?
Less than
Greater than
Equal to
Not equal to
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following statement is used to display all the fields of a table?
SELECT * FROM table_name
CREATE * FROM table_name
DISPLAY * FROM table_name
None of the above
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following are Boolean operators?
AND, OR and NOT
ADD, SUB, MULT and DIV
ORDER BY and WHERE
None of the above
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following clauses is used to select records while displaying results using a SELECT statement?
UPDATE
ORDER BY
WHERE
WHICH
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following operator is used with wildcard characters?
BETWEEN … AND …
IN
LIKE
IS NULL
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Complete this query to display records in alphabetical order of field ‘StudentName’ from the table ‘StudentDetails’: SELECT * FROM StudentDetails ………………...
ORDER BY StudentName
ORDER BY StudentName Desc
WHERE StudentName = Asc
WHERE StudentName = Desc
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is used to combine rows from two or more tables based on a field that is common to the tables?
SELECT & JOIN
SELECT & COMBINE
MERGE
SELECT & MERGE
Create a free account and access millions of resources
Similar Resources on Wayground
20 questions
Java Casting & Booleans

Quiz
•
10th - 12th Grade
16 questions
Week 11 revision quiz

Quiz
•
9th - 12th Grade
18 questions
Big Data

Quiz
•
9th - 12th Grade
15 questions
internet of things

Quiz
•
9th - 12th Grade
18 questions
Photoshop Selections and More

Quiz
•
9th - 12th Grade
20 questions
REVIEW 2025 Digital Multimedia 1Final Exam

Quiz
•
9th - 12th Grade
13 questions
Dimensioning Practice test 1

Quiz
•
9th - 12th Grade
15 questions
Quiz on Computational Thinking and Algorithms 10F

Quiz
•
10th Grade - University
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
10 questions
UPDATED FOREST Kindness 9-22

Lesson
•
9th - 12th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
20 questions
US Constitution Quiz

Quiz
•
11th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade