Friday, October 8, 2010

ISRO Exam Previous Paper


CS/IT Scientific Engineers Recruitment

This Sample Paper is based on the expected syllabus for ISRO Scientist/Engineer Recruitment Exam. Candidates may get an idea about what to read for the Computer Science / IT Stream Examination. We wish all of you a good luck for the paper.
1. Which of the following features usually applies to data in a data warehouse?
(a) Data are often deleted
(b) Most applications consists of transactions
(c) Data are rarely deleted
(d) Relatively few records are processed by applications
(e) None of these
2. Which of the following is a transaction?
(a) A group of SQL statements consisting of one read and one write operation
(b) A group of SQL statements consisting only of ready operations.
(c) A group of SQL statements defining a user-oriented task
(d) A group of SQL statements consisting only of write operations.
(e) None of these
3. There are several security devices used to stop individuals from exploiting your system. Which of the following is used in conjunction with a firewall?
(a) Proxy server
(b) Intrusion- detection system
(c) Terminal server
(d) Web server
(e) None of these
4. The effect of the ROLLBACK command in a transaction is the following……
(a) Undo all changes to the data- base resulting from the execution of the transaction
(b) Undo the effects of the last UPDATE command
(c) Restore the content of the database to its state at the end of the previous day
(d) Make sure that all changes to the database are in effect
(e) None of these

5. A client / server network ……….
(a) has clients that provide functions such as application control and shared computation.
(b) uses client computers to provide copies of software to the server to allow server processing.
(c) provides a company with the capability to downsize from lager computer systems and move away from legacy systems.
(d) has server computers that perform all processing, clients are’ dumb’ input/ output devices only.
(e) None of these.
6. An applet is ……. Document application program.
(a) a static
(b) a dynamic
(c) an active
(d) a passive
(e) None of these
7. The local antenna for satellite connections is called a ……..
(a) modem
(b) terminal
(c) VSAT
(d) DTA
(e) None of these
8. What are the four basis connecting hardware devices?
(a) Repeater, bridge, router and gateway
(b) Repeater, bridge, router and dell
(c) Repeater, connector, router and gateway
(d) Amplifier, bridge, router and gateway
(e) None of these
9. Which type of processing speed measurement is used primarily with supercomputers?
(a) Flops
(b) Fractions of second
(c) Gigahertz
(d) MIPS
(e) None of these
10. This type of software is designed for users who want to customize the programs they use.
(a) Shareware
(b) Open-source software
(c) Freeware
(d) Macros
(e) None of these
11. What is the term associated with the second part of an e-mail address?
(a) Local address
(b) Eight characters long
(c) User name
(d) Domain name
(e) None of these
12. A port that allows 8 bits at a time to be transmitted simultaneously is a (n) …..
(a) dedicated port
(b) parallel port
(c) SCSI port
(d) USB port
(e) None of these
13. In order for computers to communicate across a network, they must be connected through a(n)…..
(a) TCP/IP
(b) Topology
(c) Ethernet
(d) Thin client
(e) None of these
(f) C. Rangarajan
14. What is a specialized software program that allows input and output devices to communicate with the rest of the computer system?
(a) Utility driver
(b) Utility program
(c) Data compression utility
(d) Device driver
(e) None of these
15. Single party disk relying on the disk controller for finding out which disk has failed is used by-
(a) RAID level 5
(b) RAID level 2
(c) RAID level 4
(d) RAID level 3
(e) RAID level 1
16. Which of these terms refers to the feature of an OS that allows a single computer to process the tasks of several users at different stations, in round-robin fashion?
(a) Multiprocessing
(b) Multiprogramming
(c) Multitasking
(d) Time processing
(e) Time-sharing
17. Which of the following statements is not true about two-tier client-server database architecture?
(a) SQL statements are processed on the server
(b) SQL statements may be processed on some of the clients
(c) Business logic is mostly processed on clients
(d) Business logic may be processed on the server
(e) None of these
18. A Relational operator that yields all values from selected attributes is known as a -
(a) difference
(b) product
(c) select
(d) project
(e) join
19. Normalization is:
(a) the process of creating small stable data structures from complex groups of data when designing a relational database
(b) a methodology for documenting database illustrating the relationship between various entities in the database
(c) an approach to data management that stores both data and the procedures acting on the data as object that can be automatically retrieved and shared
(d) a representation of data as they would appear to an application programmer or user
(e) a representation of data as they actually would be organized on physical storage media
20. The process of building a model that demonstrate the features of a proposed product, service or system is called a -
(a) JAD
(b) RAD
(c) templating
(d) prototyping
(e) TAD
21. Which of the following is mandatory component of a URL?
(a) Resource Path
(b) Protocol
(c) Port Number
(d) Domain Name
(e) None of these
22. DBMS allows you to extrapolate information from your data by using a-
(a) query language
(b) table generator
(c) report generator
(d) wizard
(e) None of these
23. A subschema is -
(a) a description of the physical and logical structure of data and the relationship among the data
(b) a file that identifies the subset of data that a group of users can access
(c) a detailed description of all data contained in the database
(d) a description of the types of modifications that users can make to a database
(e) Either (c) or (d)
24. Which of the following is not a type of hub?
(a) Passive hub
(b) Inactive hub
(c) Switching hub
(d) Intelligent hub
(e) None of these
25. The ……….. lists the location of files on the disk
(a) FAT
(b) boot sector
(c) root folder
(d) data area
(e) None of these
Answers:
1. (b) 2. (a) 3. (a) 4. (a) 5. (b)
6. (b) 7. (e) 8. (a) 9. (a) 10. (a)
11. (d) 12. (b) 13. (b) 14. (d) 15. (d)
16. (e) 17. (c) 18. (d) 19. (a) 20. (d)
21. (e) 22. (a) 23. (e) 24. (b) 25. (a)

