| Other Oracle General Interview Questions |
|| Asked @
|Can a Tablespace hold objects from different Schemes ?
|Why required to run root.sh at the time of installation and
what exactly it will do
|Define Normalization with example?
|when loggined as SYSTEM,how to display all the users of database using sql query?
|If I have a select statment which retrives 2 rows, & that
rows have the same data in all the fields except the last
field and I want to merge the 2 rows to be in 1 row with
concatenating the last field which have the different
data.... eg: the 1st row has these fields: A-B-C
the second row has: A-B-X ........ i want to merge the two
row to be in one row like ----> A- B- C,X
|what is the output of select * from emp where null=null &
select * from emp where 1=1
|1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
|Define the terms primary key foreign key and also the
difference between primary and the unique key
|23. Display the client name for all clients who have placed
an order where any order line has more than 3 items. Do not
use a table join anywhere in your query.
|Can we create more than one constraint to column ?
|i have a table with the columns below as
Emp_ID Address_ID Address_Line City Country
-------- --------- ----------- ------ ---------
Q: Display the Emp_ID's those having more than one
|What is mean by Program Global Area (PGA) ?
|For more Oracle General Interview Questions Click Here |