Technology Questions

Q:

How will you find the 3rd max salary in the employment table?

Answer

SELECT DISTINCT(salary) FROM emp as e1 


WHERE (3) = (SELECT COUNT(DISTINCT(salary)) FROM emp as e2  WHERE e1.salary <= e2.salary)

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 2687
Q:

How can we call DDL statements like CREATE, DROP, TRUNCATE, etc. from PL/SQL?

Answer

EXECUTE IMMEDIATE command can be used to call DDL statements. 


Example:


BEGIN


EXECUTE IMMEDIATE  'TRUNCATE TABLE employee';


END;

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2686
Q:

What are the differences between static ip addressing and dynamic ip addressing?

Answer

With static IP addressing, a computer (or other device) is configured to always use the same IP address. With dynamic addressing, the IP address can change periodically and is managed by a centralized network service

Report Error

View answer Workspace Report Error Discuss

0 2685
Q:

How can you send an email message from an ASP.NET Web page?

Answer

You can use the System.Net.Mail.MailMessage and the System.Net.Mail.SmtpMail classes to send an email in your Web pages. In order to send an email through your mail server, you need to create an object of the SmtpClient class and set the server name, port, and credentials.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2684
Q:

What files are important in a bootable Windows XP operating system?

Answer

There are four important files in order to make a bootable Windows XP operating system. These are Ntldr, Ntdetect, Boot.ini and Ntfs.sys

Report Error

View answer Workspace Report Error Discuss

0 2682
Q:

What are the factors that are addressed to integrate data?

Answer

Following are the data integration factors:


- Sub set of the available data should be optimal. 


- Noise/distortion estimation levels because of sensory/processing conditions at the time of data collection.


- Accuracy, spatial and spectral resolution of data.


- Data formats, storage and retrieval mechanisms.


- Efficiency of computation for integrating data sets to reach the goals.

Report Error

View answer Workspace Report Error Discuss

0 2681
Q:

What is android? What are the features of Android?

Answer

Android is a stack of software for mobile devices which has Operating System, middleware and some key applications. The application executes within its own process and its own instance of Dalvik Virtual Machine. Many Virtual Machines run efficiently by a DVM device. DVM executes Java language’s byte code which later transforms into .dex format files.


Features of Android :


- Components can be reused and replaced by the application framework.
- Optimized DVM for mobile devices
- SQLite enables to store the data in a structured manner.
- Supports GSM telephone and Bluetooth, WiFi, 3G and EDGE technologies
- The development is a combination of a device emulator, debugging tools, memory profiling and plug-in for Eclipse IDE.

Report Error

View answer Workspace Report Error Discuss

0 2679
Q:

What are different ABAP/4 editors? What are the differences?

Answer

The 2 editors are se38 and se80 both have the abap editor in place. In se38 you can go create programs and view online reports and basically do all thedevelopmet of objects in this editor. In se80 ( object navigator) there are additional features such as creating packages,module pool , function group ,classes, programs ( where you can create ur programs) and BSP applications .

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

0 2678