SQL FINAL ASSESSMENT
Authored by KVCH CORPORATE
Professional Development
Professional Development
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
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?
CHAR
RAW
VARCHAR
NUMERIC
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is also called an INNER JOIN?
SELF JOIN
EQUI JOIN
NON-EQUI JOIN
None of the above
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 Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
