Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is sql profiler

Fidelity,

2 7601

What is the diff between Truncate table / delete

purge

TCS,

3 13240

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 6003

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 7715

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

CGI, TCS,

1 4113

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

CGI, Quest,

2 4906

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

CGI,

2 5479

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

CGI,

6 8139

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 4945

What is Difference Between delete and Truncate?

9 7030

What is Difference between StoredProcedure and function?

3 5260

what is Difference between Having and Where clause?

IBM,

5 7907

How many rows will return from dual table?

Fujitsu,

4 9029

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 3666

select top 3 sal from each dept?

IBM, TCS,

17 19018


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

How do you declare a user-defined exception?

205


Can we use rowid as primary key?

163


How can use stored procedures in sql?

231


How do I create a memory optimized filegroup?

181


How does a trigger work?

179






What is PL/SQL Records?

248


What is memory optimized?

180


What is dialect in sql?

178


What is query optimization in sql?

183


How do I use google cloud in sql?

167


What is the difference between explicit and implicit cursors in oracle?

199


what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

189


Which join condition can be specified using on clause?

173


How can you know that statistics should be updated?

229


What is multiple partition?

186