Database quiz 3 SQL

Database quiz 3 SQL

12th Grade

15 Qs

quiz-placeholder

Similar activities

SQL-Class 12

SQL-Class 12

12th Grade

16 Qs

Unit 3: Intro to Programming

Unit 3: Intro to Programming

9th - 12th Grade

20 Qs

Screenshot Techniques By Mr. B

Screenshot Techniques By Mr. B

12th Grade

13 Qs

REST API and MySQL Quiz SKG

REST API and MySQL Quiz SKG

12th Grade

15 Qs

CompTIA Security+ Practice Test 2

CompTIA Security+ Practice Test 2

12th Grade

14 Qs

Data Science Hospital Intro

Data Science Hospital Intro

12th Grade

10 Qs

8525 AQA  GCSE Computer Science 3.7.1 Relational databases

8525 AQA GCSE Computer Science 3.7.1 Relational databases

7th - 12th Grade

16 Qs

Chapter : 9 Working with tables

Chapter : 9 Working with tables

5th Grade - University

15 Qs

Database quiz 3 SQL

Database quiz 3 SQL

Assessment

Quiz

Computers

12th Grade

Medium

Created by

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

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?