Sunday, November 21, 2010

DOWNLOAD IES MECHANICAL ENGINEERING QUESTION PAPERS


Download IES (Indian Engineering Services)- MECHANICAL ENGINEERING Previous Question papers from 1985 to 2008.
IES OBJECTIVE QUESTION PAPERS.
IES CONVENTIONAL QUESTION PAPERS.
click on the below links to download IES Question Papers. Download starts automatically. All files are in pdf format.
By at No comments:

DOWNLOAD IES ELECTRICAL ENGINEERING QUESTION PAPERS


Download IES (Indian Engineering Services)- ELECTRICAL ENGINEERING Previous Question papers from 1987 to 2008.
IES OBJECTIVE QUESTION PAPERS.
IES CONVENTIONAL QUESTION PAPERS.
click on the below links to download IES Question Papers. Download starts automatically. All files are in pdf format.
IES-OBJ-Electrical Engineering-2008 Paper-II.pdf



IES ELECTRICAL 2009 QUESTION PAPERS
OBJECTIVEPAPER-1 DOWNLOAD
PAPER-2 DOWNLOAD
CONVENTIONALPAPER-1 DOWNLOAD
PAPER-2 DOWNLOAD
By at No comments:

Tuesday, November 9, 2010

FAQ's on Relational Database System


Relational Database Management System

Q1.Which of the following is database element?

(a) Data (b) Constraints and schema
(c) relationships (d) all of these

Q2.What separates the physical aspects of data storage from the logical aspects of data representation?

(a) Data (b) schema
(c) constraints (d) relationships

Q3.What schema defines how and where the data are organized in a physical data storage?

(a) external (b) internal
(c) conceptual (d) none of these

Q4.What is the RDBMS terminology for a row?

(a) tuple (b) relation
(c) attribute (d) domain

Q5.Which of the following Keys in a table can uniquely identify a row in a table?

(a) primary key (b) alternate key
(c) candidate key (d) all of these

Q6.A table can have only one?

(a) primary key (b) alternate key
(c )candidate key (d) all of these

Q7.What is a set of possible data values called?

(a) degree (b) attribute
(c) domain (d) tuple

Q8. What are all candidate Keys,other than the primary keys called?

(a) secondary keys (b) alternate key
(c) eligible keys (d) none of these

Q9.What is the name of attribute or attribute combination of one relation whose values are required
To match those of the primary key of some other relation?

(a) candidate key (b) primary key
(c) foreign key (d) matching key

Q10. What is the smallest unit of data in the relational model?

(a) data type (b) field
(c) data value (d) none of these

Q11. Codd’s Formulation rule states that:

(a) a relational database management system must manage the database entirely through its
relational capabilities.
(b) null values are systematically supported independent of data type.
(c) all information is represented logically by values in tables.
(d) none of these.

Q12. Which of the following is not a data definition statement?

(a) INDEX (b) CREATE
(c) MODIFY (d) DELETE

Q13. Which of the following statements is used to create a table?

(a) CREATE TABLE (b) MAKE TABLE
(c) CONSTRUCT TABLE (d) None of these

Q14. Which of the following is the result of a SELECT statement?

(a) TRIGGER (b) INDEX
(c) TABLE (d) none of these

Q15. The SQL data definition language (DDL) provides commands for:

(a) defining relational schemas (b) deleting relations
(c) modifying relation schemas (d) all of these

Q16. Which of the following is a clause in SELECT statement?

(a) GROUP BY and HAVING (b) ORDER BY
(c) WHERE (d) all of these


Q17. Which of the following is used to get all the coloumns of a table?

(a) * (b) @
(c) % (d) #
Q18. Which of the following clause is usually used together with aggregate functions?

(a) ORDER BY ASC (b) GROUP BY
(c) ORDER BY DESC (d) none of these

Q19. SELECT operation of SQL is a:

(a) data query language (b) data definition language
(c) data manipulation language (d) data control language

Q20. Which of the following is not a DML statement?

(a) UPDATE (b) COMMIT
(c) INSERT (d) DELETE

