What result would you expect from this statement

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

(Continued from previous question...)

What result would you expect from this statement?
Select * from dbo .MyTable

Answer
All records from [dbo].[MyTable]

Explanation
The answer is all records from [dbo].[MyTable]. Qualified names can include white space before and after the dots. Restrictions apply only to the names themselves that may need quoted identifiers with embedded white space or invalid characters.

(Continued on next question...)

Other Job Interview Questions

• Which table would you query in your report to get logging information about a job step?
• How can you get SQL Server 2005 to simulate multiple processors for query testing?
• Which of the following is not true about the Raw File Destintion connection in SQL Server 2005 Integration Services?
• If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?
• You wish to back up the symmetric key used to protect data on the Reporting Services 2005 instance installed on Sales01. From your workstation, what command do you use?
• How can you determine which user is executing statements in Profiler?
• Which of the following is not true about the Raw File Destintion connection in SQL Server 2005 Integration Services?
• Which collation is used for Service Broker messages sent between the instances?
• You are troubleshooting a Service Broker application ...
• If you have a replication scenario with one publisher, one distributor and one subscriber and the transaction isolation level is not set to serializable, what happens when a transaction fails on the publisher?
• More...