Monday, 3 October 2016

50 TOP MARINE Engineering Interview Questions and Answers for freshers and experienced pdf

TOP MARINE Engineering Interview Questions and Answers pdf download

1.What is motor bike c.c.?
cubic/centimeter

2.How the priming is done in a centrifugal pumps?
As centrifugal pump is not a self priming pump,separate priming arrangement is required…generally,a separate axial pump is provided for this
purpose.The discharge v/v of the centrifugal pump is closed,and the inlet v/v is opened.The discharge v/v is opened only after the pump is
primed,that is filled with the liquid to be pumped.

3.What is the different between gate valve and globe valve?
Gate valve is non regulator means full close or full open positions only, while globe valve is regulator.

4.What is the purpose of o-ring, wearings in the centrifugal pumps?
O-ring : to prevent leakage between metal parts while allowing some movement between them wear ring : generally a softer material than the
parent material , employed to wear out quickly than the parent metal thereby avoiding loss of parent metal

5.what is the difference between Mitsui MAN b&w and Hitachi MAN b&w engines?
Design and system wise absolutely no difference. Only the license manfacturer is different. mitsui and Hitachi
kawasaki Diawoo are the different license holders for Man B&W for making the engines

6.How will we know, without opening anything,that an engine is 2S or 4S?
by the arrangement of the valves …in two stroke exhaust valve is situated at the top(i.e cylinder head) and there are scavenge ports at the
bottom in modern diesel engine…whereas in four stoke the exhaust and inlet is situated at the cylinder head.

7.How the power has taken from a large marine generator to the msb?
The 440v generated by the generator can be taken to the MSB via busbars. associated with preferential trips, overload protections

8.What is the meaning of code number which is given on bearing?
bearing number ia 6205z:
 6 stands for the type of bearing , ie, deep groove ball bearing
 02 standa for the the OD and width (thickness) of the bearing
 05 stands for the ID of the bearing ie, 05 x 4= 20 mm bore;

9.In ship cranes, there is a provision of providing a conveyor for the cable. There is no provision of slip ring.How is it possible?
There r Slip ring arrangement in cranes onboard ships. the slip rings are present within the crane which is not seen from outside. the power
lines pass throough the centre of the crane through slip rings. The power line u see out side is only for grab which comes through the torsion
clutch. If there is no slip ring arrangement the crane cannot turn 360 degrees.

10.Which country level having below the means sea level?
Narve sweedan

11.What does 7L67GFCA stands forin a marine engine MITSUI B&W 7L67GFCA?
7L 67GFCA Means that the engine have seven in-line units (cylinders)with 67centimeter of Liner diameter,water cooled and super charged cross
head engine.

12.What is high temperature corrosion and what is center priming?
When material exposed to high temperature atmospehic situation like high level of oxygen presence, sulfer
presence and different type chemical presence cause matrial worsening . This type of material corrosion is
known as High temperature corrosion

13.What is specific fuel consumption and how fuel calculate?
generally it�s refer to the fuel consumtion rate, there are several deferent way to catlculate the specific fuel
consuption, such as volumetric method and flow method. but these methods can be taken only in lab. no possible do it on the sea.

14.How many types of ships?
Ships are divided into various types depending on their nature of service.
1. Cargo Ships (Bulk carriers, general cargo carriers,container vessels, oil tankers, chemical tankers, product tankers, gas carriers, Ro-Ro
ships). Depending on their sizes they are again classified as handymax, panamax,suezmax, afromax, vlcc, ulcc, vloc, vlgc, etc.
2. Passenger Ships
3. Serivce ships, such as cable laying submarines, off shore supply vessels, dp vessels etc
4. Protection such as war ships, Navy submarines etc.

15.The place where happen iron losses?
In transformer case Core occurs iron loss (Eddy Current & Hysteresis Loss) Or No Load Loss in Electric Transformer.

16.How many ports are there in India?
there are 12 major ports and 181 minor port in india

17. Why did you become interested in Marine Engineering?
A1 - A great way to make a living. Decent money, big chunks of time off, almost no commute. Somewhat of an adventure, interesting, challenging,
industrious are some words I like, which describe what I do.

