Sreejobs Logo
   For Latest Job Updates Online Exams
Home Govt Jobs IT Fresher Jobs IT Exp Jobs IT Walk-Ins MBA Jobs BPO Jobs Register FAQ’s Post Job Contact Us
SreeJob Fees   Feeds
Hot Jobs
Welcome Guest
Login | Register
Total No Of Questions: 100.
1) Which two program declarations are correct for a stored program unit? (Choose two)

2) Which three are true statements about dependent objects? (Choose three)

3) 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 the details 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 load the data most efficiently?

4) You create a DML trigger. For the timing information, which is valid with a DML trigger?

5) View the Exhibit and examine the data in ORDERS and ORDER_ITEMS tables.You need to create a view that displays the ORDER ID, ORDER_DATE, and the total number of items in each order. Which CREATE VIEW statement would create the view successfully?

6) 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.)

7) How can you migrate from a LONG to a LOB data type for a column?

8) View the Exhibit and examine the description of the EMPLOYEES table.You want to display the EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT_ID for all the employees who work in the same department and have the same manager as that of the employee having EMPLOYEE_ID 104. To accomplish the task, you execute the following SQL statement: SELECT employee_id, first_name, department_id FROM employees WHERE (manager_id, department_id) =(SELECT department_id, manager_id FROM employees WHERE employee_id = 104) AND employee_id <> 104; When you execute the statement it does not produce the desired output. What is the reason for this?

9) Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)

10) View the Exhibit and examine the structure of the EMPLOYEES table.You want to retrieve hierarchical data of the employees using the top-down hierarchy. Which SQL clause would let you choose the direction to walk through the hierarchy tree?
Page 1 of 10
Home | Register for Job Updates | Contact Us