Which technique should be used to load the data most efficiently?

You need to load information about new customers from the NEW_CUST table into the tables CUST and CUST_SPECIAL. If a new customer has a credit limit greater than 10,000, then thedetails have to be inserted into CUST_SPECIAL. All new customer details have to be inserted into the CUST table. Which technique should be used to […]

Read More

A subquery is called a single-row subquery when ____.

A subquery is called a single-row subquery when ____. A.the inner query returns a single value to the main query B.the inner query uses an aggregate function and returns one or more values C.there is only one inner query in the main query and the inner query returns one or more values D.the inner query […]

Read More

What is the correct output of the above query?

Evaluate the following query: SELECT INTERVAL ‘300’ MONTH, INTERVAL ’54-2′ YEAR TO MONTH, INTERVAL ’11:12:10.1234567′ HOUR TO SECOND FROM dual; What is the correct output of the above query? A. +25-00 , +54-02, +00 11:12:10.123457 B. +00-300, +54-02, +00 11:12:10.123457 C. +25-00 , +00-650, +00 11:12:10.123457 D. +00-300 , +00-650, +00 11:12:10.123457 Show Answer

Read More

Which statement is true regarding the above SQL statement?

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 SQL 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 […]

Read More