Basic SQL Quiz By - M Khan

Explanation
In SQL, when sorting data, the default behavior is to sort alphabetically rather than logically. This means that if we have a list of values, SQL will sort them based on their alphabetical order rather than considering their logical order or any specific criteria. For example, if we have a list of numbers, SQL will sort them as if they were strings, resulting in an alphabetical order rather than a numerical order. Therefore, the statement "Sorts are Alphabetical in SQL, not Logical" is true.

Explanation
The given syntax "Grade_pt AS AVG" is incorrect because it does not follow the correct alias syntax. In alias syntax, the keyword "AS" is used to assign an alias to a column or expression. The correct syntax would be "Grade_pt AS AVG" where "Grade_pt" is the column or expression being aliased and "AVG" is the alias assigned to it.

Explanation
The given SQL query is correct and will not show a syntax error. It will display all the rows from the Student_table where the Grade_pt is either 3.0 or 4.0.

Explanation
The order of precedence in SQL is determined by the use of parentheses, followed by the NOT operator, and then the AND and OR operators. In this case, the correct answer is "( ) NOT AND OR" which means that expressions inside parentheses are evaluated first, followed by the NOT operator, and then the AND and OR operators. This order ensures that the logical operations are performed in the correct sequence, allowing for accurate query results.

Explanation
The LIKE keyword in SQL is used to search for a specified pattern in a column. It supports the use of two special characters: '%' and '_' (underscore). The '%' character is used to represent any sequence of characters, while the '_' character is used to represent a single character. Therefore, the correct answer is % and _ (underscore).