| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are tasks? | Wipro | 1 |
| 1. What are the grouping function in SQL ?
2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?
3. Difference between DROP, DELETE, TRUNCATE table ?
4. What is constraints and types ?
5. What is max size of nchar & nvarchar ?
6. Define ROLLBACK, COMMIT, SAVE POINT
7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise
8. Select 10 rows from a table ?
9. Define DML, DDL, DCL, DTL commands ?
10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?
11. Default constraints ?
12. Can we have more then primary Key in table ?
13. Type of integrity ? Entity, Referential, Domain ?
| Perot-Systems | 8 |
| How would you Update the rows which are divisible by 10,
given a set of numbers in column? | | 1 |
| SQL stops working in every 15 days displaying message that
database log file is full. Log file size is 3.95 GB. It is
happening after shrinking the database also. What is
solution to overcome this problem. Please help me as it's
urgent. | | 5 |
| WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER? | | 6 |
| MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE | IBM | 1 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 2 |
| What is INTVAL( )and where we use
Plz any body help me | | 1 |
| What is the purpose of using COLLATE in a query? | | 1 |
| to explain sql server 2000 architecture & authentication | | 1 |
| 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 referential integrity and how is it achieved? | Adea-Solutions | 1 |
| Wht is Stuff in sql ser | | 1 |
| What is an execution plan? When would you use it? How would
you view the execution plan? | | 1 |
| What is a trigger? | | 6 |
| How do I list the available tables in a database I'm
querying? | | 3 |
| write down the code for "how we delete a table without
using of Drop command " ? | Sonata | 2 |
| could you please reply for these question:
1.About Use Apply?
2.Avoid cursors - When we have a situation that we can not
avoid the use of cursor than what is the alternate solution?
is there anything we can use instead of cursor to perform
the desired task? which optiomize the peroformance too.
3.What is computed columns?
Thanks in advance.
Regards,
Rupesh
| | 3 |
| wat is the main diff between sql server 2000and sql server 2005 | Jade-Software | 6 |
| How to retrieve data from log files in SQL SERVER ????? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
