Interview Questions And Answers
Q: - What is the difference of a LEFT JOIN and an INNER JOIN statement?
A LEFT JOIN will take ALL values from the first declared table and matching values from the second declared table based on the column the join has been declared on. An INNER JOIN will take only matching values from both tables.
Submitted By:-Sahil Email-ID: - sahil.kr17@yahoo.com
Q: - What is Open Client in Sybase?
Open Client is the interface (API) between client systems and Sybase servers. Fundamentally, it comes in two forms:
Runtime
The runtime version is a set of dynamic libraries (dlls on W32 platforms) that allow client applications to connect to Sybase and Microsoft servers, or, in fact, any server that implements the Tabular Data Streams (TDS) protocol. You need some form of Open Client in order to be able to connect to ASE in any way, shape or form. Even if you are running isql on exactly the same machine as ASE itself, communication will still be via Open Client. That is not to say that client to server communication on the same machine will go via the physical network, that decision is left entirely to the protocol implementation on the machine in question.
Development
The development version contains all of the libraries from the runtime version, plus the header files and other files, library files etc, that enable developers to build client apps that are able to connect to Sybase servers.
Submitted By:-Sahil Email-ID: - sahil.kr17@yahoo.com
Q: - Explain the benefits you can get from Mainframe connect?
These are the following benefits you can get from mainframe connect:
- Client applications can be enabled. External software’s can be connected to the mainframe connect for higher performance.
- Mainframe applications connect to external data through LAN.
- New applications can be created which enables you to connect to external data or source of information.
Submitted By:-Sahil Email-ID: -sahil.kr17@yahoo.com
 |
 |