Q) In a table, a column contains duplicate value, if you want to list all different value only, then which SQL clause is used?
- SQL DISTINCT
- SQL UNIQUE
- SQL BETWEEN
- SQL Exists
Q) To give a temporary name to a table, or a column in a table for more readability, what is used?
- SQL Wildcards
- SQL aliases
- SQL LIKES
- SQL Comments
Q) What does below SQL statement describe?
SELECT CustomerName, Address + ‘, ‘ + City + ‘, ‘ + Country AS Address
- Alias named Address column will be created and under this Address, City and Country will be printed as combined statement.
- Alias named Address will be created for Country columns
- Alias named Address column will be created and under this all CustomerName, address, city and country will be printed as combined statement
- All above options are wrong
Q) Logical operators used in SQL are
- AND, OR , NOT
- &&, ||, !
- None of the above