On MS SQL Server management tool, how would you

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

(Continued from previous question...)

On MS SQL Server management tool, how would you find what actions you can perform for a particular object?

You can right-mouse-click on that object to display the context menu. Actions allowed for that object will be listed in the context menu.

(Continued on next question...)

Other Job Interview Questions

• What is the meaning of the following T-SQL command: CREATE TABLE orders ...
• What can you do with the "ALTER DATABASE ..." T-SQL command?
• What is the size of an Extent in MS SQL Server?
• What should you do to prepare for MS SQL Server upgrade?
• What is the meaning of the following T-SQL command: SELECT TOP 10 * FROM user WHERE last_name = 'Johnson'
• What does Constraint refer to in MS SQL Server?
• Can MS SQL Server be used for transation processing as well as data warehousing database?
• What is the meaning of the following T-SQL command: EXEC sp_dboption 'OrderDB', 'single user', 'true'
• What does Default Object refers to in MS SQL Server?
• Is it secure to use Windows Authentication to establish a connection to MS SQL Server?
• More...