SQL FINAL ASSESSMENT

SQL FINAL ASSESSMENT

Professional Development

20 Qs

quiz-placeholder

Similar activities

BREAD REVISION

BREAD REVISION

Professional Development

16 Qs

The Art of Online Teaching

The Art of Online Teaching

Professional Development

20 Qs

Time and Tense 24 May

Time and Tense 24 May

Professional Development

20 Qs

COVID-19 IPC Quiz

COVID-19 IPC Quiz

Professional Development

20 Qs

ECCONET 3 DICT

ECCONET 3 DICT

Professional Development

20 Qs

Guess the Logo

Guess the Logo

Professional Development

15 Qs

Average and ages 25th May

Average and ages 25th May

Professional Development

20 Qs

Pre Test Leadership

Pre Test Leadership

Professional Development

20 Qs

SQL FINAL ASSESSMENT

SQL FINAL ASSESSMENT

Assessment

Quiz

Professional Development

Professional Development

Practice Problem

Easy

Created by

KVCH CORPORATE

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

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

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL function is used to count the number of rows in a SQL query?

COUNT()

NUMBER()

SUM()

COUNT(*)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

___________removes all rows from a table without logging the individual row deletions.

DELETE

REMOVE

TRUNCATE

DROP

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is not a DDL command?

UPDATE

TRUNCATE

ALTER

None of the Mentioned

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a large object data type?

varchar(max)

varbinary(max)

nvarchar(max)

image

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which server can join the indexes when only multiple indexes combined can cover the query?

SQL

DBMS

RDBMS

All of the mentioned

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which datatype can store unstructured data in a column?

  1. CHAR

  1. RAW

  1. VARCHAR

  1. NUMERIC

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is also called an INNER JOIN?

  1. SELF JOIN

  1. EQUI JOIN

  1. NON-EQUI JOIN

  1. None of the above

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?

Discover more resources for Professional Development