Give the count for each daemon when 150 sessions are connected to database provided only 200 concurrent sessions are allowed in that database ?
Provide names of classes that are used in database connection using Oracle,Access database, and MSDE
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
What are the different values for :SYSTEM.MESSAGE_LEVEL and its impact?
Latest Answer : There are 25 Levels of Message in an Oracle Forms.How much cretical error or message is0 -- all errors or message12...25 -- don't shows anyIf we don't wannat show any error or message to the user then we assign 25 to message level ...
What will be the outputdbms_shared_pool.keep('sys.standard','p');
How can we force the database to use the user specified rollback segment?
Query 1.
SELECT sal FROM emp e WHERE sal < any (SELECT sal FROM empWHERE empno=e.mgr)
(o/p:11 row)
Query 2.
SELECT SAL FROM emp e WHERE sal < any (SELECT sal FROM empWHERE mgr=e.empno)
(o/p:1
Latest Answer : how this query is possible i dont know, how the emp number and manager number will be same, i think the query in meaning less r am not understanding properly i dont know,,,, Let some one explain this...! ...
What difference does it make to a Oracle developer while using RAC ? Would/Should he realise that it is a RAC Database ?
