Notice: Undefined index: exam_geven in /home/ksv69uw2i08d/public_html/onlineexam/exam.php on line 18
ORACLE Online Examination
Sreejobs Logo
   For Latest Job Updates  
 sreenutech.com 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
Search:
SreeJob Fees   Job Feeds
Hot Jobs
Welcome Guest
Login | Register
Total No Of Questions: 100.
1) Which two statements are true about associative arrays and varrays? (Choose two.)


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


3) Which four triggering events can cause a trigger to fire? (Choose four)


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


5) When creating a function in SQL *Plus, you receive this message: �Warning: Function created with compilation errors.� Which command can you issue to see the actual error message?


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


7) Examine this package specification: CREATE OR REPLACE PACKAGE concat_all IS v_string VARCHAR2(100); PROCEDURE combine (p_num_val NUMBER); PROCEDURE combine (p_date_val DATE); PROCEDURE combine (p_char_val VARCHAR2, p_num_val NUMBER); END concat_all; / Which overloaded COMBINE procedure declaration can be added to this package specification?


8) Which two statements describe the state of a package variable after executing the package in which it is declared? (Choose two)


9) View the Exhibit and examine the procedure to create a trigger name based on the table name supplied to the procedure. Which three statements are appropriate for protecting the code in the procedure from SQL injection? (Choose three.)


10) Which statements are true? (Choose all that apply)

Notice: Undefined offset: 100 in /home/ksv69uw2i08d/public_html/onlineexam/exam.php on line 418
Page 1 of 10
Home | Register for Job Updates | Contact Us