SQL FINAL ASSESSMENT

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

• COUNT()

• NUMBER()

• SUM()

• COUNT(*)

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

• DELETE

• REMOVE

• TRUNCATE

• DROP

Which of the following is not a DDL command?

• UPDATE

• TRUNCATE

• ALTER

• None of the Mentioned

Which of the following is a large object data type?

• varchar(max)

• varbinary(max)

• nvarchar(max)

• image

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

• SQL

• DBMS

• RDBMS

• All of the mentioned

Which datatype can store unstructured data in a column?

• 1. CHAR

• 1. RAW

• 1. VARCHAR

• 1. NUMERIC

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

Which SQL command is used to retrieve data from a database?

• INSERT

• DELETE

• SELECT

• UPDATE

Which keyword is used to sort the result set in ascending order?

• SORT

• ORDER

• ORDER BY

• SORT BY

Which of the following SQL commands will delete all records from a table named customers but retain the table structure?

• DROP TABLE customers;

• TRUNCATE TABLE customers;

• DELETE TABLE customers;

• REMOVE ALL FROM customers;