Interview - General

What is the 1st strength and 1st weakness related to job?

U need not really disclose u'r weakness which wud be a big obstacle in fetching u this job,just for the heck of answering u'r interviewer.

U may state some thing that would sound like u'r weakness but cud be u'r strength-I'm lil emotional and loose some patience when the job is not performed right. However I don't loose much patience/temper but I think i need to keep more cool and I 'm working towards it and it's really showing good result now.

What would you say are areas needing improvement?

I always aim at perfection but i suppose i need to work a little hard to accept the principle of bounded rationality and work with a realistic scenario. But I would still continue to aim at best possible solution.

Do you prefer working alone or in groups?

I'm an individual contributor as well as group contributor. How ever I would prefer to work with a group as it would give more views/solutions/alternatives to a single situation/problem and there is a lot of scope to learn new and quick ways of doing the things. It peps up the challenging spirit in you and you thrive to perform better and better as your efforts get larger visability.Last but not the least it's fun to work in a group/share/learn/argue and finally get associated with the success as contributed by the group/team efforts.

What kind of people do you find it most difficult to work with? Why?

The people who gives more importance to their personal attributes than the work.....lasy about work....and non- co-operative, it is quit difficult to work with such kind of people...it affects work.

Why are you leaving your present job? (or, Why did you leave your last job?)

Be positive regardless of the circumstances. Never refer to a major problem with management and never speak ill of supervisors, co-workers or the organization. If you do, you will be the one looking bad. Keep smiling and talk about leaving for a positive reason such as an opportunity, a chance to do something special or other forward-looking reasons.

What is important to you in a company? What things do you look for in an organization?

My goals and capabilities should gel with the same of the company. I look forward to an organisation with which i'm able to step forward towards my goals but at the same time add a respectable portion to the company's basket also

I look for professional environment/cooperative colleagues-lots of learning and sharing/continuous learning/opportunities to enhance my skills/visibility/recognition to my efforts/last but not the least fun at work :)

Where do you see yourself after 10 years?

I like to see myself at a position where i can use my creativity to the best. For those who really don’t know much about technical fields and the branches much this answer will do or another reply would be like itll be up to u (the interviewer)to place me at a position where my talent is most tapped.

What is your long-term employment or career objective?

I made my self both short term and long term goal in career

my short term goal is to learn new technology and make my self techincally strong as well as in people management skill which will make sure me ,to acheive my long term goal as soon as possible

What might make you leave this job?

Never give negative responses for a question like this . Complaining abt d last employer is never advisable. Always focus on what you have learnt from your last organization and emphasis on your willingness to learn and grow and seek better opportunity . Put yourself always in the psitive frame of mind of the interviewer. Never complain abt your last job or organization.

What kind of job do you see yourself holding five years from now?

I would like to see my self contributing positively to the organization i would be working for. I would develope new skills and ability and would like more responsibilities becoz i think thats the result of your personal growth and development.

Why might you be successful in such a job?

I would make a good employee with _____________ because I sincerely believe that I'm the best person for the job. I bring a strong quality that makes me the very best person for the job--my attitude for excellence. I am a team player, humble, keep promises, polite, I willing to pay the price to achieve realistic goals, willing to go beyond the call of duty, generous, conscientious, having honesty and integrity, flexible, hard working, positive thinking, not waiting for things to happen instead I am proactive in life.
As part of the fastest growing segment of the exciting entertainment industry, TooSpoiled will benefit from my attitude.

What things give you the greatest satisfaction at work?

A day in which I am able to help atleast one person either technically, or just in general by motivating him / her to achieve his / her desired goal. A smile in the face of people at work is something I crave for. It really makes the environment lively and eases the stress at work. For my kind of work I desire to work with people who r 'cool like cucumber'

What is the difference between a programmer and the developer?

A programmer job is to code as per given design. A developer developes the software/module from understanding the requirement, then design the solution,code it and then test the same.