18. Have you always wanted to be a Marine Engineer? or What made you become a marine engineer?
Not really. I have always like machinery or structures: drawing trucks and buildings were always my favourite pastime. LEGO were my favourite
toys. I always wanted to do something creative which would perform a function. I originally wanted to get into graphic arts and advertising,
but was lured away by the honesty of the sea and nature.

19. What do you like most about your job? or What is the best part of your job?
There are many aspects that I really like; but standing between two main engines while we are full away; the car size turbo-chargers whining,
the "rumble" shakes your very core; is very awe inspiring. Then to think, it's your responsibility!

20. What tasks does your specific job involve?
The list is very big. Too big in fact. The engineer is in charge of everything mechanical, electrical, or structural on the ship. The toilets
don't work, we go find the problems - and it's usually not pretty. From the computers to the crankshaft, air conditioning to refrigerators,
doors to windshield wipers, you name it, we must be able to make it work. I say that because we usually know how to fix, but as you can well
imagine, a person can't know it all. So basically, we must be knowledgeable enough to recognize a problem, then either fix it, make due, or
call in the specialists. We deal with it! out in the middle of the Atlantic, there's not many auto parts stores, and even less room for
excuses.

21. Are you given a variety of projects to work on so that the job does not become boring? or Is it fun and exciting?
The nature of the Job always poses a large variety of challenges, everyday it's a different one. But boredom is definitely present on some
ships. For instance search and rescue ships which do allot of waiting and "sitting around", just like a fire dept. Some keep busy doing
"rabbits" -a personal project. One guy machined an entire miniature steam engine over a period of time. It is a bit mundane at times, but I
think it takes many year before you start getting bored, and that might be only if you are on the same ship, on the same run.

22. What kinds of challenges are you faced with while on the job? or What's the hardest thing you've had to do at your job?
The biggest challenge is getting along with people you have never met before and entrusting your life to them, like you would to your best
friend. Might seem a bit dramatic, but I think it's the most challenging task. You don't have the option to go to a warm home and "recharge
your batteries" if you've had a bad day. As for the rest of the tasks, you do what you can. Generally everyone on a ship is qualified to be
there and somewhat competent. You can work together to tackle big technical challenges, which goes to the top of the answer, getting along is
the biggest challenge.

23. What sort of risks do you deal with?
Life threatening risk are very present everywhere on a ship. The sea itself is not always picturesque, large machines moving fast, lots of fuel
to fuel fires, a multitude of chemicals, large quantity of electromagnetic waves: The ship in itself can be a very hazardous place to be, it is
always moving, even more so when you're doing work like commercial fishing, or replacing a ten ton buoy while at sea.

24. What physical condition must you be in?
The mental state is most crucial. But you're physical well being contributes a great deal as well. Most ships have work out rooms where you can
exercise. You have to be reasonably in good shape, this is to climb all those stairs. You need people that can, and will react in times of
emergencies -such as firefighting on board.

25. What does one need to do in order to succeed in Marine Engineering?
Good questions, when you find out, please let me know. I think its a matter of living in harmony, with people, machines and the environment.
You give respect, and hopefully you get it in return. Respect, in my opinion, is based on knowledge, the more you know the better decision you
can make, the better things go, the more respect you can command.

26. Is there an equal opportunity for women. Is it a popular career with women?
Not really. It is a worldwide occupation and allot of the seafarers in the modern merchant marine come from third world countries, where it is
not readily accepted to work for a woman. So allot of companies, I think, tend to shy away from crewing with a mix. This is changing, albeit
slowly, but changing.

27. I heard its tough to move up through the ranks, is Marine Engineering a serious career consideration for young Canadian?
Q11B - Did you experience any challenges in your career?
Q11C - Would you recommend this career to any student?
Q11D - Do you have any tips or advice on becoming a Marine Engineer?

28. Your questions, which seem to me to be as simple as "I'm I going to have a tough time feeding myself with dignity" the short answer is
perhaps. It is a very reasonable question since your candidate profession is not an easy choice. You would be better off getting a BSc from UBC
since it cost about as much, but you wont deal with isolation from civilization and probably wont have a tough time finding a job after your
final year because "people" are more familiar with what a University or College is.

