Published March 30, 2019 by

How To Explain Project In Interview Freshers and Experienced

Describe an important project you’ve worked on” is one of the most common questions you can expect in an interview. The purpose of asking this question is to check your project management experience and project management skills.

The other traits that they would like to check are , how you manage or deal with tough situations, your approach towards challenges, skills in leading a project successfully. So, you should answer this question carefully.
The first thing you need to do is prepare for this question in advance. As this is one of the common questions, you should very well be prepared with an effective answer. For it, you need to prepare a list of all your projects and clearly mention all the goals and the roles you have played in completing those projects.
With the help of your answer, your interviewer should get to know about your priority setting, decision making, meeting deadlines, and assigning tasks etc.
Some of the points while preparing the answer are
1. Provide a best suitable example
2. Be clear and specific
3. Your role should be explained clearly
4. Brief them the mistakes to avoid

Project Explanation in Interview for Freshers and Experienced:

There are few things which any interviewer would expect from a project you have done previously irrespective of being a fresher or experienced. They are,
1. The way you solved a problem in the project.
2. Your role in the project.
3. Your imagination or creativeness in the concept of the project.
These are the main things any interviewer would expect from your project. Try to categorize your project into various steps and explain in a very crisp way to make them feel one with your project to win the interview. The various steps to explain a project are,

1. Project Introduction:

This is very important in explaining a project as it overall sets the mood of the interviewer about the project. So try to impress the interviewer with a good heading or you can start by telling the application of your project in the market. Also, try to tell your motivation behind choosing this as your project.

2. Modules description:

There might be various modules for a project. It differs according to the project you choose. Try to break your project into various modules and explain. This will bring clarity to the interviewer about your project.

3. Advantages and the main functionality of your application:

Try to speak about the functionality of your application in a few words and also include their advantages. Sometimes pictorial representations will help for the better understanding. So explain your project with a flowchart, chart diagrams, or any graphs. This will add extra scores to your explanation about your project.

4. Tools, Technologies, and Platform used:

This is also a very important aspect when explaining a project. Tools, Technologies, and platform used will help the interviewer understand better about the working of the project. As well as it will create an impact on how new is your project. Try to explain it very short and be to the point.

5. Personal contribution and your role in the project:

Any interviewer would only focus on how well you have contributed for the project. Try to show your individuality in the project while explaining. It might be small or big, it is how you portray yourself for the project. Don’t try to be too modest by telling it is a team work, because this is an interview for an individual and not for the team.

6. Challenges in the project:

You might had some difficulties and challenges during your project. Explain the interviewer how you had overcome the challenge and also explain about the thought process of yourself to overcome the difficulties.

7. Number of people in the project:

Even though individuality in the project is expected, an interviewer might also check the team work and your compatibility during the project with a team. So try to highlight the teamwork when explaining the project.

8. Amount of time it took for the project:

Amount of time involved in the project will be expected from the interviewer side to know how you manage the time limit when given to you. So explain it in two to three lines about the time limit of your project.

9. Improvements in the future for the present system:

Try to show your involvement in the project. You can also explain the future improvements for the present project. Also, talk about the expectations of you towards the project in future. This in turn will showcase your confidence, and positivity towards the work.

10. Drawbacks:

This has to be handled carefully, as never explain too many drawbacks of your project. And use correct words to explain the drawbacks. Show your positive mental attitude when explaining the negatives of the project. All they want is how much you are capable in handling negatives in the work.

Interview Tips For Experienced Candidates:

There is a lot of difference between a fresher’s experience in explaining a project in their graduation and an experienced person explaining the project. Both are equally important, but expectations differ for the both. For example, from an experienced candidate during the interview, project explanation will decide how capable he is for the job. There are few things which has to be remembered while explaining about the project during the interview.
They are,

1. Explain your overall project:

This explanation totally differs from fresher’s explanation about the project. Give a brief explanation about the project title and also its impact on your previous company. Talk briefly about its importance in your previous organization.

2. Talk about the technology, working, and tools used in previous company:

Try to explain about the overall technology used, working of the project and also explain about the importance of the project in the company. This will help the interviewer gain confidence on your skill set.

3. Overall months or years you worked:

Tell about the time period you worked on the project as it will talk about your commitment towards the project, and also experience you gained throughout the project.

Few points to emphasize:

Some of the points to focus while answering are
  • Specify about the skills and features that needed to complete the project
  • Have a positive mindset
  • Discuss the goals of the project
  • How interesting the project was
  • What made you accept this project

Mistakes You Should Avoid

Some of the mistakes to miss are
  • Be little careful
  • Do not get in detailed project information
  • Never criticize your previous employers
  • Do not drag your answer
