数据库面试题目

最新推荐文章于 2025-12-21 16:40:57 发布

最新推荐文章于 2025-12-21 16:40:57 发布 · 112 阅读

文章标签：

#面试 #Oracle #SQL #Microsoft #Unix

DB2 专栏收录该内容

20 篇文章

订阅专栏

本文汇总了30多个SQL及数据库相关面试问题及其解答,覆盖了从基本操作到高级概念,如不同类型的连接、归一化、游标使用、过程与函数区别等内容,帮助读者深入理解并掌握数据库知识。

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. Diffrence 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. Tadeoffs with having indexes
9. Talk about “Exception Handling” in PL/SQL?
10. What is the diference between “NULL in C” and “NULL in Oracle?”
11. What is Pro*C? What is OCI?
12. Give some examples of Analytical functions.
13. What is the difference between “translate” and “replace”?
14. What is DYNAMIC SQL method 4?
15. How to remove duplicate records from a table?
16. What is the use of ANALYZing the tables?
17. How to run SQL script from a Unix Shell?
18. What is a “transaction”? Why are they necessary?
19. Explain Normalizationa dn Denormalization with examples.
20. When do you get contraint violtaion? What are the types of constraints?
21. How to convert RAW datatype into TEXT?
22. Difference - Primary Key and Aggregate Key
23. How functional dependency is related to database table design?
24. What is a “trigger”?
25. Why can a “group by” or “order by” clause be expensive to process?
26. What are “HINTS”? What is “index covering” of a query?
27. What is a VIEW? How to get script for a view?
28. What are the Large object types suported by Oracle?
29. What is SQL*Loader?
30. Difference between “VARCHAR” and “VARCHAR2″ datatypes.
31. What is the difference among “dropping a table”, “truncating a table” and “deleting all records” from a table.
32. Difference between “ORACLE” and “MICROSOFT ACCESS” databases.
33. How to create a database link?