No. Single quotation marks are required when selecting alphanumeric data types. Number data types do not require single quotation marks.
Yes. Multiple conditions can be specified in the WHERE clause of SELECT, INSERT, UPDATE, and DELETE statements.
The DISTINCT option is applied before the WHERE clause.
No. Even though the ALL option can be used, it is not required.
They are sorted as ASCII characters. This means that numbers would be ordered like this: 1, 12, 2, 222, 22222, 3, 33.
Oracle by default performs matches as case-sensitive.
The ordering of the columns in the ORDER BY clause determines the order in which ordering is applied to the statement.
The numbers correspond to the columns defined in the SELECT portion of the query. So the first column is 1, the second is 2, and so on.
False. Only one of the conditions must be TRUE.
False. Only one of the values must match.