1 comment:

CURRENT AFFAIRS PREPARATION PLAN

“Current Affairs” and “General Knowledge” cover many topics like from economy to sports or education to politics, or even technology to automobiles. In every second some issues are happening around the world in these sectors, and to accumulate the excerpt of some highlighted news, and memorize it is a good plan to prepare current affairs and GK.

Some Important Tips to Follow:

Read Newspapers regularly

We all know that “Old is Gold”, same thing applies here too. We need to make a habit of reading newspapers regularly. I’ll suggest you to read more than one newspaper. It will be better if you read one newspaper of your mother language, and other of English. Some useful newspapers are “The Times of India”, “The Hindu”, “The Telegraph” etc. You need to start this habit at least 6 months before the actual exam that will help you to get access to all the important events of that period of time.

You need to keep an eye on what’s happening around you in your country and world as well. Trust me guys, you will surely find it interesting after several days. We all know that staying updated is always a good idea, as it will stand you apart from the rest.

Read Magazines thoroughly

This is another great option to prepare the subject we are talking about. There are many leading magazines that focus on current affairs and General Knowledge. You need to buy it from your local magazine seller, and start reading it thoroughly. These magazines beautifully categorize the articles with its genres to make it interesting to read on. Some of the useful magazines are Pratiyogita Darpan andManorma.

Try to read some business magazines and sports magazines too along with a general magazine. This will increase your chances of cracking the competitive exams with ease. Some useful business magazines areBusiness Today, Business Line etc.

Follow News Channels

You will need to follow news channels at least once a day. Now most of the leading news channels are active for 24*7. You need to pick up a suitable time for yourself to watch any favorite news channel of yours. You can watch ABP News, NDTV, Times Now, ET Now, Zee News etc. Try to go through all the breaking and highlighted news, and make it a habit.

I know that watching news channels for long will bore you, so I’ll suggest you to allocate only 30 minutes for it in a whole day. All the leading ones shows the glimpses of all important events of the day quite frequently, so 30 minutes will be enough for you to boost up your current affairs and GK knowledge.

Maintain a Diary

My teacher used to tell me that whenever you learn something try to write it down in your diary, as it will help you to memorize it in a better manner. He is so right, as this method helped me a lot to score good marks in every exam that I appeared for. As I already mentioned before that a lot of events are occurring in the country and around the world, so it is easily understandable that it is not easy to remember everything. It’s always a superb idea to maintain a diary of current events.

You need to update this diary on a daily basis with all the events that you consider as important ones. This diary will become quite useful for the revision part, as it will provide you information about all the important events at a place. You should keep revising the diary frequently, as it will help you to memorize important names, dates, awards etc.

Channelize your Preparation Accordingly

All the competitive exams are not same, as all of them have different pattern, even when it comes to the same topic as ‘Current Affairs’ or ‘GK’. For example for civil services exam, you need to give importance on events of National value. On the other scenario, in matter of bank job exam, the focus should be on the news on banking sectors, and economic and business news.

Thus I’ll suggest you to prepare as per the exams you are appearing for, as channelizing your preparation according to the pattern of the exam will accelerate your chance of getting selected.

Use Internet Resources

Google, YouTube and Wikipedia are my favorite teachers’; one of my friends told me this once. This is quite true indeed, so you should use all the available online resources to study current affairs and GK for exams. For example this blog is all about “Current Affairs”, so you can check this blog regularly by subscribing to us (check the sidebar for subscription options). You can actively take part some forums that are focusing on current events. The good part is you can follow the websites of all leadingnewspapers online if you don’t have enough time to read newspapers.

Use Social Networking Sites for Good

Believe me or not you can surely use social networking sites to your benefits. Especially to prepare current affairs and General knowledge Facebook, Twitter, LinkedIn and StumbleUpon may help you a lot. You can join some Facebook pages, or follow some twitter accounts that are related to current affairs. You can join our Facebook Page too for this matter, or connect with me at LinkedIn or circle me in Google Plus for all the information on recent happenings to boost up your General Knowledgeability.

Give Priority to your Strength

We usually find difficulties when we try to learn everything at once. In that process basically we study a lot, but remember a little. We need to first select our strength areas for our preparation. Try to givepriority to your strength areas. It may be Sports, economy, Government Affairs or technology. Suppose you are applying for Bank exams, then you should prepare industry related news. Along with that you may pick any 2-3 areas of your strength like sports or technology. You need to prepare these sections to the utmost level. I can assure you that these strategies will help you to score much better in Current Affairs section.

Participate in Online Quizzes

You should participate in some free quizzes that are available online to evaluate yourself. For this matter you can easily access our “Quiz Section”. This will give you proper idea whether you are ready for the big exam day or not. As an added factor it will also provide you confidence i.e. very much essential. You can download Monthly-wise current affairs questions from Here.