Technology Questions

Q:

How can you find a PL/SQL block, if the cursor is open?

Answer

By use of %ISOPEN status variable.


 

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 3272
Q:

What is anonymous FTP and why would you use it

Answer

Anonymous FTP enables users to connect to a host without using a valid login and password. Usually, anonymous FTP uses a login called anonymous or guest, with the password usually requesting the user's ID for tracking purposes only. Anonymous FTP is used to enable a large number of users to access files on the host without having to go to the trouble of setting up logins for them all. Anonymous FTP systems usually have strict controls over the areas an anonymous user can access

Report Error

View answer Workspace Report Error Discuss

1 3272
Q:

What is the fastest type of JDBC driver ?

Answer

Type 4  (JDBC Net pure Java Driver) is the fastest JDBC driver.  Type 1 and Type 3 drivers will be slower than Type 2 drivers (the database calls are make at least three translations versus two), and Type 4 drivers are the fastest (only one translation).

Report Error

View answer Workspace Report Error Discuss

Subject: Java

1 3270
Q:

What does a special set of tags do in PHP?

Answer The output is displayed directly to the browser.
Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 3265
Q:

What is the difference between int and int32 ?

Answer

There is no difference between int and int32. System. Int is an alias name for System.Int32 which is a .Net Class.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET
Job Role: Analyst , IT Trainer

1 3260
Q:

What is Uniform Data Access Integration?

Answer

- UDAI places the data in the source systems.


- A set of views are defined for providing access the unified view to the clients / customers.


- Zero latency of data can be propagated from the source system.


- The generated consolidated data need not require separate storage space.


- Data history and version management is limited and applied only to the similar type of data.


- Accessing to the user data overloads on the source systems.

Report Error

View answer Workspace Report Error Discuss

0 3251
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 3250
Q:

What is the maximum data rate supported by a GSM system?

Answer

- The maximum data rate supported by a GSM system is 9.6 kbps.
- However there are extensions to GSM standard to improve throughput.
- GPRS is one of the extended GSM service.
- The extended standards of GSM allows theoretical data rates on the order of 114 Kbit/s, but with throughput closer to 40Kbit/s in practice.

Report Error

View answer Workspace Report Error Discuss

3 3246