| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| What is the basic functions for master, msdb, tempdb databases? | CSC | 2 |
| How to find the date and time of last updated table? | | 3 |
| can you any body tell me the how to decrease the logfile | | 4 |
| What is the difference between Userdefined function and
stored procedure? Explain and give the example also | | 4 |
| what is the output for this query
select * from employee where 1=1; | | 4 |
| About DTS usage ? | Cognizent | 2 |
| What value could be assigned to Varchar Type? | | 3 |
| Can we rewrite subqueries into simple select statements or
with joins? Example? | ASD | 1 |
| Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables? | | 2 |
| How to select nth record from a table? | DELL | 9 |
| When do you create cluster and noncluster index? | Satyam | 4 |
| Can Having clause be used without Group by clause? | CTS | 4 |
| please can anyone answer this query
Table 1 has 2 columns: EmployeeId,Age
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region who has the oldest person | | 7 |
| How to give a user the option of importing Excel and a
delimited text file into a SQL Server Database without
manually using SQL DTS?
| GE | 1 |
| What is referential integrity? What are the advantages of it? | Digital-Domain | 3 |
| how to find out the repeated value from table using groupby
function? | | 3 |
| Can store procedure call by user define function in SQL
server? | HCL | 6 |
| In which year relase the 7.0& 2000 & 2005? | | 1 |
| How can I create a plain-text flat file from SQL Server as
input to another application? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
