SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

what is meant by tuning and tk proof?

2 13470

How would you hide a table in sql. ie the table can be only visible to its maker?

3 11135

what is definer rights invoke rights?

1 6618

How can we schedule the procedure to run automatically ?

3 11198

How toimport .dmp file in lower version of oracle from higher version ?

TCS,

4 14252

What are the Restrictions on Cursor Variables?

2 16147

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 10814

what is meant by forward declaration in functions?

TCS,

4 16555

what is difference between stored procedures and application procedures,stored function and application function?

1 11554

State the difference between implict and explict cursor's?

CTS,

7 23388

State the advatage and disadvantage of Cursor's?

2 9669

How to trace the errors in pl/sql block code?

TCS,

5 16793

How to display the contents of a current record fetched in a reference cursor?

2 9178

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 11377

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2265

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is raw datatype in sql?

1098

what is commit? : Sql dba

1121

What are the parts of a basic sql query?

1010

Give the order of sql select?

1179

What is $$ in sql?

1042

What does := mean in pl sql?

1084

What is trigger in sql? Explain

1037

Why do you partition data?

1061

Does view store data in sql?

1033

What are some predefined exceptions in pl/sql?

1218

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1089

What is bind reference and how can it be created?

1066

What does pl sql developer do?

974

What does sql stand for?

1052

Does truncate remove indexes?

1074

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