| Other SQL PLSQL Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| select top 3 sal from each dept? |
IBM | 13 |
| What is the default value of CHAR type? |
Bosch | 2 |
| 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
function?
|
| 1 |
| Do view contain data? |
Ramco | 6 |
| what is the use of HASH, LIST partitions? |
ITC-Infotech | 1 |
| 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-
tamil@yahoo.com,joshua@hotmail.com like)
now i want to fetch the email-ids only starting from '@'
(ex-@gmail.com,@yahoo.com,@hotmail.com |
| 5 |
| How toimport .dmp file in lower version of oracle from
higher version ? |
TCS | 4 |
| When do we create bitmap indexes |
CTS | 2 |
| Name the tables where characteristics of Package, procedure
and functions are stored ? |
| 3 |
| How will you select unique values from a list of records? |
Cap-Gemini | 5 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
