Show how you would convert DateTime.UtcNow into central time zone.
Describe the result of this statement: IMyInterface proxy = Factory.Create<IMyInterface>();
A database table called ‘Listing’ exists with the following fields: ID (int, pk), Name (varchar), IsPromoted (bit). Write a SELECT statement that accepts @Query as input, and returns all entries from this table with a partial match on this. Promoted listings, if they exist in the results, should be boosted so that they appear in every odd result, starting with position #1.
Write the HTML for a form, asking the user for their name, email and phone number.
List any tools a developer might find helpful in answering questions 1-4.