Q21. Which of the following is not a DDL statement?

(a) ALTER (b) DROP
(c) CREATE (d) SELECT

Q22. What will be the result of statement such as SELECT * FROM EMPLOYEE WHERE SALARY
IN (4000,8000)?

(a) all employees whose salary is either 4000 or 8000
(b) all employees whose salary is between 4000 and 8000
(c) all employees whose salary is not between 4000 and 8000
(d) none of these

Q23. An association among three entities called:

(a) binary relationship (b) ternary relationship
(c) recursive relationsh (d) none of these

Q24. What are the components of E-R model ?

(a) entity (b) attribute
(c) relationship (d) all of these





Q25. The SQL Expression Select distinct T.branchname from branch T,branch S where
T.assets>S.assets and S.branchcity = “NOIDA” finds names of

(a) all branches that have greater assets than some branch located in NOIDA.
(b) all branches that have greater assets than all branch located in NOIDA.
(c) the branch that has the greatest asset in NOIDA.
(d) any branch that has greater asset than any branch located in NOIDA.


Q26. Normalization is a process of

(a) decomposing a set of relations.
(b) successive reduction of relation schema.
(c) deciding which attributes in a relation to be grouped together.
(d) all of theses.

Q27. A relation R is said to be in 3NF if the

(a) relation R is in 2NF
(b) nonprime attributes are mutually independent
(c) functionally dependent on the primary key.
(d) all of these.

Q28. The expansion of BCNF is

(a) Boyd – Codd Normal form (b) Boyce – Ccromwell Normal form
(c) Boyce – Codd Normal form (d) none of these

Q29. The fourth normal form is concerned with dependencies between the elements of compound keys
composed of

(a) one attribute (b) two attributes
(c) three or more attributes (d) none of these

Q30. A trigger is

(a) a statement that enables to start any DBMS
(b) a statement that is executed by the user when debugging an application program
(c) a condition the system tests for the validity of the database user.
(d) a statement that is executed automatically by the system as a side effect of a modification to the
Database.




Q31. Relations produced from an E-R model will always be in

(a) first normal form (b) second normal form
(c) third normal form (d) fourth normal form

Q32. Consider the Join of a relation R with a relation S.If R has m tuples and S has n tuples,
than the maximum and minimum sizes of the join respectively are:

(a) m+n and 0 (b) mn and 0
(c) m+n and m-n (d) mn and m+n

Q33. Functional Dependencies are a generalization of

(a) key dependencies (b) relation dependencies
(c) database dependencies (d) none


Q34. Every BCNF decomposition is

(a) dependency preserving (b) not dependency preserving
(c) need be dependency preserving (d) none

Q35 If we declare A ISA B then

(a) every A entity is considered as B entity
(b) every B entity is considered as A entity
(c) either a) or b) may occur
(d) none

Q36. Which of the following levels of abstraction involves the views of data?

(a)external level (b)conceptual level
(c)physical level (d)none


Q37. Relational operator that yields all possible pairs of rows from two tables is known as

(a)union (b)product
(c)join (d)project

Q38 Referential integrity dictates that:

(a) the value of a primary key must appear in a foreign key of the related table.
(b) the value of a foreign key must appear in a primary key of the related table.
(c) the value of a primary key cannot appear in a foreign key of the related table.
(d) the value of a foreign key cannot appear in a primary key of the related table.


Q39 Which of the following is not a valid aggregate function?

(a) COUNT (b) COMPUTE
(c) SUM (d) MAX



Q40 A table that is in 2NF and contains no transitive dependencies is said to be in

(a) 1NF (b) 2NF.
(c) 3NF (d) 4NF
NOTE: SOLUTION OF THESE DBMS QUESTIONS WILL BE UPDATED SOONLY....
By at No comments:

Monday, November 8, 2010

The Father of Mobile Phone - Martin Cooper



