EMC Interview Question Software Engineer in Tests

  • emc-interview-questions
    0
    of 0 votes
    1
    Answer

    Write a method to change the password of a valid user in the following database table. The method accepts 3 parameters userId, oldPassword, NewPassword:

    ......................................................
    UserId Username Password
    ......................................................

    .......................................................

    The password should be changed only when the old password is valid.

    - panshul21 on June 02, 2012 in India for RSA Report Duplicate | Flag
    EMC Software Engineer in Test

Team: RSA
Country: India
Interview Type: Written Test


Comment hidden because of low score. Click to expand.
0
of 0 vote

public void changePassword(String userId, String oldPassword, String password, Connection conn) {
StringBuilder str = new StringBuilder();
sbr.append("Update table set password = :pass where userId = :user and password = :oldPass");
PreparedStatement psmt = conn.prepareStatement("Update table set password = :pass where userId = :user and password = :oldPass");
psmt.setString("pass",password);
psmt.setString("user",userId);
psmt.setString("oldPass",oldPassword);
int out = psmt.executeUpdate();
if (out == 1)
//successful
else
//unsuccessful

}

- Achilles on June 03, 2012 | Flag Reply


Add a Comment
Name:

Writing Code? Surround your code with {{{ and }}} to preserve whitespace.

Books

is a comprehensive book walking you through getting a job at a top tech company, while focuses on dev interviews and does this for PMs.

Learn More

Videos

CareerCup's interview videos give you a real-life look at technical interviews. In these unscripted videos, watch how other candidates handle tough questions and how the interviewer thinks about their performance.

Learn More

Resume Review

Most engineers make critical mistakes on their resumes -- we can fix your resume with our custom resume review service. And, we use fellow engineers as our resume reviewers, so you can be sure that we "get" what you're saying.

Learn More

Mock Interviews

Our Mock Interviews will be conducted "in character" just like a real interview, and can focus on whatever topics you want. All our interviewers have worked for Microsoft, Google or Amazon, you know you'll get a true-to-life experience.

Learn More