Which of the following is not a DDL command?
UPDATE
Well Done. Your Answer is Correct Keep it Up!
TRUNCATE
ALTER
None of the options are correct
Category: SQL MCQs
_____removes all rows from a table without logging the individual row deletions.
_____removes all rows from a table without logging the individual row deletions.
TRUNCATE
Well Done. Your Answer is Correct Keep it Up!
DROP
REMOVE
DELETE
Which SQL keyword is used to retrieve a maximum value?
Which SQL keyword is used to retrieve a maximum value?
MAX
Well Done. Your Answer is Correct Keep it Up!
UPPER
TOP
MOST
Which of the following SQL clauses is used to DELETE tuples from a database table?
Which of the following SQL clauses is used to DELETE tuples from a database table?
DELETE
Well Done. Your Answer is Correct Keep it Up!
REMOVE
DROP
CLEAR
Which SQL function is used to count the number of rows in a SQL query?
Which SQL function is used to count the number of rows in a SQL query?
COUNT(*)
Well Done. Your Answer is Correct Keep it Up!
SUM()
NUMBER()
COUNT()