SQL Transactional statements Interview Questions

• After one Begin Transaction a truncate statement and a RollBack

• ANY?

• Can a Byte object be cast to a double value?

• Can an exception be rethrown?

• Can an object be garbage collected while it is still reachable?

• Define candidate key, alternate key, composite key?

• Difference between Delete and Truncate?

• Difference between sysusers and syslogins?

• Does a class inherit the constructors of its superclass?

• How are commas used in the intialization and iteration parts of a for

• How can I randomly sort query results?

• How can I send a message to user from the SQL Server?

• How do you differentiate Local and Global Temporary table?

• How is rounding performed under integer division?

• How the Exists keyword works in SQL Server?

• How to call a COM dll from SQL Server 2000?

• How to find dependents of a table?

• How to list all the tables in a particular database?

• How will you find structure of table, all tables/views in one db, all

• How will you show many to many relation in sql?

• If a class is declared without any access modifiers, where may the

• If a method is declared as protected, where may the method be

• If a variable is declared as private, where may the variable be

• Is "abc" a primitive value?

• Is a class a subclass of itself?

• Is the ternary operator written x : y ? z or x ? y : z ?

• Name the eight primitive Java types.

• sp_who

• There are 50 columns in a table. Write a query to get first 25

• to select date part only

• What are cursors? Explain different types of cursors. What are the

• What are defaults? Is there a column to which a default can't be

• What are global variables? Tell me some of them?

• What are keys in RDBMS? What is a primary key/ foreign key?

• What are the constraints for Table Constraints define rules regarding

• What are the series of steps that happen on execution of a query in a

• What classes of exceptions may be caught by a catch clause?

• What is #, ##, @, @@ means?

• What is a pass-through query?

• What is an abstract method?

• What is an object's lock and which object's have locks?

• What is casting?

• What is DATEPART?

• What is DDL?

• What is denormalization and when would you go for it?

• What is DML?

• What is Dynamic Cursor? Suppose, I have a dynamic cursor attached to

• What is the % operator?

• What is the advantage of the event-delegation model over the earlier

• What is the difference between a CONSTRAINT AND RULE?

• What is the difference between a Local temporary table and a Globa
• 
  
• l
• What is the difference between a static and a non-static inner class?

• What is the difference between a while statement and a do statement?

• What is the difference between Primary Key and Unique Key?

• What is the difference between the Reader/Writer class hierarchy and

• What is the purpose of the File class?

• What is the purpose of the System class?

• What is the Referential Integrity?

• What is the return type of a program's main() method?

• What is the row size in SQL Server 2000?

• What is the system function to get the current user's user id?

• What is the use of shell commands? xp_cmdshell

• What is the value of @@Rowcount at each stmt levels?

• What is Transaction?

• What is use of shrink database?

• What modifiers can be used with a local inner class?

• What modifiers may be used with an interface declaration?

• What must a class do to implement an interface?

• What restrictions are placed on method overloading?

• What restrictions are placed on the values of each case of a switch

• What value does read() return when it has reached the end of a file?

• When a query is sent to the database and an index is not being used,

• When can an object reference be cast to an interface reference?

• When does the compiler supply a default constructor for a class?

• Which class is extended by all other classes?

• Which class should you use to obtain design information about an

• Which event (Check constraints, Foreign Key, Rule, trigger, Primary

• Which non-Unicode letter characters may be used as the firs

Posted in: