1 Essential Oracle SQL Interview Question *

select employee_id emp, last_name emp_name, hire_date date 
from employees;

select employee_id emp, last_name emp_name, hire_date "date" 
from employees;

There is more to interviewing than tricky technical questions, so these are intended merely as a guide. Not every “A” candidate worth hiring will be able to answer them all, nor does answering them all guarantee an “A” candidate. At the end of the day, hiring remains an art, a science — and a lot of work.