SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Define SQL and state the differences between SQL and other conventional programming Languages?

669

What is the location of pre_defined_functions.

632

What is a call statement? Explain with an example.

533

If a cursor is open, how can we find in a pl/sql block?

660

Explain polymorphism in pl/sql.

628

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

586

Is it possible to pass parameters to triggers?

557

What are the different types of triggers?

577

Explain the uses of database trigger.

639

Can a commit statement be executed as part of a trigger?

592

Can a select statement fire a trigger?

640

What are conditional predicates?

575

Does a user_objects view have an entry for a trigger?

565

Explain some predefined exceptions.

573

Does user triggers have entry for trigger with compilation errors?

580


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Are sql database names case sensitive?

488


what is a trigger in mysql? : Sql dba

589


How do I send sql query results to excel?

561


How is pl sql different from sql?

525


Is clustered index a primary key?

520






Can we use delete in merge statement?

504


How to display Row Number with Records in Oracle SQL Plus?

584


Why function is used in sql?

510


What is procedure and function?

505


What are different types of sql?

547


How is indexing done in search engines?

517


What are the disadvantages of not performing database normalization?

583


what is cross join? : Sql dba

560


What is data type in sql?

544


When is the explicit cursor used ?

582