Which query will return a list of the synonyms i

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

(Continued from previous question...)

Which query will return a list of the synonyms in your database?

Answer: select * from sys.synonyms

Explanation: The sys.synonyms catalog view will return the synonyms in a database.

(Continued on next question...)

Other Job Interview Questions

• What are triggers? What are the different types of triggers in SQL Server 2000?
• Which of the following classes provide the context of the caller to SQLCLR Assemblies? Submitted by Michael Coles
• What else should you configure on these instances?
• What can tracer tokens measure in SQL Server 2005 transactional replication?
• What is the default type of XML data if you do not specify an arguement?
• What does the sqlwb utility do?
• You have a SQL Server 2005 cluster and need to add anti-virus software as per your corporate standards. What should you exclude from scans?
• What is the maximum number of instances of Analysis Services 2005 can be installed on a server?
• When discussing image support in Report Builder, which of the following is the most accurate statement?
• What does this return?
• More...