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. […]
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?
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;
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? (Choose two.)
A subquery is called a single-row subquery when ____.
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?
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? (Choose three.)