What are the three basic rules which are to be followed for the relational model of the database?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Can you have a nested transaction?
Given an employee table, how would you find out the second highest salary?
Which data type cannot be used as a parameter in a udf?
What are triggers? How many triggers you can have on a table?
Explain about normal forms?
Can an extended stored procedure be called from inside a user-defined function?
What is dbms explain in brief?
How to customize error conditions.
Explain about xml databases?
explain detail about ftp in datastage?