Data Modeling Interview Questions
What is the difference between mvc1 and mvc2 in j2ee?
Toponomy database is a collection of data related to the study of place names, their origins,meaning,topology and their use.
What is difference between query calculation and layout calculation
The query calculation helps to create a report to add a new row or column with values that are based on a calculations.
Layout calculation helps to create a report which contains run time information such as current time, date, and user name.It does not perform any operations on data.
How to capture webtable values
By using the function getroproperty("field name") we can capture webtable values.
Explain with an example
Fish-bone Analysis is a cause and effect analysis tool that helps to identify the problem and causes of the problem using a fish-like structure - the problem is at the head of the fish and the skeleto...
Describe your university or college as a system. what is the input? what is output? what is the boundary? what is the components and their relationship? the constraint the environment draw a diagram of this system
What is the difference between star flake and snow flake schema?
Star flake schema's are snowflake schema's where only some of the dimension tables have been denormalized.
Every star flake schema is also a snowflake schema.
Not every snowflake schema is a starflake schema.
A snowflake schema with all of its dimension tables normalized is not a starflake schema.
Star schema - normalized one snow flake-denormalized
What is aggregation in DBMS?Explain in simple words.
collection of entities...
A concept which is used to model a relationship between a collection of entities and relationships. It is used when we need to express a relationship among relationships. Aggregation - a feature of t...
Discuss how you would use storage structures mainly the tablespaces, database security features, Oracle net services to logically manage what users can do or not to the database. Assume you would want to achieve partial database availability to different users at some times so that whilst some users...
Can you explain about Informatica architecture ? And what difference between service based and service oriented ?
|----------------------------|---------------------------------|-------------------| | SOURCES |client tools | TARGET | | like ,oracle,db2 |-...
Describe the v-model and fish model in sdlc ?
We already have a database structure, but it is the structure without normalization and very confused and in need of change, but already has a large volume of stored data, for example, all financial data company, which finance department officials are afraid of losing. we are undecided about remodeling...
What ever data base structure you have you can get a Logical model out of it using Reverse Engineering. Erwin is one data model tool which does it. You should apply normalizing techniques to bring the...
What are the values given to the field name,data element and type of a table to make it as a client dependent ?
What is the best way to start the analytical side of the sdlc?
What is the impact of data modeling software engineering?
GUI Representation of a Data model of any system helps in understanding the data flow and relationship between the entities.
Is this statement true or false – all databases must be in third normal form?
Yes. It is true that all the database should be in the third normal form. Hope, Third Normal Form is sufficient to tune the database and make it perfect. 4th Normal Form onwards it is not at all requi...
False, all databases need not be in 3NF, however in most cases in the business world databases tend to be in 3NF or BCNF
Scrum development in respects to the burndown chart
One popular tool in scrum development is the burndown chart, which diagrams the day-to-day progress that a scrum development team is making on a particular sprint. Essentially, at the end of each day in the sprint, the team estimates how many hours of work they still have to do to complete the sprint...
Scrum sets out a fixed length for each Sprint (In classic SCRUM, 30 days or four weeks). Hence, if you are running ahead of schedule, it will be necessary to add tasks to avoid idle time at the ...
One feature that characterizes all of the agile approaches that have arisen in recent years is the requirement that software features be developed in small incremental cycles of two to six weeks in duration. Explain the positive and negative effects that this requirement produces with respect to the...
Positives: A customer demo can be given at the end of a sprint , hence if there is anything that the customer does not like , that can be captured , instead of propagating that throughout the delivery...
User Panel
Categories
Ads
Interview Coaching
Connect
Ads
Interview Question
Career Counselling
Latest Questions
Ads
Interview & Career Tips
Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, click "Subscribe".
1.MVC1 consists of Web browser accessing Web-tier JSP pages. The JSP pages access Web-tier JavaBeans that represent the application model, and the next view to display is determined by hyperlinks sele...