| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to Generate a Series of Random Integers With T-SQL? | | 1 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 2 |
| What is the basic difference between clustered and a
non-clustered index? | | 2 |
| Can we create clustered index on non primary key column | CTS | 11 |
| what is curser. | | 7 |
| How to find the date and time of last updated table? | | 3 |
| What are the main control-of-flow T-SQL constructs?
| | 1 |
| internal language used in sql server 2000? | | 1 |
| select top 5 * from emp order by newid()
my question is , how this query get executed? | | 2 |
| Wht is SQL Injection Attack ? | | 1 |
| Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables? | | 1 |
| What are the new features in SQL Server 2005? | Emphasis | 2 |
| What's the maximum size of a row? | | 4 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | HCL | 2 |
| How do we get month name in SQL Server 2000, Oracle, MS Access? | | 4 |
| What are the different types of replication? How are they used? | | 3 |
| What is a function? Give some example? | | 1 |
| Explain DBMS, RDBMS? | | 4 |
| In performance wise distinct is good or group by is good?
eg:select name from emp group by name;
select distinct name from emp; | Infosys | 2 |
| What is the use of CASCADE CONSTRAINTS? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map