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

View the Exhibit and examine the data in EMP and DEPT tables.
In the DEPT table, DEPTNO is the PRIMARY KEY.
In the EMP table, EMPNO is the PRIMARY KEY and DEPTNO is the FOREIGN KEY referencing
the DEPTNO column in the DEPT table.
What would be the outcome of the following statements executed in the given sequence?
DROP TABLE emp;
FLASHBACK TABLE emp TO BEFORE DROP;
INSERT INTO emp VALUES (2.COTT 10); INSERT INTO emp VALUES (3,ING 55);

• A.Both the INSERT statements would succeed because none of the constraints on the table are automatically retrieved when the table is flashed back.
• B.Only the first INSERT statement would succeed because all the constraints except the primary key constraint are automatically retrieved after a table is flashed back.
• C.Only the second INSERT statement would succeed because all the constraints except referential integrity constraints that reference other tables are retrieved automatically after the table is flashed back.
• D.Both the INSERT statements would fail because all constraints are automatically retrieved when the table is flashed back.

View the Exhibit and examine the description of the ORDERS table.
Which two WHERE clause conditions demonstrate the correct usage of conversion functions? (Choose two.)

• A.WHERE order_date > T0_CHAR(ADD_M0NTHS(SYSDATE,6),'M0N DD YYYY ')
• B.WHERE order_date > TO_DATE('JUL 10 2006','MON DD YYYY")
• C.WHERE TO_CHAR(order_date,'MON DD YYYY} = 'JAN 20 2003'
• D.WHERE order_date IN (T0_DATE('0ct 21 2003','Mon DD YYYY'), T0_CHAR('N0V 21 2003','Mon DD YYYY'))

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.GROUP BY
• C.WHERE
• D.HAVING
• E.CONNECT BY

ORD is a private synonym for the OE.ORDERS table.
The user OE issues the following command: DROP SYNONYM ord;
Which statement is true regarding the above SOL statement?

• A.Only the synonym would be dropped.
• B.The synonym would be dropped and the corresponding table would become invalid.
• C.The synonym would be dropped and the packages referring to the synonym would be dropped.
• D.The synonym would be dropped and any PUBLIC synonym with the same name becomes invalid.

The details of the order ID, order date, order total, and customer ID are obtained from the ORDERS table. If the order value is more than 30000, the details have to be added to the LARGEjDRDERS table. The order ID, order date, and order total should be added to the ORDERJHISTORY table, and order ID and customer ID should be added to the CUSTJHISTORY table. Which multitable INSERT statement would you use?

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