Infosys Rdbms Training Material

Posted on by

This article provides an insight of “how to prepare for infosys” from beginning to end.

Question Paper Structure

  • Online Test.( Duration – 95 Minutes.)
  • Three Sections.
  • Sectional Cut-off applied, No Negative marking.
  • Sections are to be completed one by one, can’t switch in between.
  • Auto saved once stipulated time is up for each section.
  • Can be switched into next section before stipulated time if the section is completed.
  • Attempt all Questions,Choose same answer option for unsolved/unknown questions.

Sections

Infosys Training Material. Infosys Training Material. Placement Papers; Anvesh Immalaraju April 23, 2011 April 23, 2011 1 download, infosys, infy, material, training. Infosys Campus Connect Material. ##### Training Module: Infosys Campus Connect Instructor: K h. J i n n a t u l I. RDBMS Day1 ii) RDBMS Day 2 iii) RDBMS Day 3 iv) RDBMS Day 4 v)RDBMS Day 5 vi) RDBMS Day 6 vii ) RDBMS Day 7.

  • Section – 1 (Quantitative Ability) – Mathematical Critical Thinking, 10 Questions 35 Minutes
  • Section – II (Analytical Ability) – Reasoning, 15 Questions 25 Minutes
  • Section – III (Verbal Ability) – English Communication, 40 Questions 35 Minutes

A few months back you got a news in the media that Infosys has changed its Course, study material and even whole structure of Training. Earlier in Mysore training, Infosys used to teach Java in their training but now they are focusing on Python instead of Java. Python is more easy and interesting than Java and even Python is more. Basic SQL Training: 20 hours. All the training will be provided using AdventureWorks database. Class 1: 4 hours. Introduction to RDBMS (Relational Database Management Systems), 2. Concept of an Instance vs a Database in different RDBMS, 3. Concept of a login and a user and a schema, 4. Concept of a session, 5. Concept of a client and a. 08:53 Interview, Quiz, RDBMS, Wipro Training Notes No comments 1. Provide table security by restricting access to a predetermined set of rows or columns of a table.

Section – I (Quantitative Ability)To test Problem Solving and Analytical skills.

  • Time consuming, higher difficulty questions.Focus is more on Numbers and Advance concepts like Permutation and Combination, Probability.
  • Few questions from topics like Time and Work, Time Speed and Distance.
  • One or two Crypt arithmetic Questions.
  • Other less important topics are: Mensuration, Ration & Proportion, Percentage, Profit & Loss, Cube & Cuboid, Analytical Puzzles (like seating arrangement).

Section – I: Strategy


  • 50 % of questions need in depth understanding of the concept and hence difficult.Remaining 50% questions can be solved with sufficient practice.
  • Choose less time consuming 6 Questions and attempt with-in the first 15 minutes.Out of 6, 3 to 4 are very easy which can be solved in less than 5 Minutes.
  • Remaining 4 Questions can be solved in excess 20 Minutes.Expected Cut-off is 6 – 7 correct answers.
  • Key is to identify the 6 less time consuming questions.

Section – II (Analytical Ability)

  • Key areas are:
    • Data Interpretation (Bar Graph,Table Chart, etc.)
    • Data Sufficiency,
    • Syllogism/ Logically Following Questions.
  • Other areas are:
    • Data Arrangement.
    • Visual Reasoning
    • Puzzles.

Section – II: Strategy

  • Attempt Individual questions first, like questions from Syllogism, Data Sufficiency,Visual Reasoning and Puzzles.These questions doesn’t have common data to be solved and each question might take a maximum of 2 minutes to solve and a majority can be solved in less than a minute.
  • 9 such questions can be with-in first 15 Minutes.
  • Then attempt Data Interpretation, leave Data Arrangement to solve at last.
  • Expected Cut-off is 10 – 11 correct answers.

