What are cursors? Explain different types of cursors?6 24012
What are the disadvantages of cursors? How can you avoid cursors?2 8605
Explain the general syntax for a SELECT statements covering all the options.3 5075
What is a join and explain different types of joins?2 3607
Can you have a nested transaction?1 1695
What is an extended stored procedure?1 3604
Can you instantiate a COM object by using T-SQL?1 2563
What is the system function to get the current user's user id?3 4046
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?1569
Given an employee table, how would you find out the second highest salary?9 9134
What is normalization? Explain different levels of normalization?8 56471
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?1 8087
1. Using the XML Document below, with the URI “recipe.xml”
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
What are the three basic rules which are to be followed for the relational model of the database?
What are the types of database model?
Explain what a database is?
Explain the role of indexing in databases?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
What is an application role and explain a scenario when you would use one?
Explain about query and reporting.
How to read and create .LDC data files which are used by linguatic dictionary.
What is dbms explain in brief?
What are data modelling techniques?
Write the fastest query to find out how many rows exist in a table?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
How to use online Backups?
State the acid rules?