q: with and without sub queries, write sql to show employees not assigned any project, given employee (id, name), employee_project (eid, pid)
%%A: outer join with count() = 0 ? Yes see post on payment history
http://sqlzoo.net/3.htm contains actors not casted
select count(name) from actor left outer join casting on actor.id=casting.actorid where casting.actorid is null
Based on IBM webpage: “The following query returns only rows in which customers have not made any calls
SELECT c.customer_num, c.lname, c.company, c.phone, u.call_dtime, u.call_descr
FROM customer c LEFT OUTER JOIN cust_calls u
ON c.customer_num = u.customer_num
WHERE u.customer_num IS NULL “
This is a case of a normal “unmatched prikey”. No referential integrity violation.
q: xp with mysql replication? (programmers need to know mysql replication.)
q: describe an xq java web project
q: difference btw spring mvc vs struts
q: java 5 features? generic, enum
q: describe a personal pet project (“side project”)
q: why do u say smarty is cleaner separation of presentation and logic than jsp or asp?
q: name a technology that excites u now and name one feature
q: php caching
q: php connection pool
q: unit testing?
q: ajax xp?
q: web services xp?
q: state sync between 2 instances of php?
%%q: important technical skills for this job
a: mysql cluster, fast sql queries, core java, junit,