# SQL/DB Interview Questions > 有关SQL和数据库相关的话题回答所有面试问题 Canonical page: [https://chrome-stats.com/d/com.programmerworld.SQLInterviewQuestionsLite?hl=zh-CN](https://chrome-stats.com/d/com.programmerworld.SQLInterviewQuestionsLite?hl=zh-CN) ## Overview - **ID:** `com.programmerworld.SQLInterviewQuestionsLite` - **Platform:** Android - **Type:** Android app - **Status:** Available - **Publisher:** Programmerworld - **Category:** EDUCATION - **Downloads:** 79,977 - **Rating:** 1.00 / 5 (549 ratings) - **Version:** 1.1.03 - **Last updated:** 2017-01-27 - **First published:** 2012-05-28 - **Publisher country:** IN - **Data as of:** 2026-09-12 - **Store listing:** [Google Play Store](https://play.google.com/store/apps/details?id=com.programmerworld.SQLInterviewQuestionsLite) - **Website:** [http://faq.programmerworld.net/apps/android/index.html](http://faq.programmerworld.net/apps/android/index.html) - **Privacy policy:** [http://faq.programmerworld.net/apps/android/sqlinterviewquestions\_privacy\_policy.html](http://faq.programmerworld.net/apps/android/sqlinterviewquestions_privacy_policy.html) ## Description SQL面试问题，为您提供范围广泛的问题，可以在一次采访中问。回答最常见的面试问题，并一直为便于分类。

这个应用程序是独一无二的，它可以帮助你掌握最常见的问题，灌输你的信心，你需要忍受的最艰难的采访。应用程序涵盖了所有常见问题与任何特定数据库的特定问题。

如果你想购买的源代码，请联系我们ad​​min@programmerworld.net

产品特点：

1。 164的问题，你准备任何类型的面试。
2。为用户提供一个选项，练习他/她自己的答案，你的申请将出示您的问题。用户可以想到他的回答，然后比较如何从我们的答案，他的答案是不同的。
3。面试问题已经类别的易用性。
4。常见的问题，然后检查您选择的dabase相关的具体问题。

样题

Q.）TRUNCATE和DELETE命令之间的区别是什么？
答：两者都将导致删除表中的所有行。TRUNCATE呼叫不能被回滚，因为它是一个DDL命令，该表的所有的内存空间被释放回服务器。 TRUNCATE是多faster.Whereas DELETE调用是一个DML命令，可以回滚。

Q.）的候选键是什么？
答：能唯一标识表中的行，列一个表中可以有多个组合，每个组合就是一个候选键。 ## Rankings - #244,280 — Overall ## Review summary The app offers a basic and helpful resource for SQL/DB interview questions, appreciated by users looking for theoretical knowledge. However, it suffers from major drawbacks such as frequent intrusive ads, bugs leading to crashes and restarts, and non-functional buttons. Additionally, users desire more detailed explanations and examples to deepen understanding. Due to these issues, many users find the app unreliable and frustrating, severely affecting its usability. ### Pros - Good for learning SQL basics and theoretical parts - Helpful for interview preparation with SQL/DB questions - Users appreciate the simplicity and basic usefulness of the app ### Cons - App is plagued by excessive ads, disrupting user experience - Frequent bugs causing app crashes and restarts - Start button often does not work or is unclickable due to ads - Lack of detailed explanations and code examples for questions - Some users report the app does not work at all or shows blank screens ## Similar extensions and apps - [SQL Interview Questions](https://chrome-stats.com/d/com.sqlndb.questions) — 809 users - [SQL Interview Questions](https://chrome-stats.com/d/in.developerswiki.sqlfree) — 771 users - [Sql (Placement Preparation)](https://chrome-stats.com/d/com.omsoftonics.sql) — 167 users - [Database Questions](https://chrome-stats.com/d/com.shah.data) — 59 users - [SQL Interview Master](https://chrome-stats.com/d/com.sqlinterview.sqlpractice) — 2,214 users - [Testing Interview Questions](https://chrome-stats.com/d/com.programmerworld.TestingInterviewQuestions) — 56,104 users, 4.33 / 5 - [MS SQL Interview Question](https://chrome-stats.com/d/in.developerswiki.mssqlfree) — 69 users - [RDBMS Interview QA](https://chrome-stats.com/d/cksmb.tech.RDBMSInterviewQA) - [Mysql Interview Question](https://chrome-stats.com/d/in.developerswiki.mysqlfree) — 152 users - [Data Warehouse Interview QA](https://chrome-stats.com/d/com.programmerworld.DataWarehouseInterviewQuestions) — 23,134 users - [SQL Server FAQ](https://chrome-stats.com/d/com.mitran.sqlserverproject) — 1,123 users - [Database Questions and Answers](https://chrome-stats.com/d/com.shahenshah.database) — 7,946 users --- Source: [Chrome-Stats](https://chrome-stats.com/d/com.programmerworld.SQLInterviewQuestionsLite?hl=zh-CN)