Can MS SQL Server be used for transation process

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Can MS SQL Server be used for transation processing as well as data warehousing database?

Yes. You can use MS SQL Server for processing transactions or storing large data for reporting.

(Continued on next question...)

Other Job Interview Questions

• By default, MS SQL Server sets the index fill factor to 100%. What does this mean?
• What is the purpose of IAM (Index Allocation Map) in MS SQL Server?
• What is the default login account used by the installation process, when you are doing an unattended installation of MS SQL Server?
• What is the meaning of an Outer Join operatin of two tables?
• What is the meaning of the following T-SQL command: DBCC SHRINKDATABASE ( Database, 10%)
• Is T-SQL language syntax case-sensitive?
• What is a Stored Procedure in MS SQL Server?
• What information do you need to identify a remote MS SQL Server to make a connection request?
• What is the fully qualified naming convention to specify a table in a linked Oracle database from MS SQL server?
• What is the meaning of the following T-SQL command: "GRANT CREATE TABLE TO <username>"
• More...