| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Which databases are part of SQL server default installation?
Explain the usage of each? | Accenture | 2 |
| How to handle errors in Stored Procedures. I want to display
a message to the user in the .aspx page that is calling a
stored procedure in it's code behind. please help me. | 247Customer | 1 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 1 |
| What are the steps you will take, if you are tasked with
securing an SQL Server?
| HCL | 1 |
| what is maximum size of temp db? | iSoft | 4 |
| how to generate XML out of QUERY? | McAfee | 1 |
| what is the purpose of creating view is sql server 2000 | Wipro | 9 |
| What are the OS services that the SQL Server installation adds? | | 1 |
| How do we get current date in SQL Server 2000, Oracle, MS
Access? | | 11 |
| What is Files and Filegroups in SQL Server & it's
implementation. | Zenith | 1 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| create index a on employee(dno)
In this,which index was created? | | 2 |
| 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 |
| What is the use of CASCADE CONSTRAINTS? | | 2 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | | 1 |
| Differnce between sel server 2000 and 2005 | | 3 |
| How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table? | Leo-Technologies | 12 |
| How to list all tables having unique constraints in any of
the columns in a database. | | 1 |
| Which is best Subquery (or) joins in sql server? explain why | | 2 |
| What all db objects can be found in MSDB database of a SQL
Server instance? | Accenture | 1 |
| |
| For more SQL Server Interview Questions Click Here |