Infibee.com : Top 50 advanced Structured Query Language Interview Questions and Answers for free

31.

In the WHERE clause, are single quotation marks required for all the data?

No. Single quotation marks are required when selecting alphanumeric data types. Number data types do not require single quotation marks.

32.

Can multiple conditions be used in the WHERE clause?

Yes. Multiple conditions can be specified in the WHERE clause of SELECT, INSERT, UPDATE, and DELETE statements.

33.

Is the DISTINCT option applied before or after the WHERE clause?

The DISTINCT option is applied before the WHERE clause.

34.

Is the ALL option required?

No. Even though the ALL option can be used, it is not required.

35.

How are numeric characters treated when ordering based upon a character field?

They are sorted as ASCII characters. This means that numbers would be ordered like this: 1, 12, 2, 222, 22222, 3, 33.

36.

How does Oracle handle its default case-sensitivity differently from MySQL and Microsoft SQL Server?

Oracle by default performs matches as case-sensitive.

37.

How is the ordering of the fields in the ORDER BY clause important?

The ordering of the columns in the ORDER BY clause determines the order in which ordering is applied to the statement.

38.

How is the ordering determined in the ORDER BY clause when you use numbers instead of column names?

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.

39.

True or false: Both conditions when using the OR operator must be TRUE.

False. Only one of the conditions must be TRUE.

40.

True or false: All specified values must match when using the IN operator.

False. Only one of the values must match.