C - Interview Questions and Answers for 'Informatica' | Search Interview Question

C - Interview Questions and Answers for 'Informatica' - 10 question(s) found - Order By Newest

Frequently asked to fresh graduates.

Q1. What is ACID ?

Ans. ACID stands for Atomicity, Consistency, Isolation, Durability is a set of properties of database transactions.

Atomicity means all or nothing. i.e parts of a transaction shouldn't commit if any one of them fails. Either the whole transaction should succeed or it should be complete rollback.

Consistency means that any transaction should lead database from one stabe state to another.

Isolation means that the execution of transaction results in a system state that would be obtained if transactions were executed serially.

Durability means that when a transaction is committed it forms the permanent state of database.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database acid Asked in 7 Companies Intermediate}

Try 1 Question(s) Test

Frequently asked question for intermediate developers. Frequently asked in HCL Technologies and EPAM.

Q2. What is Volatile keyword used for ?

Core Java

Ans. Volatile is a declaration that a variable can be accessed by multiple threads and hence shouldnt be cached.

Sample Code for volatile

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java oops synchronization volatile java keywords Asked in 42 Companies intermediate frequent}

Try 1 Question(s) Test

Q3. What is PermGen or Permanent Generation ?

Core Java

Ans. The memory pool containing all the reflective data of the java virtual machine itself, such as class and method objects. With Java VMs that use class data sharing, this generation is divided into read-only and read-write areas. The Permanent generation contains metadata required by the JVM to describe the classes and methods used in the application. The permanent generation is populated by the JVM at runtime based on classes in use by the application. In addition, Java SE library classes and methods may be stored here.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java jvm memory management permgen permanent generation advanced architecture Asked in 9 Companies expert}

Q4. What is a Database Procedure ?

Database

Ans. Stored procedures are a batch of SQL statements along with programming constructs ( if else, loops etc ) and stored as a single program that can be called by different clients and hence reused.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database stored procedure Asked in 2 Companies basic frequent}

Q5. Describe SQL Joins

Database

Ans. Oracle having following types of joins these are also called 8i joins. There are:

1. Equi (or) Inner join
2. Non Equi join
3.Self join
4.Outer join

Oracle also support the 9i (or) ANSI standard joins.There are:

1.Inner join
2.Left outer join
3.Right outer join
4.Full outer join
5.Natural join

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql joins sql Asked in 2 Companies}

Q6. Differentiate osi and tcp/ip models and describe them

Networking

^{This question was recently asked at 'Informatica'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Asked in 1 Companies}

Q7. what are system calls

Operating System

^{This question was recently asked at 'Informatica'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Asked in 1 Companies}

Q8. What is size of structure in c ?

C++

^{This question was recently asked at 'Informatica'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Asked in 1 Companies}

Q9. What are reference variables in c

C++

^{This question was recently asked at 'Informatica'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Asked in 1 Companies}

Q10. Explain memory allocation and deallocation.

C++

^{This question was recently asked at 'Informatica'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Asked in 1 Companies}

Search Interview Questions

Help us and Others Improve. Please let us know the questions asked in any of your previous interview.