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) Which two dopes the INSTEAD OF clause in a trigger identify? (Choose two)


2) In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?


3) Examine the commands: CREATE TYPE typ_course_tab IS VARRAY(5) OF VARCHAR2(20) / CREATE TYPE typ_course_nst AS TABLE OF typ_course_tab / CREATE TABLE faculty (faculty_id NUMBER(5), faculty_name VARCHAR2(30), courses typ_course_nst) NESTED TABLE courses STORE AS course_stor_tab / INSERT INTO faculty VALUES (101, 'Jones', NULL); UPDATE (SELECT courses FROM faculty WHERE faculty_id=101) SET courses = typ_course_nst(11,'Oracle'); Which statement is true about the execution of these commands?


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


5) View the Exhibit and examine the descriptions of ORDER_ITEMS and ORDERS tables.You want to display the CUSTOMER_ID, PRODUCT_ID, and total (UNIT_PRICE multiplied by QUANTITY) for the order placed. You also want to display the subtotals for a CUSTOMER_ID as well as for a PRODUCT_ID for the last six months.Which SQL statement would you execute to get the desired output?


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


7) Examine the structure of the EMPLOYEES table in the SCOTT schema. Name Null? Type ----------------------- --------------- --------------- EMPLOYEE_ID NOT NULL NUMBER(6) FIRST_NAME VARCHAR2(20) LAST_NAME NOT NULL VARCHAR2(25) SALARY NOT NULL NUMBER(8,2) COMMISSION_PCT NUMBER(2,2) DEPARTMENT_ID NUMBER(4) View the Exhibit and examine the code for the EMP_TOTSAL procedure created by user SCOTT.Which statement is true regarding the EMP_TOTSAL procedure?


8) Which view displays indirect dependencies, indenting each dependency?


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


10) Which two program declarations are correct for a stored program unit? (Choose two)
Page 1 of 10
Home | Register for Job Updates | Contact Us