Posts in the [ Interview Questions ] Category
T-SQL Exam questions and answers – Part 10
Questions
Q1. Which of the following function would you consider using to get the day (day of the month) of the specified date?A. DAY()
B. DATE()
C. YEAR()
D. GETDATE()
Q2. Which of the following function would... Read MoreT-SQL Exam questions and answers – Part 9
Questions
What will be the correct output of following T-SQL statements? Q1. [crayon-66ee3f9bc6c67230433855/]A. 199.0099
B. 199
C. 199.01
D. 199.0009
Q2. [crayon-66ee3f9bc6c70513352994/]A. 10
B. 20
C. 40
D. 8
Q3. [crayon-66ee3f9bc6c73214004744/]A. 0
B. -1
SSIS Interview Questions – Part 2
Questions
Q1. Which transformation type can be used to Combines one or more similar inputs ? Q2. Name five SSIS Connection Manager Types ? Q3.Which transformation can you use if you would like to filters data based on a Boolean expression? Q4. If you... Read MoreSSIS Interview Questions – Part 1
Questions
Q1. When SSIS packages are saved to DTSX files, what format is used to store the SSIS Package definitions?A. SQL files
B. Text files
C. Bat files
D. XML files
Q2. What are the three essential elements... Read More