# Data Modeling Interview Questions

Showing Questions 1 - 20 of 49 Questions
First | Prev | Next | Last Page
Sort by:
|
•

#### SRIKANTH

• Sep 4th, 2006

SEQUENTIAL FILE CANT BE USED AS LOOK UP.. || HASHED FILE CAN BE USER AS LOOK UPIN SEQ.FILE REMOVING DUPLICATES IS DIFFICULT ||IT MAINLY WORKS AS HASHING ALGORITHM WITH OUT ANY KEY COLUMN IT WONT COSIDER..HASHED FILE IS UR FOR BETTER PERFORMANCE..WE INCREASE THE SIZE OF THE BUFFER IN TIS..

#### sangroover

• Feb 14th, 2006

Hash file is helpful to take data from any coloumn, it will also have a key, as it has the key the data is sorted.wHEN

•

#### Sujatars

• Jun 15th, 2007

First Normal Form sets the basic structure for an organized database by 1. Eliminating the duplicate/repetative columns from the same table.2. Create a seperate table for each set of related data and identify each set of related data (row) with a unique column (primary key).

#### vvijaychandra

• Jun 24th, 2006

eliminate the repeating groups in the individual tablescreate a seperate table for each set of related data.identify each set of related data with a primary key

•

#### Sujatars

• Jun 15th, 2007

Second normal form (2NF) addresses the concept of removing duplicative dataMeet all the requirements of the first normal form. Remove subsets of data that apply to multiple rows of a table and pl...

#### vvijaychandra

• Jun 24th, 2006

create seperate tables for the set of values that apply to multiple records , realate these tables with a foreign key.

•

#### Why are recursive relationships are bad? How do you resolve them?

• Nov 12th, 2007

We have used a different way of maintaning recursive relationship. We have created a ancestry table which will give the childs for each entry upto n th level. This way you can fire queries directly to get the child upto any specific level.

#### ritwik roy

• Jul 21st, 2005

using the concept of self join may be a solution to this problem. e.g if a table called employees contains three fields like emp_id,name and manager_id and we will have to find out the name of the ma...

•

#### SashaFroyland

• Mar 1st, 2008

The only difference is in what's been selected in the model type when the diagram was first started. In ERWin 7.3 you have the choice of creating three different kinds of diagrams: 1) Physical...

#### rahul.katke

• Dec 27th, 2007

The Logical Data Model (LDM) is derived from the Conceptual Data Model (CDM).The CDM consists of the major entity sets and the relationship sets, and does not state anything about the attrib...

•

#### vas_kal

• May 11th, 2008

3NF allows transitive dependency

#### Sujatars

• Jun 15th, 2007

Remove columns that are not dependent upon the primary key

•

#### Data Modeling software tools

What are the different Data Modeling software tools? Which one is considered the best among all in terms of cost, efficiency and usability ?

#### geeksds

• Sep 18th, 2008

Visio; ERwin; Rational.  Rational is considered the best.

#### SashaFroyland

• Mar 1st, 2008

•

#### geeksds

• Sep 18th, 2008

When there are performance issues, that would be improved by denormalizing the database.

#### sachin

• Jun 25th, 2007

There are various reasons behind normalizing and denormalizing.If you dig deep into the practical world, everywhere all the applications have both type of formation. You cannot deal with only one type...

•

#### Relational and Dimensional Data Modeling

How does Relational Data Modeling differ from that of Dimensional Data Modeling?

#### wmilford

• Jan 15th, 2009

In relational models data is normalized to 1st, 2nd or 3rd Normal form. In dimensional models data is denormalized. The typical design is that of a Star where their is a central fact table containing...

•

#### Components of Information System Architecture

List six key components of Information System Architecture. Which of these relate to database design and Why?

#### MAbdullah47

• Feb 9th, 2009

1. Data 2. Processes 3. Network 4. People 5. Events and points in time 6. Reasons All of them related to the DB Design . During the database design we need data to define it’s attributes; proces...

•

#### Conceptual Models

What are Conceptual Mdels

#### jay_yasho

• Mar 31st, 2009

A conceptual ER model show how the business world sees the information. It shows only critical details in order to emphasize business rules and user objects. ideally It  includes only significant...

•

#### Data Options and Parameters

What is the distinction between data options and parameters?

#### seethala_goutham

• Jun 11th, 2009

Data options means it sends the data in diff forms and where as parameters supports the data which sends through it

•

#### Match the following in the context of data flow diagram :

i. circle a. source of data ii. square b. file or data base iii. arrow c. conversion process iv. parallel line d. data flow
1. l-a, ll-b,lll-c, lv-d
2. l-c, ll-a, lll-d, lv-b
3. l-c,ll-d, lll-a, lv-b
4. l-b, ll-a, lll-d, iv-c

#### anoosha kokkula

• Jul 2nd, 2009

Answer is 2Circle - Conversion processSquare - Source of data
Arrow - Data flowParallel line - File or database

#### SashaFroyland

• Mar 1st, 2008

None of the above (in my opinion).A -> C -> D -> bA) source, then data flows to C) where it's converted or transformed, then it flows to D) parallel where it's pipelined into the B) the database as both updates in inserts.

•

#### Agile Approaches

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 willingness of management to permit the adoption of agile processes.

#### priyanka2000

• Jun 17th, 2010

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...

•

#### 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 requirements. If all is going according to plan, the actual burndown will occur at the optimal rate,...

• Jun 29th, 2010

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 ...

•

#### osnarayan

• Sep 14th, 2009

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...

#### venky

• May 23rd, 2006

False, all databases need not be in 3NF, however in most cases in the business world databases tend to be in 3NF or BCNF

Showing Questions 1 - 20 of 49 Questions
First | Prev | Next | Last Page
Sort by:
|

#### Have Interview Question?

Please select the most appropriate category and mention a brief question title along with clear question details.

Name:
Email:
Category :
Sub Category :
Question Title:
Question in Detail :
Job Role (Optional) :
Company (Optional) :