Full Access Oracle 1z0-071 Tutorials

• A: This statement is correct. It orders the employees by salary and fetches the first 3 rows.
• B: This statement has a typo with "FETCE" and "RONS" which should be "FETCH" and "ROWS". Hence, it will not execute successfully.
• C: This statement will not execute successfully due to syntactical errors and incorrect use of the ORDER BY clause.
• D: This statement is correct. It uses a subquery to order employees by salary and then limits the results to the first 3 using the ROWNUM pseudo-column.
• E: This statement will not execute successfully because ROWNUM is evaluated before the ORDER BY clause, so it would return the first 3 rows based on the table's natural order, not the lowest salaries.

The behavior of ROWNUM and the FETCH FIRST syntax are explained in the Oracle Database SQL Language Reference 12c.

Equijoins are joins that use the equality operator (=) to match rows. Non-equijoins are joins that use operators other than the equality operator.

A. False. This condition is an equijoin as it uses the equality operator (=).

B. True. This join condition uses the BETWEEN operator, which is not based on equality.

C. False. A natural join is a type of equijoin where the join is made on all columns with the same names in both tables.

D. False. USING clause is used to specify an equijoin on one or more columns.

E. True. This join condition uses the greater than or equal to (>=) operator, making it a non-equijoin.

Object privileges applicable to tables, views, and sequences in Oracle are:

B. REFERENCES can be granted only on tables. It allows the grantee to create a foreign key that refers to the table.

D. SELECT can be granted on tables and views. This allows the grantee to perform a SELECT on the table or view.

A, C, and E are incorrect. Specifically:

• A is incorrect because DELETE cannot be granted on sequences; it is a privilege applicable to tables and views.
• C is incorrect because INSERT cannot be granted on sequences; INSERT is applicable only to tables and views.
• E is incorrect because ALTER is a privilege applicable to tables and indexes, not sequences.

References:

• Oracle Database SQL Language Reference, 12c Release 1 (12.1): "GRANT"

B: True. The MAX and MIN functions can be applied to columns with character data types. These functions will return the highest or lowest values in a set of rows, based on alphabetical order for character data. This allows these aggregate functions to be versatile and useful across different data types, including numerical, date, and character types.