What two categories you can divide T-SQL stateme

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

(Continued from previous question...)

What two categories you can divide T-SQL statements into?

We can divide T-SQL statements into Data Definition Language (DDL) Statements and Data Manipulation Language (DML) Statements.

(Continued on next question...)

Other Job Interview Questions

• What is the default login account used by the installation process, when you are doing an unattended installation of MS SQL Server?
• What stored procedure you can execute to find out if a database is set to single-user or multi-user mode?
• What does Trigger refers to in MS SQL Server?
• What is the T-SQL command to create a new login in MS SQL Server?
• What is the meaning of the following T-SQL command: EXEC sp_dboption 'OrderDB', 'single user', 'true'
• Can MS SQL Server be used for transation processing as well as data warehousing database?
• What is the meaning of the NOTRUNCATE option in the "DBCC SHRINKDATABASE" command?
• What is a Rule is MS SQL Server?
• What is the meaning of Data Normalization?
• When revoking one security role from a user, does it affect other security roles granted to same user?
• More...