Read More
    email this
Published March 16, 2019 by

Selenium with Python | Oracle Database Connectivity using cx_Oracle | Data Driven Testing

About cx_Oracle

cx_Oracle is a Python extension module that enables access to Oracle Database. It conforms to the Python database API 2.0 specification with a considerable number of additions and a couple of exclusions.


Overview

To use cx_Oracle 7 with Python and Oracle Database you need:

Python 2.7 or 3.5 and higher. Older versions of cx_Oracle may work with older versions of Python.

Oracle client libraries. These can be from the free Oracle Instant Client, or those included in Oracle Database if Python is on the same machine as the database. Oracle client libraries versions 18, 12, and 11.2 are supported on Linux, Windows and macOS. Users have also reported success with other platforms.

An Oracle Database. Oracle’s standard client-server version interoperability allows cx_Oracle to connect to both older and newer databases.

Quick Start cx_Oracle Installation

An installation of Python is needed. Python 2.7 and Python 3.5 and higher are supported by cx_Oracle 7.

Install cx_Oracle from PyPI with:

python -m pip install cx_Oracle --upgrade

Pre-requisites

1) Oracle data base
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/Windows_DB_Install_OBE/Installing_Oracle_Db12c_Windows.html

2) Oracle instant client
https://www.oracle.com/technetwork/topics/winsoft-085727.html

3) cx_Oracle though command prompt
Command should execute in command prompt: pip install cx-Oracle

4) cx_Oracle in Pycharm
Select project-->File-->Settings-->Project interpreter--> Click on + -->cx_Oracle-->select-->install package.


Database operations using Pyhton(cx_Oracle Module)

1) Connect to database
2) How to execute queries(insert, update, delete)
3) How to select data from database
4) Data driven testing

Connect to database

import cx_Oracle
import os
os.environ['PATH']='E:\\app\\OracleHomeUser1\\instantclient_18_3'

#Establish connection to the database
con=cx_Oracle.connect("hr","hr","localhost/pdborcl")
print("Connected!!!")
con.close()

How to execute queries(insert, update, delete)

import cx_Oracle
import os
os.environ['PATH']='E:\\app\\OracleHomeUser1\\instantclient_18_3'

#Establish connection to the database
con=cx_Oracle.connect("hr","hr","localhost/pdborcl")

cur=con.cursor()

query1="insert into student values(102,'JOHN')"
query2="update student set sname='XYZ' where sid=102"
query3="delete student where sid=102"

cur.execute(query3)

cur.close()
con.commit()
con.close()

print("Completed!!!")


How to select data from database 

import cx_Oracle
import os
os.environ['PATH']='E:\\app\\OracleHomeUser1\\instantclient_18_3'

#Establish connection to the database
con=cx_Oracle.connect("hr","hr","localhost/pdborcl")

cur=con.cursor()

query="select * From employees"

cur.execute(query)

for cols in cur:
    print(cols[0],"     ",cols[1],"     ",cols[2])

cur.close()
con.close()

print("Completed!!!")


Data Driven testing

from selenium import webdriver
import time
import cx_Oracle
import os
os.environ['PATH']='E:\\app\\OracleHomeUser1\\instantclient_18_3'

driver=webdriver.Chrome(executable_path="C:\Drivers\chromedriver_win32\chromedriver.exe")

driver.get("http://newtours.demoaut.com/")
driver.maximize_window()

#Establish connection to the database
con=cx_Oracle.connect("hr","hr","localhost:1521/pdborcl")

cur=con.cursor()
query="select * From users"
cur.execute(query)

for cols in cur:
    driver.find_element_by_name("userName").send_keys(cols[0])
    driver.find_element_by_name("password").send_keys(cols[1])
    driver.find_element_by_name("login").click()
    time.sleep(5)

    # validation started
    if driver.title == "Find a Flight: Mercury Tours:":
        print("Test passed")
    else:
        print("Test failed")
    driver.find_element_by_link_text("Home").click()

cur.close()
con.close()

print("Data Driven test Completed!!!")




Read More
    email this
Published March 13, 2019 by

Webservices/API Testing FAQ’s Part-3 SoupUI


43.What is SOAPUI & ReadyAPI?
  • SOAPUI is a Webservices/API Testing tool.
  • SOAPUI Pro (Ready API) which is Licensed version of SOAPUI
44. What is WSDL?
  • WSDL stands for Web Service Description Language and is a document written in XML.
  • It uses XML to define the service layer document which consists of origin of the web service, headers, port types, request and response data.
  • This one can provide the information about web methods and web service.
  • It describes:
  • Origin of the web service
  • Header information
  • Port type
  • Input and output messages
