Sybase interview questions SET III:

1. How Does Sybase know to what extent a transaction has to be rolled back ? sybase rollback thr transaction upto where it begins(that is to Begn commit)
2. How do you check whether the rollback was correct? By checking the @@trancount value before rollback statement execute How to import table using “INSERT” statement?insert tablename (column list) select [column list] from table name1
3. How do you select unique rows using Sybase? using Distinct keyword
4. How many database Sybase 11 have ,list out with explanations?four.Master,Model,sybsystemprocs,tempdb
5. What is Roll Forward and Roll Back? Roll forward : commited transaction not written to data area are rolled forward into the data.Roll back:uncommited transaction rollback all data modification done with in transaction are reversed
6. What is Dirty reads and how its differ from Phantom reads? when one transaction reads a set of rows that satisfy a search condition, and then a second transaction modifies the data (through an insert, delete, update, and so on). If the first transaction repeats the read with the same search conditions, it obtains a different set of rows.
7. How will you Restart and Exit on while loop? continue,break
8. How many columns can table have? 250
9. Give me the syntax for creating user-Defined Datatypes? sp_addtype type_name,system_type,{nullnot nullidentity}
10. How shall I simulate from level 0 to level 3 in Isolation? using holdlock
11. Can I explicitly insert a value in a Identity column? set identity_insert on
12. Can I change the data type of column ? yes using modify keyword
13. What is isnull function? It substitues a specified value for a null value in a column in a query or an aggregate function