Database Interview Questions

SQL Server
1.What are primary keys and foreign keys?
2.What is the difference between clustered and non-clustered indices? ...and why do you use a clustered index?
3.What is an outer join?
4.What are Cartesian joins?
5.How is referential integrity enforced in a SQL Server database?
6.What are the inserted and deleted tables and what are they used for?
7.What is the name of the SQL language used in SQL Server stored procedures?
8.What is the purpose of having stored procedures in a database?
9.Why might you create a stored procedure with the 'with recompile' option?
10.What is a cursor? Within a cursor, how would you update fields on the row just fetched?

SQL, Oracle, Pro*C/C++
1.What are the different types of joins?
2.Explain normalization with examples.
3.What cursor type do you use to retrieve multiple recordsets?
4.Difference between a "where" clause and a "having" clause
5.What is the difference between "procedure" and "function"?
6.How will you copy the structure of a table without copying the data?
7.How to find out the database name from SQL*PLUS command prompt?
8.Talk about "Exception Handling" in PL/SQL?
9.What is the difference between "NULL in C" and "NULL in Oracle?"
10.What is Pro*C? What is OCI?

Oracle Concepts and Architecture Database Structures
1.What are the components of physical database structure of Oracle database?
2.What are the components of logical database structure of Oracle database?
3.What is a tablespace?
4.What is SYSTEM tablespace and when is it created?
5.Explain the relationship among database, tablespace and data file.
6.What is schema?
7.What are Schema Objects?
8.Can objects of the same schema reside in different tablespaces?
9.Can a tablespace hold objects from different schemes?
10.What is Oracle table?

and more then 300 questions on Data Base Administration, Memory Management, Database Security & Administration, SQL*Plus , General and DB2 SQL.