| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| About types of indexes in SQL server ? | Cognizent | 1 |
| What value could be assigned to Varchar Type? | | 3 |
| Can I know,how to Execute Funcion and Trigger through
command(Manualy Execution) in MS SQL/SERVER 2005,give me
answer with Example. | | 1 |
| what is replication?
where do u use Go Keyword?
| Satyam | 1 |
| what is advantages in sql 2005 over sql 2000? | | 4 |
| What is the difference between OLEDB and ODBC | CFCI | 3 |
| What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE? | Yardi-Software | 4 |
| how to select 5 to 7 rows from a table, which contains 10 rows? | IBM | 14 |
| What is the difference between a Local temporary table and a
Global temporary table? How is each one used? | | 1 |
| if we have a column (Key) in a table.
and values of that column is
Key
1
1
1
2
2
3
3
4
4
5
5
5
and we want to show the data after query..like..
1(3)
2(3)
3(2)
4(2)
5(3)
how many times a single term comes..
| Rolta | 5 |
| Can we create clustered index on non primary key column | CTS | 14 |
| What is the diff between Static Queries and Dynamic queries
give me some examples | CSC | 1 |
| 1.How to check the backup file details if we do not have
access to that folder
2.how to check the backup file size without connecting to
the folder
| IBM | 1 |
| What is indexed views?
plz explain with example? | | 1 |
| How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
| | 1 |
| How do I list the available tables in a database I'm
querying? | | 3 |
| What do you mean by COLLATION? | | 4 |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| Explain Trigger with an example?
| | 1 |
| Can Somebody tell me the difference between Clustered & Non-
Clustered Index?? | Progressive | 3 |
| |
| For more SQL Server Interview Questions Click Here |