| Other SQL PLSQL Interview Questions |
|| Asked @
|select top 3 sal from each dept?
|What is the default value of CHAR type?
|In packages the source code is compiled into p code ? how
do we describe the p code
|| ||3 |
|how many no of table can be join in a sql query.
|| ||4 |
|what is difference between stored procedures and
application procedures,stored function and application
|| ||1 |
|Do view contain data?
|what is the use of HASH, LIST partitions?
|mail-id table contains two columns(email_id,userid)
it contains different types of mail-ids,and no of users.
here username length is differ na,(ex-
now i want to fetch the email-ids only starting from '@'
|| ||5 |
|How toimport .dmp file in lower version of oracle from
higher version ?
|When do we create bitmap indexes
|Name the tables where characteristics of Package, procedure
and functions are stored ?
|| ||3 |
|How will you select unique values from a list of records?
|For more SQL PLSQL Interview Questions Click Here |