YOU WANT A GOOD JOB NOW
Google

Latest Walkin Interviews Experience: 0 - 1 Year BE/ B.Tech/ Diploma Pune

Apollo Technologies Recruits Freshers

Apollo Technologies is an Engineering Design Services providing Company. Apollo was founded in the beginning of year 2001 by a team of qualified & experienced professionals with the objective of providing cost effective & end-to-end solutions to the Technology Driven Business in the field of Engineering. We are the leading Design Vendor for major OEMs in India for the services in the areas of Advanced Design through Manufacturing using CAD/CAM/CAE PDM/PLM platforms, Tool Design, Jigs & Fixtures Design.

 

Job Posted Date: 21/08/2008

Job Title: Jr Design Engineer

Experience: 0 - 1 Year

Qualification: BE/ B.Tech/ Diploma

Location: Pune

Skills: AutoCAD, Pro/E, CATIA

Description: Knowledge of other design software such as UG Nx, Microstations, AutoCAD Mapping would be an added advantage. Freshers with good design concept will be considered.

Send your Resume to: resume@apollo-technologies.in

FAQ Oracle on Linux/Unix questionsDatabase Interview FAQs

  1. How many memory layers are in the shared pool?
  2. How do you find out from the RMAN catalog if a particular archive log has been backed-up?
  3. How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
  4. Define the SGA and how you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
  5. What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
  6. Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
  7. How do you tell what your machine name is and what is its IP address?
  8. How would you go about verifying the network name that the local_listener is currently using?
  9. You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
  10. What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
  11. What is the recommended interval at which to run statspack snapshots, and why?
  12. What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
  13. Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
  14. How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
  15. What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
  16. In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
  17. How would you best determine why your MVIEW couldn't FAST REFRESH?
  18. How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
  19. Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
  20. How would you begin to troubleshoot an ORA-3113 error?
  21. Which dictionary tables and/or views would you look at to diagnose a locking issue?
  22. An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
  23. How would you extract DDL of a table without using a GUI tool?
  24. You're getting high "busy buffer waits" - how can you find what's causing it?
  25. What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
  26. Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
  27. Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
  28. Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
  29. How do you increase the OS limitation for open files (LINUX and/or Solaris)?
  30. Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
  31. Explain how you would restore a database using RMAN to Point in Time?
  32. How does Oracle guarantee data integrity of data changes?
  33. Which environment variables are absolutely critical in order to run the OUI?
  34. What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
  35. Why does Oracle not permit the use of PCTUSED with indexes?
  36. What would you use to improve performance on an insert statement that places millions of rows into that table?
  37. What would you do with an "in-doubt" distributed transaction?
  38. What are the commands you'd issue to show the explain plan for "select * from dual"?
  39. In what script is "snap$" created? In what script is the "scott/tiger" schema created?
  40. If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
  41. How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
  42. You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
  43. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
  44. Explain the concept of the DUAL table.
  45. What are the ways tablespaces can be managed and how do they differ?
  46. From the database level, how can you tell under which time zone a database is operating?
  47. What's the benefit of "dbms_stats" over "analyze"?
  48. Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
  49. You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
  50. How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

FAQ TOP 10 questions on MySQL speed-up and optimizations

Jay Pipes, author of Pro MySQL, on his blog posts 10 questions and answers dealing with MySQL speed optimizations.

  1. Which will be faster out of these two queries - one with OR or one with IN?
  2. Where does MyISAM cache table records?
  3. Which will be faster out of queries with explicit INNER JOIN and implicit one?
  4. Is InnoDB faster/better than MyISAM?
  5. Is CHAR faster than VARCHAR?
  6. Is VARCHAR(80) faster than VARCHAR(255)?
  7. Are there performance issues when joining tables from different storage engines?
  8. If I change a derived table to a view, will performance increase?
  9. If I see Using temporary; Using filesort" in the Extra column of EXPLAIN output, does that mean a temporary table is created on disk?
  10. Is it possible to do a FULL OUTER JOIN in MySQL?

FAQ C C++ Java interview questions

Describe what happens when an object is created in Java?

Several things happen in a particular order to ensure the object is constructed properly:
1. Memory is allocated from heap to hold all instance variables and implementation-specific data of the object and its superclasses. Implementation-specific data includes pointers to class and method data.
2. The instance variables of the objects are initialized to their default values.
3. The constructor for the most derived class is invoked. The first thing a constructor does is call the constructor for its uppercase. This process continues until the constructor for java.lang.Object is called, as java.lang.Object is the base class for all objects in java.
4. Before the body of the constructor is executed, all instance variable initializers and initialization blocks are executed. Then the body of the constructor is executed. Thus, the constructor for the base class completes first and constructor for the most derived class completes last.

