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 9151

What is the diff between Truncate table / delete

purge

TCS,

3 14335

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 7011

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 9116

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

CGI, TCS,

1 5128

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

CGI, Quest,

2 5962

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

CGI,

2 6575

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

CGI,

6 9803

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 6210

What is Difference Between delete and Truncate?

 9 9044

What is Difference between StoredProcedure and function?

 3 6168

what is Difference between Having and Where clause?

IBM,

5 9227

How many rows will return from dual table?

Fujitsu,

4 10453

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 4399

select top 3 sal from each dept?

IBM, TCS,

17 22729

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is it possible to sort a column using a column alias?

599

What is using in sql?

549

What is mutating trigger?

563

What is the use of sqldataadapter?

521

What are all ddl commands?

532




Explain exception handling in pl/sql?

520

What is pl sql block structure?

531

how would concatenate strings in mysql? : Sql dba

555

How global cursor can be declare with dynamic trigger ?

1737

What does pl sql developer do?

501

What can sql server reporting services do?

567

Is sql a scripting language?

503

What does select top 1 do in sql?

528

Explain the uses of a database trigger?

555

What are the different types of constraints?

552

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