Search Interview Questions |  More than 3000 questions in repository. There are more than 900 unanswered questions. Click here and help us by providing the answer. Have a video suggestion. Click Correct / Improve and please let us know. |
|
|||
|
| ||||
| Database - Interview Questions and Answers for 'Sapient' - 3 question(s) found - Order By Newest | ||||
| ||||
| Ans. https://en.wikipedia.org/wiki/Database_normalization | ||||
| Help us improve. Please let us know the company, where you were asked this question : | ||||
 Discuss Correct / Improve  normalization database  Asked in 35 Companies  intermediate  frequent | ||||
 Related Questions | ||||
 Difference between Normalization and Denormalization ? | ||||
| Which of the two Normalization / Denormalization facilitate better performance ? Which of the two facilitate better space management ? | ||||
| ||||
| Ans. Audit Tables generally stores Raw information to be reviewed in case of problems or determining impact. If Database space is an issue , and the audit information is rarely retrieved, one design could be to use compressed file system. | ||||
| Help us improve. Please let us know the company, where you were asked this question : | ||||
| Discuss Correct / Improve databases audit tables raw transaction information storage Asked in 1 Companies | ||||
| Related Questions | ||||
| ||||
| Ans. A dirty read occurs when a transaction is allowed to read data from a row that has been modified by another running transaction but not yet committed. | ||||
| Help us improve. Please let us know the company, where you were asked this question : | ||||
| Discuss Correct / Improve database transaction Asked in 8 Companies | ||||
| Related Questions | ||||
| What is ACID ? | ||||
| What is database deadlock ? How can we avoid them? | ||||
| What things you would care about to improve the performance of Application if its identified that its DB communication that needs to be improved ? | ||||
| If you are given a choice to implement the code to either Insert a Record or Update if already exist, Which approach will you follow ? | ||||
| What is the use of @GeneratedValue annotation in Hibernate? | ||||
| What are temp tables ? | ||||
| What is a Database Trigger ? | ||||
| What is database Normalization ? | ||||
| What happens to backups if we delete the RDS instance ? | ||||
| What is a Cursor ? | ||||
