DirectoryInternetBlog Details for "IT Interview Questions"

IT Interview Questions

IT Interview Questions
Collection and sharing of interview questions

Articles

C Interview Questions
2007-10-30 18:45:00
1. What does static variable mean? 2. What is a pointer? 3. What is a structure? 4. What are the differences between structures and arrays? 5. In header files whether functions are declared or defined? 6. What are the differences between malloc() and calloc()? 7. What are macros? What are the advantages and disadvantages? 8. Difference between pass by reference and pass by value? 9. What is static identifier? 10. Where are the auto variables stored? 11. Where does global, static, local, register variables, free memory and C Program instructions get stored? 12. Difference between arrays and linked list? 13. What are enumerations? 14. Describe about storage allocation and scope of global, extern, static, local and register variables? 15. What are register variables? What are the advantage of using register variables? 16. What is the use of typedef? 17. Can we specify variable field width in a scanf() format string? If possible how? 18. Out of fgets() and gets(...
More About: Questions , Interview
Software Job Interview Question
2007-10-26 18:54:00
1. How would you describe yourself?Sample excellent response:My background to date has been centered around preparing myself to become the very best financial consultant I can become. Let me tell you specifically how I've prepared myself. I am an undergraduate student in finance and accounting at _________ University. My past experiences has been in retail and higher education. Both aspects have prepared me well for this career. 2. What specific goals, including those related to your occupation, have you established for your life? Sample excellent response:I want to be working for an excellent company like yours in a job in which I am managing information. I plan to contribute my leadership, interpersonal, and technical skills. My long-range career goal is to be the best information systems technician I can for the company I work for. . 3. How has your college experience prepared you for a business career? Sample excellent response:I have prepared myself to transition into the the...
More About: Software , Question , Interview
SQL Server architecture
2007-10-26 18:52:00
What is a transaction and what are ACID properties?A transaction is a logical unit of work in which, all the steps must be performed or none. ACID stands for Atomicity, Consistency, Isolation, Durability. These are the properties of a transaction. For more information and explanation of these properties, see SQL Serve r books online or any RDBMS fundamentals text book.Explain different isolation levelsAn isolation level determines the degree of isolation of data between concurrent transactions. The default SQL Server isolation level is Read Committed. Here are the other isolation levels (in the ascending order of isolation): Read Uncommitted, Read Committed, Repeatable Read, Serializable. See SQL Server books online for an explanation of the isolation levels. Be sure to read about SET TRANSACTION ISOLATION LEVEL, which lets you customize the isolation level at the connection level.CREATE INDEX myIndex ON myTable(myColumn)What type of Index will get created after executing the above s...
More About: Architecture
Database Design
2007-10-26 18:51:00
What is normalization? Explain different levels of normalization?Check out the article Q100139 from Microsoft knowledge base and of course, there's much more information available in the net. It'll be a good idea to get a hold of any RDBMS fundamentals text book, especially the one by C. J. Date. Most of the times, it will be okay if you can explain till third normal form.What is denormalization and when would you go for it?As the name indicates, denormalization is the reverse process of normalization. It's the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced.How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships.One-to-Many relationships are implemented by splitting the data into two tables with primary key and fore...
More About: Design , Database
Database - SQL Interview Questions
2007-10-26 18:38:00
1. What’s the difference between a primary key and a unique key?Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column, where are unique creates a nonclustered index by default. Another major difference is that, primary key doesn’t allow NULLs, but unique key allows one NULL only.2. Write a SQL Query to find first Week Day of month?SELECT DATENAME(dw, DATEADD(dd, - DATEPART(dd, GETDATE()) + 1, GETDATE())) AS FirstDay3. How to find 6th highest salary from Employee table SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 6 salary FROM employeeORDER BY salary DESC) a ORDER BY salary 4. What is a join and List different types of joins.Joins are used in queries to explain how different tables are related. Joins also let you select data from a table depending upon data from another table. Types of joins: INNER JOINs, OUTER JOINs, CROSS JOINs. OUTER JOINs are further classified as LEFT OUTER ...
More About: Questions , Interview , Database
XML Interview Questions
2007-10-25 19:49:00
1. what is XML?XML stands for Extensible Markup LanguageIt is a meta-markup language (you make up your own tags)XML is not a programming language, it is a data formatXML documents can be parsed.2. What is the difference between XML & HTML?XML describes data, HTML displays data.HTML has predefined tags, in XML we define tagsHTML can be displayed on its own, XML cannot.The combination of XML and HTML is XHTML.3. What is a "well-formed" document?The well formed document must obey the basic XML constraints like :All Documents must have a prolog.Document must have a root tag.All begin-tags must have end-tags. (case sensitive)All attribute values must be quoted.Elements must be properly nested.All entities must be declared.If a document is not a well-formed document it is not a XML document.4. What is DTD?Document Type Definition defines the structure of an XML document. ADTD can be declared inline in your XML document, or as an externalreference.DTD defines :What element (tag) names are ...
More About: Questions , Interview
Java Struts Interview Questions
2007-10-25 19:45:00
What is Struts Validator Framework?Struts Framework provides the functionality to validate the form data. It can be use to validate the data on the users browser as well as on the server side. Struts Framework emits the java scripts and it can be used validate the form data on the client browser. Server side validation of form can be accomplished by sub classing your From Bean with DynaValidatorForm class. Struts Framework provides the functionality to validate the form data. It can be use to validate the data on the users browser as well as on the server side. Struts Framework emits the java scripts and it can be used validate the form data on the client browser. Server side validation of form can be accomplished by sub classing your From Bean with DynaValidatorForm class. Give the Details of XML files used in Validator Framework?The Validator Framework uses two XML configuration files validator-rules.xml and validation.xml. The validator-rules.xml defines the standard validation r...
More About: Questions , Java , Interview
JMS Interview Questions
2007-10-25 19:39:00
What is JMS?JMS is an acronym used for Java Messaging Service. It is Java's answer to creating software using asynchronous messaging. It is one of the official specifications of the J2EE technologies and is a key technology.How JMS is different from RPC?In RPC the method invoker waits for the method to finish execution and return the control back to the invoker. Thus it is completely synchronous in nature. While in JMS the message sender just sends the message to the destination and continues it's own processing. The sender does not wait for the receiver to respond. This is asynchronous behavior.What are the advantages of JMS?JMS is asynchronous in nature. Thus not all the pieces need to be up all the time for the application to function as a whole. Even if the receiver is down the MOM will store the messages on it's behalf and will send them once it comes back up. Thus at least a part of application can still function as there is no blocking.Are you aware of any major JMS produc...
More About: Questions , Interview
EJB And Java Interview Questions
2007-10-25 19:35:00
1. What is Entity Bean and Session Bean ? 2. What are the methods of Entity Bean? 3. How does Stateful Session bean store its state ? 4. Why does Stateless Session bean not store its state even though it has ejbActivate and ejbPassivate ? 5. What are the services provided by the container ? 6. Types of transaction ? 7. What is bean managed transaction ? 8. Why does EJB needs two interface( Home and Remote Interface) ? 9. What are transaction attributes ? 10. What is the difference between Container managed persistent bean and Bean managed persistent entity bean ? 11. What is J2EE ? 12. What is JTS ? 13. How many entity beans used and how many tables can u use in EJB project ? 14. What is scalable,portability in J2EE? 15. What is Connection pooling?Is it advantageous? 16. Method and class used for Connection pooling ? 17. How to deploy in J2EE(i.e Jar,War file) ? 18. How is entity bean created using Container managed entity bean ? 19. Sotware architechture ...
More About: Questions , Java , Interview
J2EE Interview Questions
2007-10-25 19:31:00
What is bean managed transaction ?Why does EJB needs two interface( Home and Remote Interface) ?What are transaction attributes ?What is the difference between Container managed persistent bean and Bean managed persistent entity bean ?What is J2EE ?What is JTS ?How many entity beans used and how many tables can u use in EJB project ?What is scalable,portability in J2EE?What is Connection pooling?Is it advantageous?Method and class used for Connection pooling ?How to deploy in J2EE(i.e Jar,War file) ?How is entity bean created using Container managed entity bean ?Sotware architechture of EJB ?In Entity bean will the create method in EJB home and ejbCreate in Entity bean have the same parameters ?What methods do u use in Servlet – Applet communication ?What are the types of Servlet ?Difference between HttpServlet and Generic Servlets ?Difference between doGet and doPost ?What are the methods in HttpServlet?What are the types of SessionTracking?What is Cookie ? Why is Cookie used ?If...
More About: Questions , Interview
Java Interview Questions
2007-10-25 19:23:00
What if the main method is declared as private?The program compiles properly but at runtime it will give "Main method not public." message.What is meant by pass by reference and pass by value in Java ?Pass by reference means, passing the address itself rather than passing the value. Pass by value means passing a copy of the value.If you’re overriding the method equals() of an object, which other method you might also consider?hashCode()What is Byte Code?OrWhat gives java it’s “write once and run anywhere” nature?All Java programs are compiled into class files that contain bytecodes. These byte codes can be run in any platform and hence java is said to be platform independent.Expain the reason for each keyword of public static void main(String args[])?public- main(..) is the first method called by java environment when a program is executed so it has to accessible from java environment. Hence the access specifier has to be public.static: Java environment should be able to call...
More About: Questions , Interview
Servlet Interview Questions
2007-10-25 19:19:00
What is the servlet?Servlet is a script, which resides and executes on server side, to create dynamic HTML. In servlet programming we will use java language. A servlet can handle multiple requests concurrentlyWhat is the architechture of servlet package?Servlet Interface is the central abstraction. All servlets implements this Servlet Interface either direclty or indirectly ( may implement or extend Servlet Interfaces sub classes or sub interfaces) Servlet |Generic Servlet |HttpServlet ( Class ) -- we will extend this class to handle GET / PUT HTTP requests | MyServletWhat is the difference between HttpServlet and GenericServlet?A GenericServlet has a service() method to handle requests.HttpServlet extends GenericServlet added new methodsdoGet()doPost()doHead()doPut()doOp tions()doDelete()doTrace() methodsBoth these classes are abstract.What's the difference between servlets and applets?Servlets executes on Servers. Applets executes on browser. Unlike applets, however, ...
More About: Questions , Interview
PHP And MySQL Interview Questions
2007-10-21 20:03:00
What are the differences between Get and post methods in form submitting.give the case where we can use get and we can use post methods?A:1 When to use GET or POSTThe HTML 2.0 specification says, in section FormSubmission (and the HTML 4.0 specification repeats this with minorstylistic changes):–>If the processing of a form is idempotent(i.e. it has no lasting observable effect on the state of theworld), then the form method should be GET. Many database searcheshave no visible side-effects and make ideal applications of queryforms.––>If the service associated with the processing of a form has sideeffects (for example, modification of a database or subscription toa service), the method should be POST.How the form data is transmitted?quotation from the HTML 4.0 specification–> If the method is “get” - -, the user agenttakes the value of action, appends a ? to it, then appends the formdata set, encoded using the application/x-www-form-urlencodedcontent type. The user agent...
More About: Questions , Interview , Mysql
Part 1: PHP interview questions
2007-10-17 18:34:00
1. How can we repair a MySQL table? 2. What are the advantages of stored procedures, triggers, indexes? 3. What is maximum size of a database in MySQL? 4. Give the syntax of Grant and Revoke commands? 5. Explain Normalization concept? 6. What is the maximum length of a table name, database name, and fieldname in MySQL? 7. How many ways we can we find the current date using MySQL? 8. What are the advantages and disadvantages of Cascading Style Sheets? 9. What type of inheritance that PHP supports? 10. How can increase the performance of MySQL select query? 11. How many values can the SET function of MySQL take? 12. What are the other commands to know the structure of table using MySQL commands except explain command? 13. How many tables will create when we create table, what are they? 14. What is the purpose of the following files having extensions 1) .frm 2) .myd 3) .myi? What do these files contain? 15. How can we find the number of rows in a table using MySQL...
More About: Questions , Interview , Part
Web designer interview questions
2007-10-13 19:08:00
1. Whats is the difference between cellspacing and cellpadding? 2. If a page has to be loaded over all frames in window, what should be the value of TARGET attributes? 3. Which one of the following settlement is correct? 1. A table cannot contain another table 2. A Form can ve nested inside another form 3. Which element are table cells 4. List out tags that are support exclusively by IE and Netscape. 5. What tags are used to embed one html page inside another html page (without using frames)? 6. In dreamweaver what is used to apply same layout to my pages. 7. Which HTML tag is used to define an internal style sheet? 8. How do you define an inline style?
More About: Questions , Interview , Designer , Web Designer
PHP Interview Questions
2007-10-13 19:01:00
1. What are the differences between Get and post methods in form submitting, give the case where we can use get and we can use post methods? 2. Who is the father of PHP and explain the changes in PHP versions? 3. How can we submit a form without a submit button? 4. In how many ways we can retrieve the date in the result set of mysql using PHP? 5. What is the difference between mysql_fetch_object and mysql_fetch_array? 6. What is the difference between $message and $$message? 7. How can we extract string ‘theWalkin.com ‘ from a string ‘http://www.TheWalkin.com’ using regular expression of PHP? 8. How can we create a database using PHP and mysql? 9. What are the differences between require and include, include_once? 10. Can we use include (”TheWalkin.php”) two times in a PHP page “makeit.PHP”? 11. What are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee...
More About: Questions , Interview
VB 6, COM, DCOM, Microsoft platform interview questions
2007-10-13 19:00:00
1. 3 main differences between flexgrid control and dbgrid control 2. ActiveX and Types of ActiveX Components in VB 3. Advantage of ActiveX Dll over ActiveX Exe 4. Advantages of disconnected recordsets 5. Benefit of wrapping database calls into MTS transactions 6. Benefits of using MTS 7. Can database schema be changed with DAO, RDO or ADO? 8. Can you create a tabletype of recordset in Jet-connected ODBC database engine? 9. Constructors and destructors 10. Controls which do not have events 11. Default property of datacontrol 12. Define the scope of Public, Private, Friend procedures? 13. Describe Database Connection pooling relative to MTS 14. Describe: In of Process vs. Out of Process component. Which is faster? 15. Difference between a function and a subroutine, Dynaset and Snapshot, early and late binding, image and picture controls, linked object and embedded Object,listbox and combo box,Listindex and Tab index,modal and moduless window, Object and Class, q...
More About: Microsoft , Questions , Interview , Platform
VB Interview Questions
2007-10-13 18:58:00
1. How do you register a component? Expected answer: Compiling the component, running REGSVR32 MyDLL.dll 2. Name and explain the different compatibility types when creating a COM component. Expected answer: No Compatibility ? New GUID created, references from other components will not workProject Compatibility ? Default for a new component Binary Compatibility ? GUID does not change, references from other components will work 3. Why iss it important to use source control software for source code? Expected answer: Modification history.Code ownership: Multiple people can not modify the same code at the same time. 4. What two methods are called from the ObjectContext object to inform MTS that the transaction was successful or unsuccessful? Expected answer: SetComplete and SetAbort. 5. What is the tool used to configure the port range and protocols for DCOM communications? Expected answer: DCOMCONFIG.EXE 6. What does Option Explicit refer to? Expected answer: All variables mu...
More About: Questions , Interview
ASP .NET Interview Questions- Part 1
2007-10-13 18:55:00
What are steps in an asp .net page lifecycle?Init() - when the page is instantiatedLoad() - when the page is loaded into server memoryPreRender() - the brief moment before the page is displayed to the user as HTMLUnload() - when page finishes loading.2.What is the main difference between Response.Write() and Response.Output.Write()?With Response.Outout.Write options are available to you to write the formatted out put.3.When implementing classes what are the specifics of an abstract method?An Abstract method does not provide any implementation. The class containing it can not be instantiated it must be inherited. The deriving class must override abstract methods declared in parent class, unless it is an abstract class it self.4.List all Validation Controls available in asp .net?RequiredFieldValidator : Checks if a control has a value.RangeValidator : Checks if the control’s value is within a certain range.RegularExpressionValidator : Checks whether the value of an input control mat...
More About: Questions , Interview , Part
Asp.NET Interview Questions
2007-10-13 18:48:00
What do I need to create and run an ASP.NET application? Windows 2000, Windows Server 2003 or Windows XP. ASP.NET, which can be either the redistributable (included in the .NET SDK) or Visual Studio .NET. Are there any free IDEs for the .NET SDK? Microsoft provides Visual Studio 2005 Express Edition Beta for free. Of particular interest to the ASP.NET developers would be the Visual Web Developer 2005 Express Edition Beta 2 available as a free download. The ASP.NET Web Matrix Project (supported by Microsoft) is a free IDE for developing ASP.NET applications and is available here. There is also a free open-source UNIX version of the Microsoft .NET development platform called Mono available for download ...
More About: Questions , Interview
Core Java Interview Questions
2007-10-09 19:40:00
Question: How could Java classes direct program messages to the system console, but error messages, say to a file? Answer: The class System has a variable out that represents the standard output, and the variable err that represents the standard error device. By default, they both point at the system console. This how the standard output could be re-directed: Stream st = new Stream(new FileOutputStream("output.txt")); System.setErr(st); System.setOut(st); Question: What's the difference between an interface and an abstract class? Answer: An abstract class may contain code in method bodies, which is not allowed in an interface. With abstract classes, you have to inherit your class from it and Java does not allow multiple inheritance. On the other hand, you can implement multiple interfaces in your class. Question: Why would you use a synchronized block vs. synchronized method? Answer: Synchronized blocks place locks for shorter periods than synchronized methods. Question:...
More About: Questions , Interview , Core
Basic programming interview questions
2007-10-02 19:08:00
Question: What is an HTML tag? Answer: An HTML tag is a syntactical construct in the HTML language that abbreviates specific instruction to be executed when the HTML script is loaded into a Web brower. It is like a method in Java, a function in C++, a procedure in Pascal, or a routine in FORTRAN. Question: What is polymorphism? Answer: In object-oriented programming, the term "polymorphism" refers to the ability of objects to take the form objects of difference classes. Question: What is the difference between a component and a container? Answer: A component is an object, like a button or a sroll bar, that has a visual representation in a sreen window. A container is a window-like component that can contain other components. Every component has a unique container that directly contains it. Question: What is the difference between a constructor and a method? Answer:A constructor is a member function of a class tha...
More About: Programming , Questions , Interview , Basic
Programming Puzzles interview problems
2007-10-02 19:06:00
Classic: If a bear walks one mile south, turns left and walks one mile to the east and then turns left again and walks one mile north and arrives at its original position, what is the color of the bear. ANS. The color of the bear is trivial. The possible solutions to it are interesting. In addition to the trivial north pole and circle near north pole solutions, there is an additional circle near south pole solution. Think it out. 1. Given a rectangular (cuboidal for the puritans) cake with a rectangular piece removed (any size or orientation), how would you cut the remainder of the cake into two equal halves with one straight cut of a knife? ANS. Join the centers of the original and the removed rectangle. It works for cuboids too! 2. There are 3 baskets. one of them have apples, one has oranges only and the other has mixture of apples and oranges. The labels on their baskets always lie. (i.e. if the label says oranges,...
More About: Programming , Interview , Problems , Puzzles
General Programming Questions
2007-10-02 19:05:00
John weighs twice as much as Marcia. Marcia’s weight is 60% of Bob’s weight. Dave weighs 50% of Lee’s weighs 190% of John’s wight. Which of these 5 persons wighs the least? A) Bob B) Dave C) John D) Lee E) Marcia? Ans: E A trip takes 6 hours to complete. After traveling 1/4 of an hour, 1 3/8hours, and 2 1/3 hours, howmuch time does need to complete the trip? A) 2 1/12hours B) 2hours, 2 1/2 minutes C) 2 hours,5minutes D) 2 1/8 hours? Ans) B It takes 30 days to fill a laboratory dish with bacteria. If the size of the bacteria doubles each day, how long did it take for the bacteria to fill one half of dish? Ans) D (29 days) A car wash can wash 8 cars in 18 minutes. At this rate, how many cars can the car wash wash in 3 hours? Ans) 80 If the ratio of the areas of 2 squares is 2:1, then what is the ratio of the perimeters of the squares? Ans) sqrt(2):1 There a...
More About: Programming , Questions , General
Puzzles For Call Center Interviews
2007-10-02 18:56:00
A boy multiplied a number with 10 and got 100. If he divided it by 10, what would be the answer? Answer is 1 If a 12 shell cupboard requires 18 ft of wall space then how much wall space would a 30 cup shelf require? Answer is 45 The average salary of three employee is $950 per week. If one employee earns $1150 and other earns $650 rupees, how much will third be earn? Answer is $1050 During a given week a programmer spend 1/4 of his time preparing charts,3/8 of his time for coding,rest of his time for debugging the programs.If he had 48 hrs during the week how many hours did he spend debugging the program. Answer is 18hrs A 16 story building has 12000ft on each floor. Company A rents 7 floors and company B rents 4 floors. What is the number of square feet of unrented floor space? Answer is 60000 sqft A man owns 2/3 of a computer service buroue business and sells 3/4 of his share for $75000.What is the value of the business. Answer is 150,000 A computer printer produces 176400 lines i...
More About: Interviews , Call , Center , Call Center , Puzzles
128461 blogs in the directory.
Statistics resets every week.


Contact | About
© Blog Toplist 2017