29. The main reason for this answer is that our profession is an international one, and the realities is that Canada, and our standard of pay
is higher due to our high taxes and cost of living compared to other countries. As a result it will be hard for you, at first, to find a job
that you would be happy with internationally; and locally you will not be taken seriously because you haven't been in the field for 20 years.
That's just the way it is.

30. Having said that, I love my job. I love being around machinery, being around different people, and the ability to work in environments
people only fantasize about. It was tough at first, matching the needed ambition to complete the program, with the realities of the work, and
its availability, but things are getting better now. With self confidence that comes with experience, I believe my outlook is very bright in
Canada, and overseas. ...but it has taken me almost ten years !

31. Another words, if you are into instant gratification, marine engineering is not for you. You are getting into a field that requires a great
deal of long term investing towards something where the payday is, in monetary terms, generally not that impressive compared to other viable
avenues for young Canadians. There are allot of unknowns, upsets, tough times, but if you can keep focus on the big picture and persevere, you
will be able draw much satisfaction and pride that comes from working in environments that challenges most human faculties. You'll have to have
the confidence to tackle just about anything, and generally never be out of work. Some other benefits are - reasonably good pay, legislated
jobs opportunities (you'll always be needed), when you are not away working, your home for months at a time without having to take work with
you (unless you have a website), you can work anywhere in the world equally well. And you can branch out into numerous career alternatives to
sea going.

So its up to you to decide. If you play the lottery all the time hoping for a big payoff, then this career may not be for you. If you feel
gratified by displaying patience, dedication, and applying yourself to hard work, then you will appreciate this line of work. There is no easy
meals, but you'll never go hungry being a Marine Engineer in any part of the globe.

32. How much time do you spend on ships?
That depends on the company or the type of work. Generally, as an officer, you get one day off the ship for everyday worked, I usually don't
work for anything less than day for day. I onced worked 14 weeks away working on a ship, then I go home for 14 weeks, I've also worked  3
months on 2 months off, 2 weeks on 2 weeks off. 4 weeks on 4 week off is my favorite, but right now I work 6 weeks on 6 weeks off. 

33. Do you travel a lot for your job?
A ship by its very nature is always moving, not always to new places, but yes we travel allot. Signing on the ship and signing off the ship, on
the other hand, means we travel on planes, buses, trains, vans, cars, water taxis, walking and spending lots of time in airports. I consider
myself a seasoned traveller.

34. Do you design new equipment for ships?
Currently no. I work on the operational side of things onboard, so just maintaining the machines is a big enough job. We always have some
improvements to machines designs or processes but these are usually minor in nature.

35. How long have you been a Marine Engineer?
I started as a Marine Engineering Apprentice in 1996, achieved my first license level, a 4th Class Certificate of Competency (CoC) in 1999. I
achieved my second license level in 2002. There are four license levels.

36. What do you do on a daily basis? or What exactly do you do?
Right now, 2015, I work as Chief Engineer onboard a smaller Trailing Suction Hopper Dredge, a sort of big vacuum cleaner ship. My
responsibilities are extensive and I answer only to the Captain and the Superintendent ashore. I usually manage at least one other Engineer,
and together, we maintain the vessel with the aim of it always being available to perform its task.

In 2006, I worked on a large passenger ship in the capacity of Second Engineer. At any given point in the day there is two officers in charge
of the operations of the ship; one is on the Bridge - the Navigational Officer of the Watch (OOW) - one is in the Engine Room - the Engineering
Officer of the Watch (EOW) - I am the one in the engine room. I am in the control room of the ship (see picture), and monitor the engines and
just about every other system on the ship - from elevators function to fuel temperature, to water pressure for the showers. If there is any
problems, I rely on my experience and expertise to figure where the problem is and formulate a response. We have three Engineers in this
particular position and we are assisted by 1-3 other crew in the actual engine room. The OEW work 8 hours a day in the Control Room, and we
also have areas of responsibility in the engine room, where we spend an additional 3-4 hours maintaining "our" equipment. 

37. Where do you do your work? and How long did it take to get to your current place in your career?
Right now, in 2015, I work as a Chief Engineer the most senior engineer onboard, on smaller ships and large tugs. I am limited to the size of
ships (amount of horsepower - 4000hp) due to my lower Certificate of Competency (CoC). When I reach the First Class CoC, I will be able to be
CE on any ship, anywhere in the world. It took me about 9 years after my initial training to get to be in the position of CE.

In 2006, I work on the Rhapsody of the Seas (pictured), and large passenger cruise ship operating out of Galveston, Texas, in the Gulf of
Mexico. It had taken me about 6 years to get to this current position of responsibility.

38. How many years of college did you go through? and What college would you recommend to pursue a career in marine engineering? or What type
of education do you need to get to your current place in your career?
On the Training Page you will find most answers to these questions. As for me, I completed a four year Marine Engineering Apprenticeship which
means that I was hired by a company, then sent to a dedicated school, BCIT's Pacific Marine Campus in North Vancouver, where I had structured
formal training for about 4 months every year. Currently, its a little different, you sign up as a Cadet with the school and then you do your
practical time at sea with various companies. Check out the Training Page for further info. 

39. What was the best moment in your career?
There is no particular best moment I can remember. They're are so many, even more that I've forgotten until someone brings it up again over
beers. So there is no answers to this question. As most everyday, something new and sometimes, exciting, happens.

40. Did you ever come across something you couldn't do in your career?
As engineers, most people turn to us for answers and results, generally there is nothing we can't do; and those things are only restricted by
preconceived notions of what should be and accountants.

41. What college degree do most marine engineers have ?
Most Marine Engineers in Canada do not have a degree per se, if they work on a ship. There is a title of Marine Engineers that some people
carry, because they have gone to University, have taken Mechanical Engineering and specialized in marine structures such as wharves, oil rigs,
ship design, etc. Marine Engineers referred to in this website, are operational engineers for the most part. They have taken pretty much the
same basic courses as a Mechanical Engineer, but also have much more hands on courses as well. Ship's engineers do not specifically hold a
"Degree" but instead hold a "License" or "Certificate of Competency (CoC)" which is issued by high level government agency, and is recognized
internationally. The CoC is what allows persons to claim the title of Officer on a Ship. Some marine university offer "bridging" courses which
will enhance the Officer's training to achieve a "land recognized" University Degree.

Nowadays, new entrant in the field under the Cadet Program are granted a Bachelor of Science degree with the completion of the program.
However, this is still a gray area, and certainly worth investigating, as generally, a shore side position later in life, values these paper
things more than seagoing experience. 

42. What subjects in school would you need to excel at to become a marine engineer?
Physics, calculus, trigonometry, algebra, so on and so forth play a major role in the training, also sciences are pretty important, in

particular Chemistry. Anyone considering any engineering path should feel comfortable challenging these subjects.

Thursday, 22 September 2016

16 TOP Informix Interview Questions and Answers pdf free download

1. Somehow Informix fails to go online. Is there a way to view what oninit is doing?
Yes, you can start Informix in verbose mode:
oninit -v (this works on NT as well)
Informix will print everything that happens.
To close the verbose mode: start a second terminal session (UNIX) or command prompt (NT) and execute:
onmode -ky
N.B. Don't close your terminal session (UNIX) or command prompt (NT) while in verbose mode. This will take Informix offline immediately.

2. I think I screwed up my onconfig file, and I do not have a backup of it. What should I do?
If Informix is still online, you can get a new onconfig with:
onstat -c >onconfig
If Informix is offline, you can retrieve the settings from the database with:
oncheck -pR
or
oncheck -pP 1 1

3. Can I install Informix on a non-English version of Windows NT?
Yes, but you need to install version 7.30 TC 6 or higher.

4. What is the informix-list@iiug.org mailing list?
The informix-list@iiug.org mailing list is a bi-directional gateway to the comp.databases.informix (c.d.i) UseNet news group. Messages posted
to the news group are forwarded by mail to subscribers of the mailing list; responses sent to the informix-list@iiug.org email address are
also posted to the news group; and the gateway manages to keep track of things so that postings do not repeat themselves. The mailing list is
'closed' in that you cannot post directly to the list unless you also subscribe to the list. However, you can always post to the news group
instead; that is fully open and unmoderated.

5. What Rules Exist Regarding Format, Content, Flame Wars, etc None; this is a news group! That is, there are no rules enforced by the
software. There are periodically discussions on c.d.i about what should and should not be said. This is my FAQ, so it gets my spin on the rules
that should be followed.

* Format: HTML postings are strongly discouraged; so are MIME postings. Both cause problems with many frequently used news readers. That means that attachments aren't encouraged either.
Also, sending the same information twice, once in HTML and once in plain text, is downright wasteful.

6. Can I ask about Perl, DBI and DBD Informix? Other products?
You may ask questions about Perl, DBI and DBD::Informix, but only if an IBM or Informix database is involved, somehow -- it is not a general
forum for arbitrary questions about Perl. However, there are alternative forums that you should also use, described in the product.
However, those locations have changed over time, so you should be aware of the official home, http://dbi.perl.org/, which contains pointers to
how to subscribe to the dbi-users at perl.org (anti-spammed) mailing list. Note that (as of 2005-03-01 and v2005.01) the email address for
DBD::Informix support is dbd.informix at gmail.com (anti-spammed).

7. What is chunk in Informix?
A chunk is a physical portion of disk on which Informix stores its data. A chunk can be either a raw partition or a file system file. Informix suggests that a chunk's name be a symbolic link to the actual chunk. For example, if you are using /dev/rdsk/c6t0d0s1 as a chunk, you could create a symbolic link named /dev/informix/chunk1 that points to /dev/rdsk/c6t0d0s1. That way, if there are ever any problems with that disk, you could replace the disk with another one and just change the symbolic link.

8. What is Informix instance?
An Informix instance is a single connection to shared memory. It is represented by one or more on init processes. When Informix is started or stopped, these processes appear and disappear. Informix used to use the term "server" when referring to an instance, hence the environment variable DBSERVERNAME.

9. What are the uses of key value locking in Informix?
he database server uses a concept called key-value locking to lock the deleted row. When the database server deletes a row, key values in the indexes for the table are not removed immediately. Instead, each key value is marked as deleted, and a lock is placed on the key value. One of the most important uses for key-value locking is to assure that a unique key remains unique through the end of the transaction that deleted it.

10. Who conceived and designed the Informix database management system?
The Informix database management system was conceived and designed by Roger Sippl in the late 1970s. Informix was founded in 1980, went public in 1986, and for a period during the 1990s Informix was the second most popular database system, after Oracle.

11. What is the option or command used in Informix for finding which dbspace a database resides?
from command line# onmonitor ->Logical-Logs->Databases

12. Who developed informix?
IBM released Informix

13. Mention the database server operating modes available for Informix?
Informix IDS provide following modes:-
1)Online mode -> This is the normal operating mode of the database server.
2)Offline mode? -> The database server is not running. Shared memory is not allocated.
3)Quiescent mode -> This is the normal operating mode of the database server.
Administrators use this mode to perform maintenance functions that do not require the execution of SQL and DDL statements.
Only the administrator (user informix) can access the database
server.
4)Single-User mode -> This mode is an intermediary mode between Quiescent mode and Online mode?
Administrators use this mode to perform any maintenance task, including tasks requiring the execution of SQL and DDL statements. Administrators can also perform all other functions available inOnline mode. You can see the current database server mode by executing the onstat - utility from the command.

