Un-Answered Questions { SQL PLSQL }

What is the difference among union, minus and intersect?

544


What are the differences between implicit and explicit cursors?

517


Cite the differences between execution of triggers and stored procedures?

617


What is a recursive stored procedure?

614


Define commit, rollback and savepoint?

571


How can we link a sql database to an existing android app?

546


How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

661


what is error ora-03113: end-of-file on communication channel?

599


What is transaction control language (tcl)?

634


What is union and union all keyword in sql and what are their differences?

574


What is the difference between sql and mysql?

551


When can we use the where clause and the having clause?

576


What is an example of translating a date into julian format?

575


What are the different types of constraints?

561


What is data control language (dcl)?

599