"programmers" (people that specialize in writing code)"developers" (people who will contribute in multiple ways to make the product successful).

How would you describe yourself as a person?

i am basically a simple , adjusting and funloving person, whom others consider as sincere and friendly too.But they also consider me as modest, and i dont know whether i am all this.

I would describe myself as a very ambitious , hardworking and sincere girl.I am enthusiastic about taking up new challenges in life.Friendly and joyful is what my friends would describe me as.

I consider my self as a hardworking and apitious person . Programming is a major part of my life , and so I spend most of the day Reding and searching and downloading ready code .. At my free time , I like solely walks , eating Ice cream , and listening to Music .

can describe myself as " Strength is life but Weakness is death."

What kind of things do you feel most confident in doing?

I'd like to do things that r interesting AND THAT WILL ALWAYS HAVE SOME MYSTERY in it.I'd like to do creative things.

i feel most confident in doing the things that require a fair amount of intellectual thinking,introspectionand creativity, in general, anything that captures my interest.

I prefer to work hard for a task which gives me ample creative space because:

Hard work + Creativity + Confident = Positive Payoffs

What things frustrate you the most? How do you usually cope with them?

The most frustrating thing of all is not doing your work when supposed to do and instead just taking things easily.And to cope up with it i try to complete at least my work asassigned or else if i am not able to do it on time ,i at least give it a sincere try.

UML Interview Questions

What is ageeregation & Composistion ?

Aggregation ---It means for example one Colleage is build up of Depatments and again departements contains classes right here school is aggregation of departements and again departement is aggregation of classes,here u can perfect aggregation of things if u delete the main object called school all associated departements and classes will get delete.

Compostion--It means how objects are composed of means in other words it is tightly bound aggregation here even u will not have access to delete child objects which are nested in parent objects.

Data Modeling Interview Questions

What is the difference between star flake and snow flake schema?

Star Schema:

Well in star schema you just enter your desired facts and all the primary keys of your dimensional tables in Fact table. And fact tables primary is the union of its all dimension table key. In star schema dimensional tables are usually not in BCNF form.

SnowFlake:

Its almost like starschema but in this our dimension tables are in 3rd NF, so more dimensions tables. And these dimension tables are linked by primary, foreign key relation.

What is data sparsity and how it effect on aggregation?

Data sparsity is term used for how much data we have for a particular dimension/entity of the model.

It affects aggregation depending on how deep the combination of members of the sparse dimension make up. If the combination is a lot and those combinations do not have any factual data then creating space to store those aggregations will be a waste as a result, the database will become huge.

What is the difference between hashed file stage and sequential file stage in relates to DataStage Server?

In datastage server jobs,can we use sequential filestage for a lookup instead of hashed filestage.If yes ,then whats the advantage of a Hashed File stage over sequential filestage

search is faster in hash files as you can directly get the address of record directly by hash algorithm as records are stored like that but in case of sequential file u must compare all the records.

When should you consider denormalization?

Denormalization is used when there is a lot of tables involved in retreiving data.Denormalization is done in dimentional modelling used to construct a data ware house.This is not usually done for data bases of transactional systems.

What is ERD?

ERD - Entity Relationship Diagram

ERD is a modeling technique that represents a logical design of a particular business process. Each entity has attributes and different entities are connected through primary key/foreign key relationships.

Data models are tools used in analysis to describe the data requirements and assumptions in the system from a top-down perspective. They also set the stage for the design of databases later on in the SDLC.

There are three basic elements in ER models:
Entities are the "things" about which we seek information.
Attributes are the data we collect about the entities.
Relationships provide the structure needed to draw information from multiple entities.

Every statement written above is correct regarding ER Diagrams except that they fall under conceptual design phase and not under logical.

A relational database design goes through 3 phases:

1. Conceptual ( ER Diagrams)

2. Logical ( Relational Schema)

3. Physical ( Physical Database objects)

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