Section – III (Verbal Ability)

  • Consists of two Reading Comprehension Questions (2*5 = 10 sub questions).The remaining 30 questions are from the following topics.
  • Sentence Correction/Sentence Improvement/Spot the Error (Approx 10 questions).
  • Sentence Completion Filler (underlined a part of sentence and asked to insert correct phrase in it from given 4 options) (Approx 7 questions).
  • Critical Reasoning/Theme Detection (Approx 6 questions).
  • Fill in the blanks covering Grammar, One word substitute, Preposition, Idioms/Phrases etc (Approx 7 questions).

Section – III: Strategy

  • Attempt Sentence Correction or Error Spotting and Vocabulary first.Next go for Reading Comprehension.
  • If you get a short passage better attempt it at the end because the questions will be tougher
  • Attempt lengthy passage first.
  • Don’t try to read and understand the passage completely.
  • You can comfortably attempt only the direct questions with-in 5 minutes and take a chance in the other type of questions since there is no negative marks.
  • Last type of question is Critical Reasoning and try to attempt such 5 to 6 questions with-in 10 Minutes.
  • Expected Cut-off is 20 correct answers.

Sectional Cut-off Marks

Infosys Training Center

  • Infosys maintains a standard 65% cut-off marks on each test during any training.
  • Same can be expected on Section – I & Section – II.
  • Actual cut-off is depends on the institute, which is determined by the Infosys itself.

Gradation of Institute

Infosys
  • Record of Previous selected candidates.
  • Performance of the alumni of the institute at Infosys – major factor.
  • Percentage of students leave Infosys after completion of training.
  • Percentage of students leave Infosys after completion of 1 year of service

Cut-off Secrets

  • Cut off is actually determined on the spot based on the gradation of the institute and performance of examinees.
  • Cut – off may vary from 50% to 70% on Section – I & II

It is almost 90% you completed for getting selected at Infosys if you clear the first round (Online Aptitude Test) of Infosys.

This article is contributed by Sanket Basu Roy. If you like GeeksforGeeks and would like to contribute, you can also write an article and mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above

Infosys training program

Recommended Posts:

Infosys
  • Hands On test will be held after 10 days from your Joining and Objective Test after 11 days from your joining.
  • Objective Test is of 100 marks( 33marks Programming, 33 marks RDBMS and 34 marks comprising of SE, IWT and OS of 1mark each question)
  • Hands On will comprise of 50 marks (25marks Java and 25marks RDBMS)
  • In this period, all will be provided with study materials for preparations and machines for practice.
  • If one scores more than 65% marks in both Hands On and Objective Test, he or she will be deployed to Stream Training.
  • Stream training will be of around 42 working days.
  • If one fails to score 65% marks then he or she will be deployed to Intermediate Training.
  • Intermediate Training will be of around 25 working days.
  • Intermediate Training comprises of regular classes.
  • Then after 25 days, you will sit for the Assessment Test again. If you pass then you will deployed into Stream Training.
  • If you again fail, you will be deployed into Augmented Training.
  • Augmented Training will be of around 10 days.
  • Then again you have to sit for the Assessment Test.
  • If you pass this, then you will deployed into Stream Training.
  • Else, Bye bye Infosys. (It rarely happens). So no worries.
  • Please note: In Augmented Training, there will be no classes. Only study materials will be provided, one needs to study by his or her own.

N.B.: In both Intermediate and Augmented Training, you have to cover all the 5 modules that you have learned in Online Training.
P.S.: Those who are going through Online Training now, I advice you to take it seriously.
OBJECTIVE TESTS :
-----------------


