面向面试准备、在线测试、教程与实战练习的学习平台

通过聚焦学习路径、模拟测试和面试实战内容持续提升技能。

WithoutBook 将分主题面试题、在线练习测试、教程和对比指南整合到一个响应式学习空间中。

搜索资源库

面试准备

提问

模拟考试

设为首页

收藏此页面

DBMS 面试题与答案

Test your skills through the online practice test: DBMS Quiz Online Practice Test

问题 21. What is �CROSS JOIN�? or What is Cartesian product?

�CROSS JOIN� or �CARTESIAN PRODUCT� combines all rows from both tables. Number of rows will be product of the number of rows in each table. In real life scenario I can not imagine where we will want to use a Cartesian product. But there are scenarios where we would like permutation and combination probably Cartesian would be the easiest way to achieve it.

这有帮助吗？是否添加评论查看评论

问题 22. How to select the first record in a given set of rows?

Select top 1 * from wb.wbEmployees;

这有帮助吗？是否添加评论查看评论

问题 23. What is the default �-SORT � order for a SQL?

ASCENDING

这有帮助吗？是否添加评论查看评论

问题 24. What is a self-join?

If we want to join two instances of the same table we can use self-join.

这有帮助吗？是否添加评论查看评论

问题 25. What�s the difference between DELETE and TRUNCATE?

Following are difference between them:

DELETE TABLE syntax logs the deletes thus making the delete operations low. TRUNCATE table does not log any information but it logs information about deallocation of data page of the table. So TRUNCATE table is faster as compared to delete table.
DELETE table can have criteria while TRUNCATE can not.
TRUNCATE table can not have triggers.

这有帮助吗？是否添加评论查看评论

用户评价最有帮助的内容：

通过聚焦学习路径、模拟测试和面试实战内容持续提升技能。

DBMS 面试题与答案

相关差异对比

问题 21. What is �CROSS JOIN�? or What is Cartesian product?

问题 22. How to select the first record in a given set of rows?

问题 23. What is the default �-SORT � order for a SQL?

问题 24. What is a self-join?

问题 25. What�s the difference between DELETE and TRUNCATE?

WithoutBook