Recursive relationships are an interesting and more complex concept than the relationships you have seen in the previous chapters, such as a one-to-one, one-to-many, and many-to-many. A recursive relationship occurs when there is a relationship between an entity and itself. For example, a one-to-many recursive relationship occurs when an employee is the manager of other employeess. The employee entity is related to itself, and there is a one-to-many relationship between one employee (the manager) and many other employees (the people who report to the manager). Because of the more complex nature of these relationships, we will need slightly more complex methods of mapping them to a schema and displaying them in a stylesheet.

What is an artificial (derived) primary key? When should it be used?

Using a name as the primary key violates the principle of stability. The social security number might be a valid choice, but a foreign employee might not have a social security number. This is a case where a derived, rather than a natural, primary key is appropriate. A derived key is an artificial key that you create. A natural key is one that is already part of the database.

Whether artificial primary key is equvalent to the row_id of the table or it is the the combination of the previous primary key field and the new field which creates the importance of it.

Some Technical points

What is the main difference between "portability" & "Platform independent"?

Portability focuses on adaptation of software in various OS, by recompiling the source to make the binary compatible with the target OS and not necessarily modifying the source. If the source code strictly follows POSIX standard less likely one end up modifying it.

Platform independence focuses on ability of software to run on VIRTUAL hardware that inturn interfaces with the PHYSICAL hardware. Examples of cross-platform or platform independent languages are Python, JavaScript, Java etc.

Hope it helps. Let me know.

What is the difference between collision domain and broad cast domain?

A collision domain is a logical area in a computer network where data packets can "collide" with one another, in particular in the Ethernet networking protocol. The more collisions in a network the less efficient it is.

A broadcast domain is a logical area in a computer network where any computer connected to the computer network can directly transmit to any other in the domain without having to go through a routing device.

What is data modelling?

Designing a normalized schema is known as data modeling

Data Modelling is designing of the data content and structure of the database.

The data model documents the structure of and interrelationships between the data - it is presented as a combination of simple diagrams and written definitions and is independent of any DBMS software or hardware considerations.

Designing a de- normalized schema is known as dimension modeling

What is virtual Memory under Linux?

Linux supports virtual memory, that is, using a disk as an extension of RAM so that the effective size of usable memory grows correspondingly. The kernel will write the contents of a currently unused block of memory to the hard disk so that the memory can be used for another purpose. When the original contents are needed again, they are read back into memory. This is all made completely transparent to the user; programs running under Linux only see the larger amount of memory available and don't notice that parts of them reside on the disk from time to time. Of course, reading and writing the hard disk is slower (on the order of a thousand times slower) than using real memory, so the programs don't run as fast. The part of the hard disk that is used as virtual memory is called the swap space

Can we execute any simple program without installing any Operating system?

Why not? We can execute programes without operation system 'cause many machines like automatic washing machines, microwave and many other device do not have operating system but they execute program 'cause programs are implemented in there chip.

Business Analyst Interview Questions.

What is the carreer path for a Business Analyst?

A Business Analyst in the IT field has many varied directions among which to choose a career path. The most direct would lead to a Lead Business Analyst position and then Project Manager whereby the incumbent manages projects through the entire lifecycle from inception to post-implementation including the management of business analysts, system analysts, quality assurance analysts and most likely development project managers or team leads. That path would then lead to Program Management, perhaps PMO management or Product Manager and on to Directorship.In addition, a good Business Analyst may find they are heading toward a Customer Relationship Manager position whereby they become the primary IT interface to a given Business Unit (BU). This role most often leads to a position within the BU as a Manager of Applications or a Process Management role. Process Management opens many jobs including process re-engineering, quality program development, and large scale or enterprise process management programs such as ITIL or Six Sigma initiatives. These roles will continue to proliferate as companies realize the benefits of having a SME in process and quality.And still many Business Analysts find their understanding of business process entirely portable into purely system related positions in the business side that are only peripherally related to IT. These of course may lead to quantitative roles, manager roles or operational roles such as supply chain, logistics et cetera.Of central importance to a successful Business Analyst is the interest in speaking to people. Face to face verbal communication is paramount to support other tools such as surveys and diagrams. Incumbents must be interested in understanding not only the pieces that comprise a system, but the people that comprise it and the realities that embrace the system. Briefly, the Business Analyst must understand and not judge the "what should be" and the "what is".

