Database - Interview Questions and Answers for 'Symantec' | Search Interview Question - javasearch.buggybread.com
Questions
Search
List By Company
List By Topic
Legacy
Tests
Repository
DashBoard
Java
Java 8
Java 7
Java Abbreviations
OCJP / SCJP
Class List
New in Java 8
Java Exceptions
Spring Exceptions
Java Enums
Java 8 Lambda
Java 8 java.time
Big Data
Best Of Java
Discussion
Search
Subscribe
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.
Label / Company
Label / Company / Text
Search
Submit Question
Database - Interview Questions and Answers for 'Symantec' - 2 question(s) found
- Order By Newest
Frequently asked to experienced developers. Recently asked in many US interviews.
Q1.
What is database deadlock ? How can we avoid them?
Database
Ans. When multiple external resources are trying to access the DB locks and runs into cyclic wait, it may makes the DB unresponsive.
Deadlock can be avoided using variety of measures, Few listed below -
Can make a queue wherein we can verify and order the request to DB.
Less use of cursors as they lock the tables for long time.
Keeping the transaction smaller.
Help us improve. Please let us know the company, where you were asked this question
:
Like
Discuss
Correct / Improve
 java   database   architecture
Asked in 7 Companies
expert
 
frequent
Correction
Duplicate of Another Question
Company where this question was Asked
Suggestion
Related Questions
What is a Deadlock ?
What are the four situations that are required for deadlock to happen ?
What is Livelock in relation to deadlock ?
Write Java code that would cause deadlock ?
How can multi threading lead to a deadlock ?
Q2.
Design database schema for Facebook like application.
Database
This question was recently asked at 'Symantec'.This question is still unanswered. Can you please provide an answer.
Help us improve. Please let us know the company, where you were asked this question
:
Like
Discuss
Correct / Improve
 database design
Asked in 1 Companies
expert
Correction
Duplicate of Another Question
Company where this question was Asked
Suggestion
Related Questions
Difference between == and .equals() ?
Why is String immutable in Java ?
Explain the scenerios to choose between String , StringBuilder and StringBuffer ?
or
What is the difference between String , StringBuilder and StringBuffer ?
What are the difference between composition and inheritance in Java?
Explain OOPs
or
Explain OOPs Principles
or
Explain OOPs Concepts
or
Explain OOPs features
or
Tell me something about OOPs
What is a Lambda Expression ? What's its use ?
Why Char array is preferred over String for storing password?
What are different ways to create String Object? Explain.
Does garbage collection guarantee that a program will not run out of memory?
What is the difference between final, finally and finalize() ?
Help us and Others Improve. Please let us know the questions asked in any of your previous interview.
Any input from you will be highly appreciated and It will unlock the application for 10 more requests.
Company Name:
Questions Asked: