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 10270

What is the diff between Truncate table / delete

purge

TCS,

3 15705

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 7839

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 10429

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

CGI, TCS,

1 6089

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

CGI, Quest,

2 7026

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

CGI,

2 7605

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

CGI,

6 12071

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 7638

What is Difference Between delete and Truncate?

9 11752

What is Difference between StoredProcedure and function?

3 7522

what is Difference between Having and Where clause?

IBM,

5 10987

How many rows will return from dual table?

Fujitsu,

4 12010

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 5333

select top 3 sal from each dept?

IBM, TCS,

17 27523


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is number function in sql?

969


What is the difference between nvl function, ifnull function, and isnull function?

1103


Whis is not false in primary key?

1454


Why use subqueries instead of joins?

1079


Can a primary key be a foreign key?

1022


How do you delete a table?

1074


What is the use of triggers?

1037


What is Difference Between Unique and Primary Key Constraints?

1105


Can one improve the performance of sql*loader? : aql loader

1046


Are stored procedures faster than queries?

944


how to create a table index in mysql? : Sql dba

1061


what are local and global variables and their differences? : Sql dba

1070


What is the process of debugging?

1069


How do sql databases work?

994


What are tables and fields in the database?

1111