14. Explain about light scans in Informix?
Light scans occur under the following conditions: The optimizer chooses a sequential scan of the table. The number of pages in the table is greater than the number of buffers in the buffer pool. The isolation level obtains no lock or a shared lock on the table: Dirty Read (including non logging databases) isolation level Repeatable Read isolation level if the table has a shared or exclusive lock
Committed Read isolation if the table has a shared lock

15. What is extent in Informix?
If a table is designed without specifying extent sizes, Informix uses a default of 16 pages for the first and 8 pages for each subsequent extent. Extent sizing is done when the table is initially created.

16. What is Informix Binary Large Object?
A binary large object, also known as a blob, is a collection of binary data stored as a single entity in a database management system. Informix invented an alternative backronym, Binary Large Object. Blobs are typically images, audio or other multimedia objects, though sometimes binary executable code is stored as a blob. 

25 TOP Data Modeling Interview Questions and Answers for freshers and experienced pdf download

1. Give us a non-computer example of preemptive and non-preemptive scheduling?
Consider any system where people use some kind of resources and compete for them. The non-computer examples for preemptive scheduling the traffic on the single lane road if there is emergency or there is an ambulance on the road the other vehicles give path to the vehicles that are in need. The example for preemptive scheduling is people standing in queue for tickets.

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

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

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

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