45. What is the role of WSDL document in web service testing?
  • Validating web services in only possible with WSDL document because to configure web services in SoapUI, WSDL document is mandatory. If the WSDL document is not valid, SoapUI will throw an exception immediately.
46. What is UDDI?
  • Universal Description, Discovery and Integration- a directory or global repository where all the web services can be found.
  • A new Webservice can also be registered through this.
  • This is also the place where WSDL detailed definitions are found.
47. What is SOAP?
  • Simple Object access protocol that uses XML to interact with web applications.
  • It uses XML based content to communicate between two client machines across any network
48. What would be the message format of SOAP protocol?
  • Generally, all the SOAP-based web services are written by using XML language which uses standard message format that is accepted across the universe. In this format, it is easy to read, identify the errors, avoids interoperability problems etc.
  • Here’s the sample SOAP message format.
49. What are the advantages of SOAP?
  • Since its XML based, it is platform and programming language independent. RPC (Remote procedure calls) are sometimes blocked by firewalls and proxy servers- Soap overcomes that.
50. SoapUI and SoapUI Pro?
  • SoapUI is a web service testing tool and SoapUI Pro is its commercial version.
  • SoapUI can help create functional, security and load testing test suites.
  • SoapUI Pro does all that with advanced drag and drop, Data Driven testing, advanced reporting and coverage analysis.
51.What we can do with the help of SoapUI?
  • SoapUI offers us to perform automation testing which includes functional testing, load testing and Data Driven testing.
  • It also provides in build reporting tool and export test results
  • We assert our services using various types of assertions
52.What hierarchy does SoapUI follow to build a proper testing project?
  • In a SoapUI project, the following order maintained.
  • TestSuite – This is combination of functional tests and logical blocks
  • Testcase – It’s a group that contains several test steps for the specific aspects of the service.
  • Teststep – it contains the set of functional tests
53.What is the basic method to automate web services in SoapUI?
  • Create a project and add the WSDL file
  • Add test suites, Test cases and Test cases- in that order
  • Include custom programming/validation using by adding Groovy steps
  • Call external data sources if using
  • Add assertions if necessary
  • Then RUN.
54. What are SoapUI assertions?
  • Assertions compare the parts/all of the response message to the expected outcome.
55. What are the major types of assertions available in SoapUI?
Assertions are one of the major features in SoapUI.
It offers the following types of assertions.
  • Simple contains
  • Schema compliance
  • Simple not contain
  • Soap Faults
  • Response SLA
  • XPath Match
  • XQuery Match
  • WS security status
  • Script Assertion
  • WS- Addressing Request or Response Assertion
Additionally, Equals assertion is introduced in SoapUI NG Pro version.
56. Explain about XPath Assertion in SoapUI
In SoapUI, XPath assertion is used for asserting the web service response value by specifying the absolute path.
If the absolute path is matched with the response value, then the test case or test suite will be considered as PASS otherwise it will be notified as FAILED.
We can see the results of assertion at bottom of the screen where the Assertion tab will have resultant information.
57. What is Data Driven testing?
Data Driven testing means to store our test data which includes input and expected output in an external data source called Excel / Database / XML file. Later, we need to iterate the data source using respective component.
In SoapUI, Datasource and Datasource Loop test steps are used for performing data driven testing.
58. What are the different types of assertions used in SoapUI?
The following are the different types of assertions:
Contains & Not Contains
XPath match
XQuery match
Schema compliance
Soap Faults
Response SLA
WS security Status
Script Assertion
WS- Addressing Request or Response Assertion
59. What is Groovy script and where can it be used?
Groovy is a scripting language which internally includes all the Java libraries – it helps us to customize and add custom validations to SoapUI tests
60. How to group tests?
The basic Test suite is a way for us to group tests in SoapUI.
When you need a different set of tests, you just have to create a new test suite and create tests as required under it as test cases.
61.How to save the responses received?
The response values can be saved by clicking on the required request and choosing the “Dump file” location in its properties.
62. What are the properties available in SoapUI?
In SoapUI, there are three levels of properties available. They are,
Custom Properties or Project Level Properties:
These properties are added several times based on our needs and they can be utilized at any test suites, test cases or test steps that belong to the current project.
Test Suite Level Properties:
The tester can add his own properties with relevant information under the test suites. These properties are available for the corresponding test suite only.
Test case Level Properties: If the tester needs to store their test data within the test cases they can create their own properties inside the test case. So these properties can be accessed within the respective test cases.
63. What can data sources be used in SoapUI?
Excel Files
CSV Files
ODBC Sources
SQL / ADO Objects
Read More
    email this