COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
select * from member
|
|
|
select * from member where state ____ abbravation="T”
|
|
|
select * from member where state ____ abbrevation==’T’
|
|
|
select * from member where state ____ abbravation is T
|
Detailed explanation-1: -The correct answer to the question “Which of the following is valid SQL for an index” is option (a). CREATE INDEX ID. And all the other options are incorrect and are not valid SQL for an index.
Detailed explanation-2: -Description. The SQL SELECT statement is used to retrieve records from one or more tables in your SQL database.
Detailed explanation-3: -Explanation: Aggregate function is used to perform calculations on multiple values and return the output in a single value. It is mostly used with the SELECT statement. COUNT, SUM, and MAX are all aggregate functions.
Detailed explanation-4: -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.