6. What is ERD?
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

7. What is third normal form?
An entity is in the third normal form if it is in the second normal form and all of its attributes are not transitively dependent on the primary key. Transitive dependence means that descriptor key attributes depend not only on the whole primary key, but also on other descriptor key attributes that, in turn, depend on the primary key. In SQL terms, the third normal form means that no column within a table is dependent on a descriptor column that, in turn, depends on the primary key.

For 3NF, first, the table must be in 2NF, plus, we want to make sure that the non-key fields are dependent upon ONLY the PK, and not other non-key fields for its existence. This is very similar to to 2NF, except that now you are comparing the non-key fields to OTHER non-key fields. After all, we know that the relationship to the PK is good, because we established that in 2NF.

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

9. Is this statement TRUE or FALSE? all databases must be in third normal form?
In general all organization data bases are normalised to 3nf inorder to remove redundancy and efficent access.A data base can also be created with out normalisation.Hence it is not a mandatory that a database should be in 3nf.

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

11. What is second normal form?
An entity is in the second normal form if all of its attributes depend on the whole (primary) key. In relational terms, every column in a table must be functionally dependent on the whole primary key of that table. Functional dependency indicates that a link exists between the values in two different columns.

If the value of an attribute depends on a column, the value of the attribute must change if the value in the column changes. The attribute is a function of the column. The following explanations make this more specific:

