1Z1-047 試験問題を無料オンラインアクセス

View the Exhibit and examine the structure of the MARKS_DETAILS and MARKStables.
Which is the best method to load data from the MARKS DETAILStable to the MARKStable?

• A.Pivoting INSERT
• B.Unconditional INSERT
• C.Conditional ALL INSERT
• D.Conditional FIRST INSERT

View the Exhibit and examine the details of the EMPLOYEES table.
You want to generate a hierarchical report for all the employees who report to the employee
whose EMPLOYEE_ID is 100.
Which SQL clauses would you require to accomplish the task? (Choose all that apply.)

• A.START WITH
• B.HAVING
• C.CONNECT BY
• D.WHERE
• E.GROUP BY

View the Exhibit and examine the description of the EMPLOYEES table.
You executed the following SQL statement:
SELECT first_name, department_id, salary
FROM employees
ORDER BY department_id, first_name, salary desc;
Which two statements are true regarding the output of the above query? (Choose two.)

• A.The values in the FIRST_NAME column would be sorted in ascending order for all the employees having the same value in the DEPARTMENT_ID column.
• B.The values in the FIRST_NAME column would be sorted in the descending order for all the employees having the same value in the DEPARTMENT_ID column.
• C.The values in the SALARY column would be sorted in descending order for all the employees having the same value in the DEPARTMENT_ID and FIRST_NAME column.
• D.The values in the SALARY column would be sorted in descending order for all the employees having the same value in the DEPARTMENT_ID column.
• E.The values in all the columns would be sorted in the descending order.

Which two statements are true regarding multiple-row subqueries? (Choose two.)

• A.They use the < ALL operator to imply less than the maximum.
• B.They can be used to retrieve multiple rows from a single table only.
• C.They can contain group functions.
• D.They always contain a subquery within a subquery.
• E.They should not be used with the NOT IN operator in the main query if NULL is likely to be a part of the result of the subquery.

Evaluate the following SELECT statement and view the Exhibit to examine its output: SELECT constraint_name, constraint_type, search_condition, r_constraint_name, delete_rule, status FROM user_constraints WHERE table_name = ORDERS
Which two statements are true about the output? (Choose two.)

• A.In the second column, indicates a check constraint.
• B.The STATUS column indicates whether the table is currently in use.
• C.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.
• D.The R_CONSTRAINT_NAME column gives the alternative name for the constraint.