| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How many index keys possible for a table | | 6 |
| can you anybody tell me the how can you restore the master
database. while migraion(one server to onther server)? | | 1 |
| How to Run a Query on a Remote SQL Server? | | 2 |
| How to Execute an Operating System Command From Within SQL
Server ? | | 2 |
| How do I list the available tables in a database I'm
querying? | | 3 |
| What is the difference between windows authentication and
sql server authentication | HCL | 4 |
| Explain the architecture of SQL Server? | | 2 |
| How do you persist objects, permissions in tempdb | | 1 |
| why cluster and non clusterindex are used in sqlserver 2000?
explain with example | | 1 |
| What is the difference between Drop and Truncate | | 10 |
| What are the authentication modes in SQL Server? | | 2 |
| What is the difference between local table and global table | Polaris | 1 |
| Explain the storage models of OLAP? | | 1 |
| Please give me the SP for the below scenario. I have two
tables named Table1 and Table2...I need to fetch record by
record from Table1 and insert the record in to table2 where
the value in the sno column of the table1 is even number. | Value-Labs | 4 |
| I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz... | Value-Labs | 5 |
| how to select a field with firstletter as capital and
remaining are small letters | | 8 |
| i want table name basis on column name. | | 5 |
| I have student marks in a student table. I need second
highest mark .Then what will the query for this? | Wipro | 23 |
| The Difference between 'Count' and 'Count(*)' | | 12 |
| What is cursor ? And what is difference between Trigger ? | HCL | 1 |
| |
| For more SQL Server Interview Questions Click Here |