| Other SQL PLSQL Interview Questions |
|| Asked @
|I have one table,in that table
(1)i have java1.1 version books are 2 and java1.5 version
books are 4.
(2).Net2.0 books are 3, .Net3.5 books are 2
(3)ABC1.6 books are 4, ABC2.0 books are 3.
Now i want output is like
For this i need sql query, please help me if anyone how to
get this result.
|suppose I have two table one Emp and other is dpt.
Emp table has a field ,dept id,name ,sal and dpt table has a
field dept id,dept name.
Now I want to find out the emplyee list whose sal is between
2000-3000 from dept x.
|What are the two parts of a procedure ?
|What will happen after commit statement ?
|Its possible to add more than one primary key for the table
|What are different types of joins ?
|What are the Restrictions on Cursor Variables?
|what is the output of this query selet * from employee
where 1=2 ??
|In a table i have columns A,B,C and i have a composite index
on columns A,B if so will the following query uses index or
WHERE A=<value> AND B=<value> AND C=<value>;
|Can any one tell me how to increase the performance of a
sql query ie what are the performance tips in creating or
writing a sql query !!?
|How packaged procedures and functions are called from the
|How many LONG columns are allowed in a table?
|For more SQL PLSQL Interview Questions Click Here |