Interview Questions

Q:

Explain unique Constraint.

Answer

A unique constraint on a column uniquely identifies the record by a combination of one or more fields. Few unique constraint fields can have a NULL value as long as the combination of values is unique.


Example:
create table employee ( id number NOT NULL, dob DATE, professor_id NOT NULL, Name varchar(200) Constraint id_unique UNIQUE(id,dob) );

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2094
Q:

What are the advantages of cloud architecture?

Answer

- Cloud architecture uses simple APIs to provide easily accessible services to the user through the internet medium. 


- It provides scale on demand feature to increase the industrial strength. 


- It provides the transparency between the machines so that users don’t have to worry about their data. Users can just perform the functionality without even knowing the complex logics implemented in cloud architecture.


- It provides highest optimization and utilization in the cloud platform

Report Error

View answer Workspace Report Error Discuss

Subject: Cloud Computing

0 2092
Q:

Explain how garbage collection manages the reclamation of unused memory?

Answer

The garbage collector assumes that all objects in the managed heap are garbage. It starts walking the roots and builds a graph of all objects reachable from the roots recursively. It stops when it attempts to add an object to the graph that it previously added. The graph contains the set of all objects that are reachable from the application's roots. Any object/s that is not in the graph is not accessible by the application, and is considered garbage. Collection only occurs when the heap is full. In such a case, each and every garbage object calls the Finalize method and reclaims the unused memory

Report Error

View answer Workspace Report Error Discuss

Subject: .NET
Job Role: Software Architect

0 2092
Q:

What is anonymous class?

Answer

Anonymous class is class without name.


EX:


class A {


}


class Demo {


    A r = new A() {


        }; //anonymous class


}


 

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2091
Q:

What does success mean to you?

Answer

There are many things you can say. This type of question doesn't have a wrong answer. All answers will be correct. So the best answer is how good you can make the answer. A mediocre answer will be something like completing a project on time. You can say this, but add another twist to make the answer a little better. Here is an example.


 


Short Answers :


"To me, success means to have a goal, plan the steps to achieve the goal, implement the plan, and finally achieve the goal."


"Success means to produce high quality work before the deadline."


"Success to me is knowing that my contributions positively impacted my company."


 


Long Answers :


"Success to me means completing a task and when looking back, thinking I couldn't have done it better. To succeed is to complete a task or assignment on time in an excellent manner. But that's only half of it. The results should be good and the people involved should gain a valuable lesson or experience. For example, if it was a group project, and only two people out of four really did the work, I wouldn't call that success. If everyone participated and worked together providing a valuable deliverable then it's a success. So I think both the result and the process should be great to call something a success."


This answer is showing that you believe in delivering great quality work. Moreover, it is implying how much you value team work. If you value teamwork highly, then it is safe to assume that you would make a great team player.

Report Error

View answer Workspace Report Error Discuss

1 2091
Q:

Explain how to limit the rows that are retrieved by a query.

Answer

The number of rows returned by a select query can be restricted by the LIMIT clause.
Example:
SELECT * from employee
LIMIT 20

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2090
Q:

What are the different types of system calls?

Answer

The main types of system calls are as follows:


Process Control: These types of system calls are used to control the processes. Some examples are end, abort, load, execute, create process, terminate process etc.


File Management: These types of system calls are used to manage files. Some examples are Create file, delete file, open, close, read, write etc.


Device Management: These types of system calls are used to manage devices. Some examples are Request device, release device, read, write, get device attributes etc.


Information Maintenance: These types of system calls are used to set system data and get process information. Some examples are time, OS parameters, id, time used etc.


Communications: These types of system calls are used to establish a connection. Some examples are send message, received messages, terminate etc

Report Error

View answer Workspace Report Error Discuss

0 2088
Q:

In a class if private data member is declared then how to get value of that data member?

Answer

By using method.


The method used to get the data is called getter method.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2088