先試後買

A. It fails because the space specified in single quotation marks after the first two column names is invalid.

B. It executes successfully and displays the column details in three separate columns and replaces only the last column heading with the alias.

C. It fails because the alias name specified after the column names is invalid.

D. It executes successfully and displays the column details in a single column with only the alias column heading.

A. During row source generation, rows that satisfy the query are retrieved from the database and stored in memory.

B. During parsing, a SQL statement containing literals in the WHERE clause that has been executed by any session and which is cached in memory, is always reused for the current execution.

C. During executing, the oracle server may read data from storage if the required data is not already in memory.

D. During optimization, execution plans are formulated based on the statistics gathered by the database instance, and the lowest cost plan is selected for execution.

A. It can be a left outer join.

B. It must be a full outer join.

C. The join key column must have an index.

D. It must be an equijoin.

E. It can be an inner join.

A. ROUND(MOD(25,3),-1) is invalid.

B. TRUNC(MOD(25,3),-1) is invalid.

C. ROUND(MOD(25,3),-1) and TRUNC(MOD(25,3),-1) are both valid and give the same result.

D. ROUND(MOD(25,3),-1) and TRUNC(MOD(25,3),-1) are both valid but give different results.

A. +25-00, +00-650, +00 11:12:10.123457

B. +25-00, +54-02, +00 11:12:10.123457

C. +00-300, +00-650, +00 11:12:10.123457

D. +00-300, +54-02, +00 11:12:10.123457

A. It fails because the join type used is incorrect.

B. It executes successfully and displays the required list.

C. It fails because the ON clause condition is not valid.

D. It executes successfully but displays an incorrect list.

A. PLUS

B. SUBTRACT

C. MINUS

D. INTERSECT

E. UNION

A. SELECT last_name, city FROM members WHERE state ='MO' AND state ='MI';

B. SELECT last_name, city FROM members WHERE state IN ('MO', 'MI');

C. SELECT last_name, city FROM members WHERE state LIKE 'M%';

D. SELECT DISTINCT last_name, city FROM members WHERE state ='MO' OR state
='MI';

A. Self-join

B. Full outer-join with self-join

C. Subquery

D. Left outer-join with self-join

E. Right outer-join with self-join

A. An update to a table can result in no updates to any of the table's indexes

B. A UNIQUE index can be altered to be non-unique

C. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped

D. A table belonging to one user can have an index that belongs to a different user

E. An update to a table can result in updates to any or all of the table's indexes

F. A SELECT statement can access one or more indices without accessing any tables

A. The WHERE clause can be used to exclude rows before dividing them into groups.

B. The aggregate functions and columns used in the HAVING clause must be specified in the SELECT list of the query.

C. The WHERE clause can be used to exclude rows after dividing them into groups.

D. The HAVING clause can be used with aggregate functions in subqueries.

E. The WHERE and HAVING clauses can be used in the same statement only if they are applied to different columns in the table.