If the table has a one-column primary key, the attribute must depend on that key.
If the table has a composite primary key, the attribute must depend on the values in all its columns taken as a whole, not on one or some of them.
If the attribute also depends on other columns, they must be columns of a candidate key; that is, columns that are unique in every row.
If you do not convert your model to the second normal form, you risk data redundancy and difficulty in changing data. To convert first-normal-form tables to second-normal-form tables, remove columns that are not dependent on the primary key.

12. Which of the following indicates the maximum number of entities that can be involved in a relationship?
A. Minimum cardinality
B. Maximum cardinality
C. ERD
D. Greater Entity Count (GEC)
Answer: B

13. Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?
A. Weak entity
B. Strong entity
C. ID-dependent entity
D. ID- independent entity
Answer: A

14. In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
A. parent
B. child
C. instance
D. subtype
Answer: A

15. Which type of entity represents an actual occurrence of an associated generalized entity?
A. Supertype entity
B. Subtype entity
C. Archetype entity
D. Instance entity
Answer: D

16. A recursive relationship is a relationship between an entity and ________ .
A. itself
B. a subtype entity
C. an archetype entity
D. an instance entity
Answer: A

17. Which of the following indicates the minimum number of entities that must be involved in a relationship?
A. Minimum cardinality
B. Maximum cardinality
C. ERD
D. Greater Entity Count (GEC)
Answer: A

18. Which of the following refers to something that can be identified in the users' work environment, something that the users want to track?
A. Entity
B. Attribute
C. Identifier
D. Relationship
Answer: A

19. In which of the following is a single-entity instance of one type related to many entity instances of another type?
A. One-to-One Relationship
B. One-to-Many Relationship
C. Many-to-Many Relationship
D. Composite Relationship
Answer: B

20. Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?
A. Weak entity
B. Strong entity
C. ID-dependent entity
D. ID-independent entity
Answer: C

Friday, 26 August 2016

TeraData Multiple choice Questions and Answers for freshers and experienced pdf

1.Teradata Has been called a ---------------- architecture.
A. Shared Nothing
B. Anything  Goes.
c. Shared Nothing.
D.Dual Redundent.
ANS::A

2. What are attributes of the teradata database.
A. The Optimizer is parllel aware
B. only runs on UNIX.
C. Data distrubution is Automatic.
D.Designed around online Transaction Processing.
ANS:: ACD.

3. What does linear Scalability provide?
A.Protection on Investment for application Development.
B.Unconditional,quick response times for data quires.
C. Increase workload without decreased through put.
D. Consistent results with inconsistent data.
ANS:: A,C.

4. Which two Statements are true concerning the benefits of a business modal?
A.  The Data modal is consistent  no mater how much data.
B.  Data is organized by what it represents.
C.  Data never Skewed.
D.  Allows DBA’s to distribute data properly.

