Technology Questions

Q:

Explain i) Rename ii) Alias.

Answer

- Rename : It is a permanent name provided to a table or column.
- Alias : It is a temporary name provided to a table or column which gets over after the execution of SQL statement.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 3178
Q:

Name and explain the type of locks?

Answer

There are three types of lock, namely:


Shared – This type of lock permits two or more programs to read from the locked space but does not allow them to change it.


Update – This lock is more lenient. It permits the program to read and change the locked space.


Exclusive – This lock restricts all users from accessing the locked space.

Report Error

View answer Workspace Report Error Discuss

0 3174
Q:

What is an OLTP system and OLAP system?

Answer

OLTP stands for OnLine Transaction Processing. Applications that supports and manges transactions which involve high volumes of data are supported by OLTP system. OLTP is based on client-server architecture and supports transactions across networks.


OLAP stands for OnLine Analytical Processing. Business data analysis and complex calculations on low volumes of data are performed by OLAP. An insight of data coming from various resources can be gained by a user with the support of OLAP.

Report Error

View answer Workspace Report Error Discuss

0 3170
Q:

What is WHEN-Database-record trigger?

Answer

Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update. Generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item.

Report Error

View answer Workspace Report Error Discuss

6 3170
Q:

For printing out strings, there are echo, print and printf. Explain the differences.

Answer - echo is the most primitive of them, and just outputs the contents following the construct to the screen. print is also a construct (so parentheses are optional when calling it), but it returns TRUE on successful output and FALSE if it was unable to print out the string. However, you can pass multiple parameters to echo, like:

and it will output the string "Welcome to TechInterviews!" print does not take multiple parameters. It is also generally argued that echo is faster, but usually the speed advantage is negligible, and might not be there for future versions of PHP. printf is a function, not a construct, and allows such advantages as formatted output, but it’s the slowest way to print out data out of echo, print and printf.
Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 3168
Q:

What is the diff between RDO and ADO?

Answer

RDO is Hierarchy model where as ADO is Object model. ADO can access data from both flat files as well as the data bases. I.e., It is encapsulation of DAO, RDO , OLE that is why we call it as OLE-DB Technology. 

Report Error

View answer Workspace Report Error Discuss

14 3168
Q:

What is the use of eucalyptus in cloud computing environment?

Answer

Eucalyptus stands for “Elastic Utility Computing Architecture for Linking Your Programs to Useful Systems” and provides an open source software infrastructure to implement clusters in cloud computing platform. It is used to build private, public and hybrid clouds. It can also produce your own datacenter into a private cloud and allow you to extend the functionality to many other organizations. Eucalyptus provides APIs to be used with the web services to cope up with the demand of resources used in the private clouds.

Report Error

View answer Workspace Report Error Discuss

Subject: Cloud Computing

1 3162
Q:

What is Language Integrated Query (LINQ)?

Answer

LINQ is a programming model that is the composition of general-purpose standard query operators that allow you to work with data, regardless of the data source in any .NET based programming language. It is the name given to a set of technologies based on the integration of query capabilities into any .NET language.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 3161