Martin Cooper Inventor Of Mobile Phones
Martin Cooper
CEans,
He changed the world of communications forever. His invention in 1970s helps you keep in touch with your near & dear ones no matter where you are. This MENSAInternational member is also the pioneer of portable hand-held police radio. His ideas helped Motorola mass-produce the first crystals for use in wrist watches. He’s the one & only Mr. Martin Cooper – The Father Of Mobile Phone. Mr. Cooper is the CEO, Founder ofArrayComm & former Vice President Of Motorola Corporation. In our Special Anniversary Edition Small TalkMr. Cooper shares the story of the invention of Mobile Phone and the first ever call made on Cell Phone-
CEan The_Big_K: Sir, your inventions have changed the world and you haven’t stopped! How’s the journey in the hindsight?
Mr. Cooper: I can’t think of anything that I would change in the journey. I have been blessed with extraordinary leaders and colleagues and have been lucky in more ways than I deserve. There have been numerous failures along the way but I hope that I have learned from them. What I have learned most of all, is that the only purpose for technology is improving the lives of people.
CEan AbraKadabra: Tell us the story of your first mobile call to Mr. Joel Engel, Bell Labs Research Head.
Mr. Cooper: The context of that first public cellular telephone call was the battle between AT&T, the largest company in the world, and Motorola, a little company in Chicago. AT&T had approached our government for an exclusivity license for radio frequency spectrum to commercialize their invention of cellular technology. AT&T planned to make a cellular car telephone service. We, at Motorola, believed in a competitive market place and were convinced that the time was ready for personal hand-held telephones-not car phones. AT&T had hundreds of lobbyists in Washington; we had three. We had to do something dazzling and building a working system was my way of doing that. Well who would I call but the head of the engineering program at AT&T?  Although Joel was very respectable during our call, he believed then, and continues to believe today, that Motorola was an annoying impediment to their program.
CE: Could you tell us a bit about the configuration of the first cell phone?
Mr. Cooper: The DynaTAC weighed 2 and a half pounds, over a kilo, and had a battery life of 20 minutes. Pictures of the phone are attached. It was about 10 inches high 4 inches deep intuitive wide. It contains thousands of electronic components, most of which are no longer used today. There were no computers or large scale integrated circuits available in 1973 with which to miniaturize the DynaTAC.
CEan The_Big_K: If you could change one thing from the first cell phone, what would it be?
Mr. Cooper: Why even think about changing something that was so successful? The basic design of the DynaTAC continue to evolve for 15 years.
CEan Durga: What technology available then made you think “This is difficult, but not impossible?”
Mr. Cooper: Motorola was deeply involved in personal communications starting in World War II but peaking in the 1960s and beyond. Our research labs were continuously pushing the state-of-the-art in low drain semiconductors, spectrum efficiency, portable antennas, frequency synthesizers, etc. We knew the phone could be built and we did it. We not only had to make a handset, but a base station, the control circuitry, and we needed installation people, public relations experts, lawyers, and lots of other help to make a successful.
CEan Cooldudeiet: What were the major challenges your team faced while working on the project?
Mr. Cooper: The fact that we had only three months to build the phone was the biggest challenge. People worked day and night to complete the phone and the system.
CEan Musicfreakmandy: What cell phone do you currently use?
Mr. Cooper: I now use a Motorola Droid X but I change phones every six months so I can understand the latest technologies.
CEan Optimystix: What are the latest developments in this field that you appreciate the most?
Mr. Cooper: the implications of wireless technology on medicine and on social networking are going to be huge. The whole nature of medicine is going to change from curing disease to preventing disease. Social networking in the enterprise is going to revolutionize the way we run companies and solve problems. The focus of all of this is personal communications.
CEan AbraKadabra: Your Company, ArrayComm does research about the smart antenna technology. Where is this headed to?
Mr. Cooper: without smart antenna technology, better known as Multi-Antenna Signal Processing (MAS) there will not be enough radio frequency spectrum to do all of the wonderful things that we foresee in the future. All of the new generation cellular technologies will use smart antennas.
CE: What will be your message to CEans?
Mr. Cooper: Reach out! Do not fear failure.
By at 4 comments:
Subscribe to: Posts (Atom)