For objective part, we were given 2 hours or 2.30 hours[exactly I don’t remember], whatever time span might be, it was enough to complete the objective and that too we completed it comfortably, so don’t worry about that. Objective part comprised of questions, based on 5 subjects –Java, RDBMS, OS, IWT and Software Engineering. However one should keep in mind that for every wrong answer there is a negative marking of 0.25 too. The standard of objective questions was the same like your “Post Test”. (Apart from that, a sample question paper will also be uploaded after the completion of your course in that portal, so that one can refer it later).
Java: - Questions related to java were very simple, based on basics/fundamentals [very important, get your fundamentals clear]. Most of the questions were output related. Very few questions were theoretical.
RDBMS: - Questions asked in RDBMS section were of average standard. Most of the questions were based on queries. Some of the questions were based on output covering both queries and PL/SQL. It is highly essential that you should have clear knowledge about queries and proper syntax of pl/sql statements else you may get confuse .
OS: - Questions in this section were very easy. Some questions were direct and theoretical while others were numerical; yes you need to do some calculations. One should have clear knowledge about all concepts mentioned in the study material. Please don’t ignore any numerical, there is a high probability that you may face more numerical than simple and direct theoretical questions. Please solve ample problems related to process scheduling and page replacement algorithms as it is a very important section of OS, you may get maximum questions from that.
IWT: - You will get simple and direct questions. There are few sections which you should take care of like network topologies, architecture, protocols, and load balancing. You should not face any problem in this section.
S.E-In this section you will get simple and direct questions. Please read thoroughly “software development life cycle”, various life cycles, quality.These are important topics of SE.
Now let’s move onto practical section:
First of all, we had to configure our systems as all systems are connected to LAN and we had to operate on servers. [Don’t worry, they will be instructing and guiding you throughout the process.]
Please note that, one has to code java programs using ECLIPSE and for RDBMS we have to use Oracle ( SQL plus). If one doesn’t have any idea about these, then please download and start using them as no other alternative will be given.
HANDS-ON/Practical ----------------------


It is quite interesting to know that this part is an open book meaning you will be provided with reference materials for in case u forgot syntax or faced any problem, you can refer it anytime. Time limit for “hands on” is 2 hours.
Java:- Again, question was very simple[Like we were given an interface and had to implement that interface in a class]. I would suggest you all, please read the question at least 2 times in order to understand the need of question because question will be very long and you may not get it in one go. All requirements will be given in the question itself, you just need to follow and code it. A class diagram would also be given stating what and how to implement. Believe me, it’s like skeleton is already being provided to you, you just need to give flesh (logic) in order to bring it in a proper shape. A simple tip I would like to give that try to break the question in to small parts/steps and code it in a sequence as per mentioned in the question satisfying the requirements. I think, you will find it easier this way.
In order to test your code whether it is OK or not, you will need a demo class or a class containing main method with/without values. This class will be given to you beforehand along with “files supplied”. One should be conscious about time factor as java programs will consume maximum of your time, so one should manage time efficiently. You need to submit error free and compiled code, it is a must. Please try to implement simple logic as far as possible; else you will get confuse by yourself only.
RDBMS: - Question related to RDBMS had 2 parts…
First part had 3 queries based questions. You have to make queries on table which may be pre-given (previously present on server) or you may have to create it by yourself as specified in the question. As in my case code to create the table was already been given in the question paper along with the data, we just had to “copy-paste” it (not a big deal).These query based question may be simple and direct/complex and tricky. So pay undivided attention to that while solving. If all goes well, it will take hardly 10 minutes to execute all three questions.
Then comes second part in which you have to code a pl/sql program. Like java, all requirements will be specified in question paper; you just need to code it. Be assured that pl/sql program will be easier as compared to sql or queries related questions.
After completing everything you will be asked to submit your java source code files and RDBMS source files .For RDBMS, you have to first write and execute commands, if it works fine then you just needs to copy and paste it in a text file, at the end you have to submit it.
Please keep it mind that you need to follow /adhere to all business conventions way of coding.
Few suggestions:
1) Please maintain a note while watching videos or studying material, it will help you in quick revision.
2) Please solve assignments of Java and RDBMS; it will help you a lot.
3) Please while watching videos pay your full attentions, as narrator may tell some points orally and you may miss it.
4) Please go through videos as well as study materials because some topics which are in videos are not covered in PDF and vice versa.

Sources - Infosys (freshers of 2012 batch)- Bhanu Pratap

Infosys Training Program