What is the function of SMON ?
Latest Answer: perfrom instance recovery when the database is responded after instance fail ...
What type of value does a global variable support ?
Latest Answer: Global variable are forms specifice variable. it can store character value upto 255, for all usages. We can initialize it when we declare, otherwise give error if we did not assign it any value.Oracle 10g it can take upto 4000 bytes. ...
What do you mean by Conceptual? How its helps? Why we go for Conceptual Model?
What are the different values for :SYSTEM.MESSAGE_LEVEL and its impact?
Latest Answer: Some objects are stored in the database and can be created and manipulated with SQL but are not contained in a schema. Its called non schema object. Non schema objects are given below:- Contexts Directories Parameter files (PFILEs) and server parameter ...
Design a suitable database system for a bank along with 20 possible queries to the database (the quries should be such that their solution involves subquries or joins or both). Implement the database and the queries in a commercial DBMS using SQL
Latest Answer: RAISE statement is used to raise exception explicitly with in the EXECUTABLE sectionwhere: Exception is previously declared in declaration section as 'exception'. ...
Latest Answer: select e.ename,sal from emp e where e.sal>(select avg(sal) from emp where e.deptno=deptno) ...
Latest Answer: It seems that, if the main query selects from a great number of rows, than Oracle will have a better execution plan if you use EXISTS. If the main query selects from a small number of rows, while the subquery is heighly selective, then you the ...
View page << Previous 1 [2] 3 4 5 6 7 Next >>

Go Top