Screening Test/Interview Questions for SQL Developer (Remote) Position
Instructions: Please precede all your answers with the question you are answering.
Use acronyms only after you've explained them.
Use correct spelling and grammar.
Candidate’s Name & Number:
1. Are you currently employed?
2. Can you tell us some basic information about yourself?
3. What are the main qualities you look for in a new job?
4. What is the difference between CHAR and VARCHAR2 datatype in SQL?
5. What do you mean by table and field in SQL?
6. What are UNION, MINUS and INTERSECT commands?
7. What is OLTP? And what are the differences between OLTP and OLAP?
8. What are some common clauses used with SELECT query in SQL?
9. List the different types of relationships in SQL.
10. What is Database Black Box Testing?
11. What is schema in SQL Server?
12. How to create a temp table in SQL Server?
13. Will you be able to devote 30 to 40 hours of your time weekly for the
company?
14. How long would you expect to work for us if hired and how much will you
request per hour if you are hired?
15. When can you start working with us if we offer you this position?
16. What is BLOB and TEXT in MySQL?
Responsibilities:
Manage migration of SQL 2005 databases to SQL 2008 R2.
Work with dynamic T-SQL queries, DDL, DML statements for creating
objects, making updates and managing user permissions.
Coordinate with DBA in creating and managing table, indexes, table spaces,
triggers, db links and privileges.
Used subversion tools, SVN version management to manage various
versions of the procedures and functions for of the application.
Design the structures and layouts of reports, apply drill-down, drill-through
and sub-reports.
Develop the UI using JavaScript, JSP, HTML, and CSS for interactive cross
browser functionality and complex user interface.
Support web base Java application heavily reliant upon XML documents.
Involve in ETL architecture enhancements to increase the performance data
warehouse using query manager and optimizer.
Consolidate redundant existing reports to create a dashboards and add new
metrics for improve data visualization.
Enable drill-through for a cube.
Can you handle all of these duties effectively?