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   Feeds
Hot Jobs
Welcome Guest
Login | Register
Total No Of Questions: 100.
1) To be callable from a SQL expression, a user-defined function must do what?


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


3) Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE; The sequence SEQ1 has generated numbers up to the maximum limit of 200. You issue the following SQL statement: SELECT seq1.nextval FROM dual; What is displayed by the SELECT statement?


4) View the Exhibit and examine the description of the CUSTOMERS table.You want to add a constraint on the CUST_FIRST_NAME column of the CUSTOMERS table so that the value inserted in the column does not have numbers.Which SQL statement would you use to accomplish the task?


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


6) Which three tasks can be performed using regular expression support in Oracle Database 10g? (Choose three.)


7) The database instance was started up using the automatic memory management feature. No value was set for the RESULT_CACHE_MAX_SIZE parameter. Examine the following initialization parameter settings for your database: MEMORY_TARGET = 500M RESULT_CACHE_MODE = MANUAL You execute a query by using the result_cache hint. Which statement is true in this scenario?


8) What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?


9) Which three tasks can be performed using regular expression support in Oracle Database 10g? (Choose three.)


10) Examine the structure of the LOB_STORE table. Name Null? Type ---------------- -------- ------------ LOB_ID NUMBER VIDEO_CLIP BLOB You create a 'DATA_FILES' directory object that contains the 'IMAGE1.GIF'operating system (OS) file.View the Exhibit and examine the LOAD_LOB procedure code that you execute for reading data from the OS file into the BLOB column. It is created with compilation errors. What is the reason?
Page 1 of 10
Home | Register for Job Updates | Contact Us