SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is meant by tuning and tk proof?

2 12323

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

3 9695

what is definer rights invoke rights?

1 5875

How can we schedule the procedure to run automatically ?

3 9798

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

TCS,

4 12456

What are the Restrictions on Cursor Variables?

2 14976

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

3 9538

what is meant by forward declaration in functions?

TCS,

4 14779

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

1 10708

State the difference between implict and explict cursor's?

CTS,

7 20651

State the advatage and disadvantage of Cursor's?

2 8470

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

TCS,

5 14713

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

2 7986

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 9810

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

1696


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do I save a stored procedure?

511


Why do we need sharding?

512


What is a constraint?

557


what is the difference between myisam static and myisam dynamic? : Sql dba

575


What is pls_integer in pl sql?

527






Why is nosql good?

583


What is sql prepared statement?

534


What is dml and ddl?

511


Why is sharding used?

538


What is a sql instance vs database?

562


How do you select unique values in sql?

494


Why select is used in sql?

507


How does a trigger work?

527


Why are indexes and views important to an organization?

518


Is sql a scripting language?

504