-
Parent Table
A table which consist of atleast one primary or Unique key is called as Parent Table. True / False (Justify)
-
Clasify Constraints
How to clasify the constraints in a table? Which columns are associated to primary, composite primary, unique, and not null constraints while the inserting rows into a table?
-
Use of Constraint Name
What is the use of mentioning of constraint_name along with NOT NULL Constraint _type while creating a table?
-
Savepoint Names List
How do we can see savepoint names list?
-
Identify DML Error
MERGE INTO SAS F USING (SELECT PRODID, PRODID+10 F, DESCRIP FROM PRODUCT) L ON (F.PRODID=L.PRODID) WHEN MATCHED THEN UPDATE SET F.PRODID=L.F WHEN NOT MATCHED THEN INSERT VALUES (L.F, L.DESCRIP)Why does the above give error?
-
Multi Row Sub-Queries
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 row) What is the difference between the above 2 queries.
-
AND - OR Operators
In the combination of Logical Operators - AND, OR (more than 2) operators which one gets 1st preference.
-
Sub Queries Alias Name
SELECT * FROM (SELECT ROWNUM,ENAME,JOB,SAL FROM EMP WHERE ROWNUM
-
Pair and Non Pair Wise Comparison
What is the difference between pair wise & non pair wise comparison in a multiple column subquery. In which case are these used?