How do you resolve issues?

Its really simple as you have to check out the folowing:

(1) who(who made this issue),what(what was the actual cause of the issue?),when(when did this issue occur?),where ( where did this happen),why(why did this happen),how( how did this happen)?

and last but not the least you have to use your brain and common sense.

Take for and Example Like:

If an issue comes up saying that people are not doing their work properly in an office and in the end of the month the outcome of performance is not upto the expectations of the standards of the company. then we must look out for the following like helding up Meetings and pointing out people whose standards are not upto the mark and try to help in motivating them, and try to improve their faults, in making efforts to improve their performance standards and and then if things are not going as expected then actions should be taken against them which in Rare cases may result in Termination/suspension/or demotion of the specific employee. this is how most of the issues can be resolved....

How would you transform business requirements to functional requirements?

imple, if I am understanding your question right; Which is the most easiest way to find function requirements: USE CASES make use case for each function of system

What problems did you run into while gathering requirements?

Problems faced while gathering Customer Requirements.
Communication problem.
Inconsistent or contradictory statements which leads to delay.
Difference in Industry Knowledge.
Note: Above mentioned factors can be controled if same process is followed by the vendor as well as the Client.

Project Manager Interview Questions

How do we make Function Point Analysis.

Functional point analysis is a concept of finding out estimates in terms of points. It is one of the best practice of finding out estimates irrespective of any technology dependency.
FPA is divided into 4 attributes. All these 4 Attributes are nothing but functional key ares of transcation.
For Example:
1. Input
2. OutPut
3. Input External Data
4. Output Internal Data

*Query data is not considered as FPA points.

What are the main objects of a project manager?

Project Manager main objective are as follows:

1. Plays every important role as stakeholder and with Stakeholder.
2. He has to drive the show in terms of Technical, Financial, Risk Mitigation, & never the less the delivers.
3. Main moto is to ensure every area of assurance of compliance in terms of delivery.
4. He has to be people's person with pleasent personality.
5. Softskill is another key area of his expertise.
6. Time, Material, Cost, Technology/Performance & Resource is his area of play

Why every business needs a website

If you are operating a business, any business, you must have a website.

Why?

The answer is simple; a website has the functionality to work for your business. Websites serve to attract new customers and inform current customers. The website is very similar to a salesperson or company rep and is adding to your sales force. A website has the potential to be your best employee and serve as an image for your company.

The main reason is that a website can attract new customers. A website is open 24 hours per day providing valuable information to potential customers. Not only is it important for web traffic, but customers notice when your business card does not have a website address on it. A website is one of the most powerful sales tools that a business could purchase. That is why every business would benefit form a professional website.

Websites serve as a great customer service tool. From simple F.A.Q. sections to complex repair guides, a website can deliver great customer service and reduce the number of needless service calls. A well built website will make it easy for customers to find solutions. The customer service aspect of a website makes it very smart for every business to have one.

A website can provide many of the same services that a sales rep. is capable of, however the website does not take a break, need a vacation, overtime, health insurance or a parking space. A website can never be late, need maternity leave, sick leave or even be stolen by the competition. A website is a sales person that you, the business owner, have complete control of, it is a great asset.

Finally, a website can serve as a company image. Do you know the difference between a large corporation and a small business online? That is because there is not one. The smallest one person company can have a website that is equal to or surpassing that of a large corporation. It is just a matter of seeing that fact and pursuing a great website.

I hope that by this point it is clear that every business does in fact need a website. If you do not have one, make sure you contact a web designer today. You known your competition will be!