DATABASE

  1. What is normalization? Explain different levels of normalization?
  2. What is denormalization and when would you go for it?
  3. How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  4. What's the difference between a primary key and a unique key?
  5. What are user defined datatypes and when you should go for them?
  6. What is bit datatype and what's the information that can be stored inside a bit column?
  7. Define candidate key, alternate key, composite key.
  8. What are defaults? Is there a column to which a default can't be bound?
  9. What are the different types of joins?
  10. Explain normalization with examples.
  11. What cursor type do you use to retrieve multiple recordsets?
  12. Diffrence between a "where" clause and a "having" clause
  13. What is the difference between "procedure" and "function"?
  14. How will you copy the structure of a table without copying the data?
  15. How to find out the database name from SQL*PLUS command prompt?
  16. Tadeoffs with having indexes
  17. Talk about "Exception Handling" in PL/SQL?
  18. What is the diference between "NULL in C" and "NULL in Oracle?"
  19. What is Pro*C? What is OCI?
  20. Give some examples of Analytical functions.
  21. What is the difference between "translate" and "replace"?
  22. What is DYNAMIC SQL method 4?
  23. How to remove duplicate records from a table?
  24. What is the use of ANALYZing the tables?
  25. How to run SQL script from a Unix Shell?
  26. What is a "transaction"? Why are they necessary?
  27. Explain Normalizationa dn Denormalization with examples.
  28. When do you get contraint violtaion? What are the types of constraints?
  29. How to convert RAW datatype into TEXT?
  30. Difference - Primary Key and Aggregate Key
  1. How functional dependency is related to database table design?
  2. What is a "trigger"?
  3. Why can a "group by" or "order by" clause be expensive to process?
  4. What are "HINTS"? What is "index covering" of a query?
  5. What is a VIEW? How to get script for a view?
  6. What are the Large object types suported by Oracle?
  7. What is SQL*Loader?
  8. Difference between "VARCHAR" and "VARCHAR2" datatypes.
  9. What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table.
  10. Difference between "ORACLE" and "MICROSOFT ACCESS" databases.
  11. How to create a database link ?
  12. What is RAID and what are different types of RAID configurations?
  13. What are the steps you will take to improve performance of a poor performing query?
  14. What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
  15. What are the steps you will take, if you are tasked with securing an SQL Server?
  16. What is blocking and how would you troubleshoot it?
  17. Explain CREATE DATABASE syntax
  18. How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
  19. As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
  20. What are statistics, under what circumstances they go out of date, how do you update them?
  21. What are the different ways of moving data/databases between servers and databases in SQL Server?
  22. Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
  23. What is database replicaion? What are the different types of replication you can set up in SQL Server?
  24. What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
  25. Write down the general syntax for a SELECT statements covering all the options.
  26. What is a join and explain different types of joins.
  27. Can you have a nested transaction?
  28. What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
  29. What is the system function to get the current user's user id?
  30. What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
  31. What is a self join? Explain it with an example.]
  32. Given an employee table, how would you find out the second highest salary?