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 2774
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 2774
Q:

What divisions, sections and paragraphs are mandatory for a COBOL program?

Answer

IDENTIFICATION DIVISION and PROGRAM-ID paragraph are mandatory for a compilation error free COBOL program.

Report Error

View answer Workspace Report Error Discuss

0 2771
Q:

What are the dialog boxes that are supported in android? Explain.

Answer

AlertDialog : An alert dialog box supports 0 to 3 buttons and a list of selectable elements, including check boxes and radio buttons. Among the other dialog boxes, the most suggested dialog box is the alert dialog box.


ProgressDialog: This dialog box displays a progress wheel or a progress bar. It is an extension of AlertDialog and supports adding buttons.

DatePickerDialog: This dialog box is used for selecting a date by the user.

TimePickerDialog: This dialog box is used for selecting time by the user.

Report Error

View answer Workspace Report Error Discuss

1 2769
Q:

Why interface method is always public?

Answer

To make this method available to every implementation class

Report Error

View answer Workspace Report Error Discuss

Subject: Java
Job Role: IT Trainer

0 2769
Q:

What are user defined data-types and when do you use them?

Answer

User defined data-types in SQL is an extension to the base SQL server data-types by provision of a descriptive name.


We use them to format the database and segregate specific repetitions of rows and columns in the database.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 2768
Q:

When would you use the ping command with the "-t" switch?

Answer

to get the ping back from other computer with no packet loss

Report Error

View answer Workspace Report Error Discuss

1 2766
Q:

How do we measure progress in Data Integration?

Answer

Look for the existence of the following items:


- Generic Data Models


- An Enterprise Data Platform


- Identify the Data Sources


- Selection of a MDM Product


- Implementation of a Customer Master Index or appropriate alternative

Report Error

View answer Workspace Report Error Discuss

0 2766