Jobs in India
Search Jobs
Search Jobs
Advertisements

Placement Paper Tech Interview 03 September 2012 by Sapient

Details of Placement Paper Tech Interview 03 September 2012 by Sapient conducted by Sapient for job interview.
Advertisements
1.Written Test 100 questions in 1 and half hour
2Technicl written Test
3.Technical Intervew
4.HR interview
1.Sapient Aptitude Test 75 95 minutes
RS Agrarwals book is enough
2.Sapient Technical written Test consists
UNIX,DBMS,Pointers,C,C++,RDBS,OS,Data Structures etc....

Sapient Technical Questions

1What is a null pointer?

There are times when it,s necessary to have a pointer that doesn,t point to anything. The macro NULL, defined in , has a value that,s guaranteed to be different from any valid pointer. NULL is a literal zero, possibly cast to void* or char*. Some people, notably C++ programmers, prefer to use 0 rather than NULL.

You can,t use an integer when a pointer is required. The exception is that a literal zero value can be used as the null pointer. (It doesn,t have to be a literal zero, but that,s the only useful case. Any expression that can be evaluated at compile time, and that is zero, will do. It,s not good enough to have an integer variable that might be zero at runtime.)

2When is a null pointer used?

The null pointer is used in three ways:

1. To stop indirection in a recursive data structure.

2. As an error value.

3. As a sentinel value.

1. Using a Null Pointer to Stop Indirection or Recursion

Recursion is when one thing is defined in terms of itself. A recursive function calls itself. The following factorial function calls itself and therefore is considered recursive:

What is Enterprise Resource Planning (ERP), and what kind of a database is used in an ERP application?

Enterprise Resource Planning (ERP) is an information system used in manufacturing companies and includes sales, inventory, production planning, purchasing and other business functions. An ERP system typically uses a multiuser database.

3. What is a DBMS?

DBMS stands for Database Management System. A DBMS receives requests from applications and translates those requests into actions on a specific database. A DBMS processes SQL statements or uses other functionality to create, process and administer databases.

4. Why is a database considered to be "self-describing"?

In addition to the users, data, a database contains a description of its own structure. This descriptive data is called "metadata."

5. Who is E.F. Codd, and why is he significant in the development of modern database systems?

While working at IBM, E.F. Codd created the relational database model. A paper he published in 1970 presented his ideas to the world at large. His work is the foundation for most of the DBMSs currently in use, and thus forms the basis for database systems as we know and use them today.

6. What is SQL, and why is it important?

SQL stands for Structured Query Language, and is the most important data processing language in use today. It is not a complete programming language like Java or C#, but a data sub language used for creating and processing database data and metadata. All DBMS products today use SQL.

Sapient HR Interview Questions

Tell me about yourself.
Why should I hire you?
What are your strengths and weaknesses?
Why do you want to work at our company?
What are your goals?
What motivates you to do good job?