SQL Server Interview Questions
Questions Answers Views Company eMail

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 2015

one table has four field id,name,design,salary. i have to find maximum salary .

6 3510

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 8077




you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 2425

How to find the date and time of last updated table?

Teledata,

6 5245

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 18572

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 5845

What value could be assigned to Varchar Type?

3 3078




Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 2993

What types of integrity are enforced by a foreign-key constraint

1 2536

What are the main control-of-flow T-SQL constructs?

1 3216

What are the two virtual tables SQL Server maintains for triggers?

3 5679

What does the INSTEAD OF trigger do?

3 4776

What are explicit and implicit transactions?

BirlaSoft,

4 17270

What are the two types of concurrency?

4 4700


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

application server is slow what may be the problem

1131


where the connection string store in the database

879


How retrieve field names from the table in SQL through JAVA code?

756


What is the difference between NOROW and LOCKROW?

1364


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1336






1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

409


your distribution database is full what will u do

1010


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2733


Delete duplicate rows without using rowid.

244


what are the critical issues you have resloved in your company

886


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

364


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

986


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1403


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1630


How to trouble shoot if unable to connect SQL Server

828