5.  Whoose the attributes which best describe OLTP?
A.  Based on transational set theory.
B.  Exceptional for processing ad hoc quires.Small number of rows for transaction.
C.  Small number of rows for transaction.
D. Transaction tipically occur in seconds instead of minutes.
ANS:: C,D.

6. What are the following object required for Teradata Database-Prem space?.
A. Tables & Stored Procedure
B. Tables & Views
C. Macros & Triggers
D. Views & Stored Procedures
Ans: A

7. Global Temporary Tables are stored in the TD are
A. Perm Space
B. Spool Space
C. Temp Space
Ans: C

8. Terabytes represent
A. 10 power 15
B. 10 power 12
C. 10 power 18
D. 10 power 24
Ans: B

9. SMP Stands for
A. Symmetric Multi-processor
B. Symmetric Massive-Processor
C. System Multi-processor
D. Symmetric Multi-Processor
Ans: A

10. Total Number of nodes suppport by BYNET are
A. 510 SMP Nodes
B. 512 SMP Nodes
C. 513 SMP Nodes
D. 514 SMP Nodes
Ans: B

11. The definition of TPump is continuous update of tables; performs insert, update, and delete operations or a combination of those operations on multiple tables using the same source feed.
A. true
B. false
Ans: A

12. Teradata Database facilities for software falut tolerance on
A. Vproc Migration & Fallback tables
B. AMP Clusters & Journaling
C. Backup/Archive/Restore
D. Table Rebuild Utility
E. All of the above
F. None of the above
Ans: E

13. Success/Failure/Error responses from Teradata are received by
A. Request Parcel
B. Data parcel
C. Response Parcel
Ans: C

14. Explain command displays the execution plan of the query chosen by the Teradata Optimizer
A. False
B. True
Ans:B

15. HASHROW funtions is
A. Returns the hash bucket number that corresponds to a specified row hash value.
B. Returns the hexadecimal row hash value for an expression
C. Returns the AMP number of the primary AMP corresponding to the specified hash bucket number.
D. Returns the identification number of the fallback AMP corresponding to the specified hash bucket.
Ans:B

16. Teradata has been called a  ------- architecture.
A. Shared Nothing
B. Anything Goes
C. Shared Everything
D. Dual Redundant
Ans: A

17. "Hello Chris" is a statement that makes Chris feel ________.
A. hello
B. Possible
C. Happy
D. Sad
E. Pleased
Ans: B

18. What type of company is Teradata?
a. Public
b. Privately held
c. Private, LLC.
d. Subsidiary of Vodafone Plc
Ans: A

19. Where is Teradata?
A. United States
B. Illinois
C. Colorado
D. Arkansas
Ans: A

20. Who of the following is a key person at Teradata?
A. Warren East
B. Bob Fair, Executive Vice President, Global Sales and Services
C. Girlie M. Aragon,
D. Ola Forberg
Ans: B

Thursday, 2 June 2016

Delphi Interview Questions and Answers for freshers and experienced pdf free download

1. What is Delphi? 
Delphi is a product of Borland International. It is a native code compiler that runs under Windows 3.1 and provides visual programming tools somewhat similar to those found in Microsoft Visual Basic 3.0. The underlying language is Object Pascal, which is an extension of the object-oriented Pascal found in Turbo/Borland Pascal starting with version 5.5.

2. What versions of Delphi are there? 
Delphi has been available in beta-test for many months now, and Borland has also given away a large number of "prerelease" copies. As far as the official release is concerned, though, there are two packages: Delphi (sometimes referred to as Delphi Desktop) and Delphi Client/Server. Both are version 1.0.

3. What operating systems does Delphi support? 
The only version of Delphi that has been released is for Windows 3.1. There is no reason why it should not run correctly under systems that provide Windows 3.1 emulation, like OS/2 Warp, Windows NT, etc. Borland has announced plans for a 32-bit version to coincide with Windows 95. It is rumored that this might be a free upgrade to users of Delphi 1.0, but I wouldn't count on it. It is also known that Delphi 1.0 does not run correctly on the prerelease version of Windows 95.
Applications built in Delphi are Windows 3.1, 16-bit applications. However, Borland has stated that existing Delphi applications will compile unmodified in 32-bit Delphi.

