We cannot add SQL functions, WHERE, and JOIN statements to a view
True
False
DATE() returns the current date
the data type "tinyint" allows whole numbers from 0 to 198
The WHERE keyword cannot be used with aggregate functions.
SQL wildcards must not be used with the SQL LIKE operator.
The IN operator allows you to specify multiple values in a WHERE clause.
How many categories are available for SQL Commands
1
2
3
4
Commit is required after truncate command is issued.
Which of the following is the correct usage of Order by
select col1,col2 from table_a order by col2,col1 desc
select col1,col2 from table_a order by 2,col1 desc
select col1,col2 from table_a order by 2,1
select col1,col2 from table_a order by 1,col2
What are the notations used for writing SQL language
OMEGA
RHO
DELTA
PIE