1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is sql profiler

Fidelity,

2 9153

What is the diff between Truncate table / delete

purge

TCS,

3 14347

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 7016

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 9120

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

CGI, TCS,

1 5136

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

CGI, Quest,

2 5977

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

CGI,

2 6586

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

CGI,

6 9814

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 6211

What is Difference Between delete and Truncate?

 9 9054

What is Difference between StoredProcedure and function?

 3 6174

what is Difference between Having and Where clause?

IBM,

5 9232

How many rows will return from dual table?

Fujitsu,

4 10460

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 4405

select top 3 sal from each dept?

IBM, TCS,

17 22758

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How exception is different from error?

533

what is dbms? : Sql dba

534

Is left join inner or outer?

575

Why we use pl sql?

520

What is anonymous block in sql?

627




Does truncate table reset auto increment?

517

How does one use sql*loader to load images, sound clips and documents? : aql loader

660

What is foreign key and example?

499

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6051

What is sqlerrd?

517

What are its different types of dbms?

529

what tools available for managing mysql server? : Sql dba

519

What is the maximum number of columns in sql table?

539

What is a sql driver?

517

What are the advantages of pl sql?

590

For More Un-Answered { SQL PLSQL } Questions Click Here