In Java, you can create a String object as below : String str = "abc"; & String str = new String("abc");  Why cant a button object be created as : Button bt = "abc"? Why is it compulsory to create a button object as: Button bt = new Button("abc"); Why this is not compulsory in String's case?

Button bt1= "abc"; It is because "abc" is a literal string (something slightly different than a String object, by-the-way) and bt1 is a Button object. That simple. The only object in Java that can be assigned a literal String is java.lang.String. Important to not that you are NOT calling a java.lang.String constuctor when you type String s = "abc"; For example String x = "abc"; String y = "abc"; refer to the same object. While String x1 = new String("abc");
String x2 = new String("abc"); refer to two different objects.

What is the advantage of OOP?

You will get varying answers to this question depending on whom you ask. Major advantages of OOP are:
1. Simplicity: software objects model real world objects, so the complexity is reduced and the program structure is very clear;
2. Modularity: each object forms a separate entity whose internal workings are decoupled from other parts of the system;
3. Modifiability: it is easy to make minor changes in the data representation or the procedures in an OO program. Changes inside a class do not affect any other part of a program, since the only public interface that the external world has to a class is through the use of methods;
4. Extensibility: adding new features or responding to changing operating environments can be solved by introducing a few new objects and modifying some existing ones;
5. Maintainability: objects can be maintained separately, making locating and fixing problems easier;
6. Re-usability: objects can be reused in different programs

Latest FAQ ASP.NET interview questions

  1. Describe the difference between a Thread and a Process?
  2. What is a Windows Service and how does its lifecycle differ from a "standard" EXE?
  3. What is the maximum amount of memory any single process on Windows can address? Is this different than the maximum virtual memory for the system? How would this affect a system design?
  4. What is the difference between an EXE and a DLL?
  5. What is strong-typing versus weak-typing? Which is preferred? Why?
  6. What's wrong with a line like this? DateTime.Parse(myString
  7. What are PDBs? Where must they be located for debugging to work?
  8. What is cyclomatic complexity and why is it important?
  9. Write a standard lock() plus double check to create a critical section around a variable access.
  10. What is FullTrust? Do GAC'ed assemblies have FullTrust?
  11. What benefit does your code receive if you decorate it with attributes demanding specific Security permissions?
  12. What does this do? gacutil /l | find /i "about"
  13. What does this do? sn -t foo.dll
  14. What ports must be open for DCOM over a firewall? What is the purpose of Port 135?
  15. Contrast OOP and SOA. What are tenets of each
  16. How does the XmlSerializer work? What ACL permissions does a process using it require?
  17. Why is catch(Exception) almost always a bad idea?
  18. What is the difference between Debug.Write and Trace.Write? When should each be used?
  19. What is the difference between a Debug and Release build? Is there a significant speed difference? Why or why not?
  20. Does JITting occur per-assembly or per-method? How does this affect the working set?
  21. Contrast the use of an abstract base class against an interface?
  22. What is the difference between a.Equals(b) and a == b?
  23. In the context of a comparison, what is object identity versus object equivalence?
  24. How would one do a deep copy in .NET?
  25. Explain current thinking around IClonable.
  26. What is boxing?
  27. Is string a value type or a reference type?

Placement Paperon 15th march 2008

