최신Oracle Database SQL Expert - 1Z0-047무료샘플문제

A. The statement would execute successfully to produce the required output.

B. The statement would not execute because the GROUP BY clause cannot be used in the inline view.

C. The statement would not execute because the ITEM_CNT alias cannot be displayed in the outer query.

D. The statement would not execute because inline views and outer joins cannot be used together.

A. The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.

B. The statement would not execute because the table alias prefix is not used in the USING clause.

C. The statement would not execute because table aliases are not allowed in the JOIN clause.

D. The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.

A. The column DELETE_RULE decides the state of the related rows in the child table when the corresponding row is deleted from the parent table.

B. The STATUS column indicates whether the table is currently in use.

C. In the second column, indicates a check constraint.

D. The R_CONSTRAINT_NAME column gives the alternative name for the constraint.

A. WHERE and HAVING clauses cannot be used together in a SQL statement.

B. The HAVING clause is used to exclude one or more aggregated results after grouping data.

C. The HAVING clause conditions can have aggregate functions.

D. The HAVING clause conditions can use aliases for the columns.

E. The WHERE clause is used to exclude rows before the grouping of data.

A. A subquery can be used to access data from one or more tables or views.

B. Only two subqueries can be placed at one level.

C. A subquery in the WHERE clause of a SELECT statement can be nested up to three levels only.

D. The columns in a subquery must always be qualified with the name or alias of the table used.

E. If the subquery returns 0 rows, then the value returned by the subquery expression is NULL.

A. The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.

B. The statement would not execute because the table alias prefix is not used in the USING clause.

C. The statement would not execute because table aliases are not allowed in the JOIN clause.

D. The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.

A. ALTER TABLE orders
MODIFY customer_id CONSTRAINT orders_cust_id_nn NOT NULL;

B. ALTER TABLE orders
ADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);

C. ALTER TABLE orders
ADD customer_id NUMBER(6)CONSTRAINT orders_cust_id_nn NOT NULL;

D. ALTER TABLE orders
MODIFY CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);

A. It contains the object privileges granted to other users by the current user session.

B. It contains the current system privileges available in the user session.

C. It contains the system privileges granted to other users by the current user session.

D. It contains the current object privileges available in the user session.

A. It is used to form the group sets involved in generating the totals and subtotals.

B. It can only be used with ROLLUP and CUBE operators specified in the GROUP BY clause.

C. It is used to find the groups forming the subtotal in a row.

D. It is used to identify the NULL value in the aggregate functions.

A. a SELECT statement that can be embedded in a clause of another SELECT statement only

B. a set of sequential queries, all of which must always return a single value

C. a set of sequential queries, all of which must return values from the same table

D. a set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query

A. The INTO clause is misplaced in the command.

B. The WHERE clause cannot be used with INSERT.

C. The CUSTOMER_ID column cannot be updated.

D. CUSTOMER VU cannot be used as a data source.

A. They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.

B. The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.

C. They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.

D. They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.

A. Synonyms are used to reference only those tables that are owned by another user.

B. A public synonym and a private synonym can exist with the same name for the same table.

C. Synonyms can be created for tables but not views.

D. The DROP SYNONYM statement removes the synonym, and the status of the table on which the synonym has been created becomes invalid.

A. NATURAL JOIN

B. RIGHT OUTER JOIN

C. LEFT OUTER JOIN

D. FULL OUTER JOIN