Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is sql profiler

Fidelity,

2 10369

What is the diff between Truncate table / delete

purge

TCS,

3 15826

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

CGI,

1 7919

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

CGI, IBM,

4 10586

What are the difference between Functions/Stored Procs and Triggers and where are they used.

CGI, TCS,

1 6166

Can you have multiple SPs with the same name on a database?

CGI, Quest,

2 7115

Can you create a table with Primary Key not as the clustered index.

CGI,

2 7714

Can you have multiple SPs with the same name on a database?

CGI,

6 12283

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

KPIT,

4 7776

What is Difference Between delete and Truncate?

9 12016

What is Difference between StoredProcedure and function?

3 7668

what is Difference between Having and Where clause?

IBM,

5 11156

How many rows will return from dual table?

Fujitsu,

4 12151

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 5423

select top 3 sal from each dept?

IBM, TCS,

17 27950


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Do ddl statements need commit?

1020


Why do we use sql constraints?

1212


What is the difference between null value, zero, and blank space?

1250


Mention what plvcmt and plvrb does in pl/sql?

1198


Is not null in sql?

1041


What are the most important characteristics of pl/sql?

1224


What are commit, rollback, and savepoint?

1045


Does a join table need a primary key?

995


what are the limitations of identity column? : Transact sql

1159


What are the ddl commands?

1053


Where can I learn sql for free?

1040


What is an emotional trigger?

1057


How does a covering index work?

1008


what is the difference between clustered and non clustered index in sql? : Sql dba

1185


How many types of cursors supported in pl/sql?

1254