Sawaal
  • Home/
  • Searching for By

 Searching for "By"

Q:

What do you mean by stack unwinding?

Answer

Stack unwinding is a process of calling all destructors for all automatic objects constructed at run time when an exception is thrown. Destructors are called between the places where the exception was thrown and where it is caught.

Report Error

View answer Workspace Report Error Discuss

Subject: C++

Q:

What are transaction isolation levels supported by Oracle?

Answer

Oracle supports 3 transaction isolation levels: 


- Read committed (default)


- Serializable transactions


- Read only

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

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

Q:

What do you mean by Redo Log file mirroring ?

Answer

-  The process of having a copy of redo log files is called mirroring.
-  It is done by creating group of log files together. This ensures that LGWR automatically writes them to all the members of the current on-line redo log group.
-  In case a group fails, the database automatically switches over to the next group. It diminishes the performance.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

What do you mean by a deadlock?

Answer

 - When two processes are waiting to update the rows of a table which are locked by another process, the situation is called a deadlock.
 - The reasons for it to happen are:
 * lack of proper row lock commands.
 * Poor design of front-end application
- It reduces the performance of the server severely.
- These locks get automatically released automatically when a commit/rollback operation is performed or any process is killed externally.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

What do you mean by a tablespace?

Answer

- These are the Logical Storage Units into which a database is divided.
- It is used to group together the related logical structures.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

What do you understand by MapReduce?

Answer

MapReduce is a software framework that was created by Google. It`s prime focus was to aid in distributed computing, specifically large sets of data on a group of many computers. The frameworks took its inspiration from the map and reduce functions from functional programming.

Report Error

View answer Workspace Report Error Discuss

Subject: Cloud Computing

Q:

How does cloud architecture overcome the difficulties faced by traditional architecture?

Answer

Cloud architecture provide large pool of dynamic resources that can be accessed any time whenever there is a requirement, which is not being given by the traditional architecture. In traditional architecture it is not possible to dynamically associate a machine with the rising demand of infrastructure and the services. Cloud architecture provides scalable properties to meet the high demand of infrastructure and provide on-demand access to the user.

Report Error

View answer Workspace Report Error Discuss

Subject: Cloud Computing