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) In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.What is the impact of this setting?


2) Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)


3) Which two statements are true regarding B-tree index? (Choose two.)


4) Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)


5) In a new installation of Oracle Database 11g, you perform these activities: 1. Organize software and data on different subdirectories to avoid poor performance. 2. Use consistent naming conventions for database files. 3. Separate administrative information pertaining to the database in different directories.Which option corresponds to the type of activities you performed?


6) The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users: CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2,v_mgr NUMBER, v_loc NUMBER)BEGIN INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc); END; The users having permission to execute the procedure are able to insert records into the DEPARTMENTS table even though they do not have the INSERT privilege on the table. You want only those users who have privileges on the DEPARTMENTS table to be able to execute the procedure successfully.What would you suggest to the PL/SQL developers to achieve this?


7) Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)


8) Why does performance degrade when many UPDATE, INSERT, or DELETE statements are issued on a table that has an associated Bitmap index?


9) You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The table in which you plan to load data is an important table having various integrity constraints defined on it. Which constraints will remain enabled by default during this operation? (Choose all that apply.)


10) Identify two situations in which the block header grows in a data block. (Choose two.)
Page 1 of 10
Home | Register for Job Updates | Contact Us