I am a Java developer and most of my experience is on Java. But sometimes I have face some database related questions in the interviews. Hence I wanted to ask that from the interview point of view, which questions a Software Developer/Sr. Software Developer (non-DBA, non-Database Enigneer) should be able to answer about databases?I know that this is a very subjective question with no definite answer. But I have come across a similar question about J2EE with some really great answers. Hence some constructive suggestions like specific topics, areas, questions, even links to resources will be greatly appreciated. 
Which questions a Software Developer/Sr. Software Developer (non-DBA, non-Database Enigneer) should be able to answer about databases?
interview;database
Each organization have certain expectations from their developers, these expectations depend on the project at hand and the seniority of the developer. Here are some of the topics that cover all developer roles: 0-Build database scheme, tables, procedures and permissions.1-Index design basics and when to use each type of index.2-Query performance analysis and tuning - How and what tools/commands to use.3-SQL and common SQL functions. 4-Database scripting language (T-SQL, PL/SQL) and when to use and when not to use.5-Primary Keys/Foreign Keys design.6-At least the first 3 Normal Forms ormalization (pros and cons).7-Triggers types and when to use and not use.8-Loading database from files.9-Database environment parameters that needs to be set and why.10-Logical database modeling, and some physical database modeling although, DBAs would know about that more. If applying for ETL job, need to know about star schema.11-Referential Integrity constraint types and their effects.12-Key design/selection best practices.13-How to use the database management environment.14-How to invoke the database commands from console.15-How to write basic DDL (Create Table, etc.).16-What is a dead lock and how to avoid it.17-Views and their usage18-What is a RDBMS!Edit-1:There are several references for the above knoweldge, The following were added to address some of the comments:Index Types - MSDNIndex Types and Query OptimaizationDatabase Engine Advisor - MSDNSQL Server ProfilerEdit-2FYI - See related question: software-developer-interview-question-fair-or-unfair