What does this code return? select 6 | 7 Fig

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

(Continued from previous question...)

What does this code return?
select 6 | 7
Figure it out without running it.

Answer: 7

Explanation: This returns a 7, which is the result of an Inclusive OR between these numbers. These numbers are:
6 - 0110
7 - 0111
If you OR these numbers, you get a 7, which is 0111, all bits with 1s anywhere are returned.

(Continued on next question...)

Other Job Interview Questions

• In the Windows world, if you hit the "Enter" key on your keyboard between two single quotes and inserted this value, what data would be stored in the column?
• In Full-Text Search, what is word breaking?
• You wish to initialize subscribers to your SQL Server 2005 database using FTP. Which versions can you do this with?
• Setting the TRUSTWORTHY database property to ON allows you to execute the following from within the context of the database: Submitted by Charles Hawkins
• Which of the following is true about the Raw File Source in SQL Server 2005 Integration Services?
• How many credentials can one login be mapped to?
• How can you determine which user is executing statements in Profiler?
• What could be the problem if you know the service is working properly?
• You want to disable the trigger dEmployee on the HumanResources...
• What does the tablediff utility do?
• More...