Hello frends... this is Sonali Jindal
Written test was held on 15th march 2008
Recruitment process-->
1)Written test
2)Group discussion
3)HR interview
4)Technical inteview
1) Written test
English (easy). this section includes prepositions, synonyms, etc. u need not prepare anythin 4 this section. it's just, whtever english u hav learnt in ur life. Then comes the passage reading part. u wil b given 2 comprehension passages(easy). on the basis of these passages u hav 2 answer the questions. its very TIME CONSUMING. my suggestion wud b read them in the end.
Analytical ability . u must prepare wel 4 this sections. go for Quantitave RS Aggarwal(best buk). don leav chapters like average, time and work, percentage, profit loss, etc. my suggestion wud b 2 study almost all the chapters there in the buk.
Attention to detail(very easy). no need 2 prepare anythin. just needs concentration. u wil b given 3 options wich r very similar 2 each other. u hav 2 find whether they all r exactly same or 2 of them r same or none. 4 example- JJJJEEESCHG JJJJEESCHG JJJJEEESCHG
Then also there r some questions like 0 means * and 1 means $... Thus u hav 2 calculate ($*$)x$**.... (Dont remember exactly). these questions r easy but again TIME CONSUMING. so do them in the end. also questions like if * stands for +, / stands for *, + stands for - and - stands for / then calculate 20/2*2+20-5.
Essay. In 10min u hav 2 write an essay(around 100words). i don think essays r chekd, rest don know. essay topic was "Education system in india".
All in all written test is easy.. but u really need 2 take care of TIME. In the last 5min... i was stil left wit 2 passages and + stands for - type questions. i was so tensed. then first i started reading the questions in the passage an then lookin 4 answers in the passage. i managed 2 do 3-4 questions. then 2min were left,an no time 2 solve questions or read another passgae so i just ticked the left over options. so i blindly attempted 12-15 questions(no negative marking). wen i came out of the room, i was sad that i cudnt read passages neither i cud solve some questions. but i think i did rite by leavin passages 4 the end. bcoz i cud attempt quantitave part. wich other students cudnt. Out of around 5000 students, 600 students cud clear the written test.
2) Group discussion(held on 12 april)
This is an elimination round. many people say it's the most difficult round, but it is not. All u need 2 do is be LOUD and clear. the moderator shud hear ur voice. there were 15 students in 1 grup. an the modertaor askd us 2 choose a topic. but he gav his own topic. my topic was "Role of media". amongst the 15students only 2(includin me) were against the role of media. i said that media is very important so as 2 make people aware abt whts happenin around u, but 2day media is not playin its role properly as it is entering into people's personal lives(kareena an shahid case)....bla bla....
To be different in crowd sometimes u hav 2 be against all the students, aftr all u hav 2 come in limelight. also this helps in carryin on the GD, bcoz if every1 wud hav the same thots then... GD wont continue as no one is against anyone. i read somewhere tht u shud try 2 initiate the gd. i did not initiate, but i was the 2nd person 2 speak. and if u want 2 initiate the GD, make a STRONG point. by just starting u wont get thru. in my grup the person who initiated dint get thru, coz he dint hav strong point an also he dint say a single word aftrwards. try 2 speak in the beginning coz later u mite not get chance 2 speak as it becomes a fish market. its a gud point if u try 2 calm every1. In GD only speakin is not important, u must listen also. there was one student who spoke a alot but dint let others speak. so he was not selectd. also don't point finger or aggressive, u wont get selectd. wenevr u want 2 speak, raise ur hand.. this shows courtsy.
other GD topics were Cinema, Black, Tea or coffee, Reservation.
Around 300 students were elimintaed.
3) HR interview
one can hav HR interview 1st or Tech interview 1st. in my case HR first. my interview went GREAT!! this round is very easy 2 get thru. u need 2 qualitites..GOOD COMMUNICATION SKILLS and CONFIDENCE. don think u cannot get rejectd in this round. if u don hav either of these 2 qualities.. u r out.
4) Tech Interview
pheeewww...!!! last round. being a computer science student u must knw C++ and DBMS. if he asks abt ur project and u don knw much abt it then speak abt ur project continuously so tht u don stop, in fact he asks u 2 stop. make him sure that u knw everythin abt ur project, so tht he doesnt asks u any further questions on project. he mite ask u ur favourite subject. Prepare ur subject wel.
he askd me:- wich languages u knw?
me:- C++ but i hav interst in DBMS also (as i dint want him 2 ask me on c++)
He:- wich database u hav been workin on?
Me:- sql server 2005
He:- wht do u do on tht?
Me:- fire simple queries.. learnin in colg thz days.. i knw basics (i wantd him 2 ask me basics an not RDBMS--cursors, triggers, etc)
He:- askd me 2 rite select command syntax, all operators, some functions, an gave me one query in wich i had 2 tel whether it was correct or not.
Me:- i gav all answers, but got stuck a lil in the last question in wich i had 2 tel it's corrct or not.
He:- Ok. any queries regardin accenture??
Me:- i askd 2-3 questions, wich intimated me tht perhaps i m in..
So finally i made it. i was so happy.. so relieved. 100 students(round of) finally cleard. i had sat in Wipro, but cudnt clear tech round. an now this company was my next target. Just take care tht if u clear written.. don let the company go off ur hands. coz 2 clear written amongst 1000s is very difficult. an also DON loose hope. If not this company then may b next. "somethin better is waitin 4 u.." and yes LUCK matters alotttttt. u mite come across some strict interviewer, or u mite not hav come in the site of moderator durin GD. LUCK PLAYS A BIG ROLE.
anyways gudluk..!!!! never loose hope :)