Exam information

Exam 1Z0-047 – Oracle Database SQL Expert

Other

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 statement is true regarding the effect of 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 SOL statement?

Which statement would create a synonym ORD so that HR can execute the following query successfully?

The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR. Which statement would create a synonym ORD so that HR can execute the following query successfully? SELECT’FROM ord;

Which statement is true regarding the effect of the above SQL statement?

Evaluate the following SQL statement:ALTER TABLE hr.emp SET UNUSED (mgr_id);Which statement is true regarding the effect of the above SQL statement?

Which two statements are true regarding the types of table joins available in Oracle Database 10g?

Which two statements are true regarding the types of table joins available in Oracle Database 10g? (Choose two.)


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

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

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 SECONDFROM dual;What is the correct output of the above query?

Which SQL statement would display the view names and definitions of all the views owned by you?

Which SQL statement would display the view names and definitions of all the views owned by you?

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?

Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command?

Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command? (Choose three.)



Page 1 of 1712345...10...Last »