4. How much disk space, memory, etc, do I need to run Delphi? 
The minimum installation of Delphi takes about 30Mb, and the full install takes 80Mb. In order to run it well, you'll need a 486 with a minimum of 8Mb of RAM, though I personally wouldn't try to run it in less than about 12Mb. I use a 486DX2/66 at home and a Pentium-90 at work, and to be honest, there's not much difference between them--Delphi's compiles are so fast that the CPU is really not a bottleneck.

5. How tough is it to learn Delphi? 
If you're lucky, you already have lots of experience with both Object Pascal (or, as it used to be called, Borland Pascal With Objects--essentially, Turbo Pascal v5.5 or later) and with Visual Basic. If you fit this description, then Delphi will be a breeze for you.
Okay, now for everyone else. In order to make full use of the Delphi environment, you have to know Pascal, you have to have some grasp of object orientation, and you have to understand event-driven programming. Once you're over those three hurdles, you've pretty much got it. See section 5 for more information.
On the other hand, most people don't need to make "full" use of the environment. If you just want to pull a simple application together that doesn't do anything too fancy, Delphi shouldn't be any harder to learn than VB--it's just that there's a whole lot more you *can* do in Delphi, which will make you feel more lost than you really are.

6. What is the difference between Delphi and Delphi Client/Server? 
Delphi Client/Server includes everything from Delphi Desktop, plus the following:
- SQL-Links 2.5, which includes native client drivers for Oracle, Sybase, Informix, and InterBase, and includes full royalty-free redistribution rights to those drivers, and which costs $995 if bought separately;
- The Local InterBase Deployment Kit, $495 ;
- ReportSmith/SQL, $300;
- "Team development support" -- interoperation with PVCS (obviously, this is no use to you if you don't own PVCS), not available separately;
- The visual query builder, which creates SQL statements for you, also not available separately;
- The VCL source code, which is available separately for $100.

7. Can we write multi-user database applications in regular Delphi? 
Using regular, non-client/server Delphi, I have developed an application that talks to a Sybase server using ODBC drivers. I didn't have to go to any serious trouble getting it to work, and data access speed is quite acceptable, better than it was under Visual Basic.

8. What is the history of Delphi? 
Delphi is the descendant of Turbo Pascal, which was first released in 1983 for the CP/M operating system. Turbo Pascal was ported to MS-DOS in early 1984. During the early history of the IBM PC, Turbo Pascal was arguably the most popular language for serious development work--mostly because it was a real compiler, including the program editor and everything, that cost $19.95 and would run on a 64k machine. Borland introduced Turbo Pascal for Windows in 1990. The latest release of Borland Pascal (as it is now called), not including Delphi, was version 7.0 in late 1992.

9. Where can I get a copy of Delphi? 
If you are in the US, You can order Delphi Desktop on CD-ROM for an introductory price of $199 by calling Borland's credit card order desk at 1-800-331-0877. If you are a registered user of any version of Turbo Pascal or Borland Pascal, you qualify for an upgrade price of $149, and you can also buy the Visual Component Library Source Code for $49. The introductory pricing is good through approximately May 15, 1995; after that, the price will be raised to $495. Delphi Client/Server is $1999.
Of course, if you buy through a reseller, you will probably pay less. According to Borland, "Delphi is available through the following US resellers: CompUSA, Best Buy, Elek-Tek, Computer City, Babbages, Software Etc., Fry's, Electronics Boutique, Corporate Software, ASAP Software Express, Egghead Software, Softmart, Software Spectrum, CDW, PC Connection, Programmer's Paradise, Programmer's Warehouse, ProVantage Shop, and Micro Warehouse."

10. What if I do not have a CD-ROM drive? 
Borland will ship Delphi on 3.5" floppy diskettes, but they charge extra for them. The resellers I have spoken to only carry the CD-ROM version because they don't want to have to stock two different items. I got my copy on CD, but the CD has directories on it called DISK1 through DISK15, so I assume it would be 15 diskettes if you got it that way. If you don't get the CD, you won't get the stuff they use to fill up space on the CD, like an AVI file of an animated spinning Delphi logo.