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 'Sap' - 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 : | ||||
Like 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 : | ||||
Like 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 : | ||||
Like 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 ? | ||||