COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
hich of the following statements about the MAX function in SQL are true?
|
|
Can be used on any datatype.
|
|
|
Returns the max value of the attribute.
|
|
|
It is an aggregate function.
|
|
|
All of the above statements are true.
|
Explanation:
Detailed explanation-1: -The MAX() function returns the largest value of the selected column.
Detailed explanation-2: -Which of the following statement is true? Explanation: The SQL TRUNCATE command is used to delete all the rows from the table and free the space containing the table.
Detailed explanation-3: -The correct answer to the question “Which of the SQL statements is correct” is option (b). SELECT Username, Password FROM Users. And all the other options are incorrect.
Detailed explanation-4: -Q 1-Which of the following is not true about SQL statements? A-SQL statements are not case sensitive.
There is 1 question to complete.