Greens Technologys Whatsapp
Greens Technologys Whatsapp

Selenium Training in Chennai

Enroll Now

"Call us for course fees and attractive discounts"

Selenium Training in Chennai

Selenium Training in Chennai

Greens Technology, Rated As Best Selenium training institute in Chennai. We provide Selenium training in Chennai with real time projects and 100% Assured Job Placements.

Learn Selenium Testing course in Chennai with the most experienced trainers in the field. Awarded as the Best Selenium Training Center in Chennai - Located in Adyar, Anna nagar, OMR, Velachery and Tambaram.

You Going to get Amazing Benefits of Our Selenium Software Testing Training Package at Greens Technologys

Our Selenium with Appium course syllabus includes Selenium Architecture, Selenium WebDriver 3.0, Waits, TestNG, Jenkins, Page Object Modeling [POM], Locating Techniques, AutoIT, Sikuli, Page Object Design Pattern, mobile testing with Appium and Selenium Grid and more with Live Projects – Hands on 80 hours training on Live Selenium Project.

The Selenium with Appium training in Greens Technology are designed for beginners with little or no automation experience. If you are new to testing first take the Software Testing course.

Selenium Testing Training Course Fees

New Batch Starts : Selenium New batch starting on 12th and 14th Sep 2018. Celebrate this Vinayaga Chathurthi (god of wisdom) by registering a course with Greens Technologys and begin a new career to your life. Whoever registers awaits a surprise gift.   

FREE Demo Session: Try two FREE CLASS to see for yourself the quality of training.

Flexible Timings / Weekend classes Available.

Awarded as the Best selenium Training Center in Chennai - We Guarantee Your selenium Training Success in Chennai

About Myself

I work as a QA Automation Lead for a Leading MNC in Chennai with 9+ years experience in both QTP and SELENIUM.

Flexible Timings / Weekend classes Available.

Talk to the Trainer @ +91-9080125737

Selenium Training in Chennai

Greens Technology is recognized for its Selenium Training in both retail and corporate market. We have trained above 28,000 students exclusively on QTP and Selenium in last 7 years.All our trainers’ expertises on both development and training which helps us deliver project based training.

Our wonderful Selenium training team lead by Mr. Velmurugan who is working in a leading MNC, researching and automating web applications for last 10 years and contributing to the best Selenium training in Chennai.

All our trainings focuses on practical than theory model. We provide hands-on training experience which helps you test web applications easily at the end of the training program.

What is Selenium?

Selenium training in chennai Selenium is a popular automation testing tool which is widely used to test the web applications. The main purpose of Selenium tool is automating web browsers. Selenium is also defined as the set of various tools to automate different web applications. The different tools include Selenium IDE, Selenium WebDriver, Selenium RC, Selenium Grid. Many of popular web browsers support Selenium by adding it in their browser by default.

Why Selenium?

Selenium Automation testing tool is used all over the world since it is effective and also open source. According to the latest survey Selenium automation testing tool is used by 70% of companies and also the growth of automation testing increased while comparing to the previous years. Selenium is also named in the Top Trending Software Technologies 2018.

Selenium training in chennai

Tools in Selenium

Selenium training in chennai

Jenkins : Jenkins is the leading open-source continuous integration tool developed by Hudson lab. It is cross-platform and can be used on Windows, Linux, Mac OS and Solaris environments. Jenkins is written in Java. Jenkin's chief usage is to monitor any job which can be SVN checkout, cron or any application states. It fires pre-configured actions when a particular step occurs in jobs.

Git Hub : Git Hub is a Collaboration platform. It is built on top of git. It allows you to keep both local and remote copies of your project. A project which you can publish it among your team members as they can use it and update it from there itself.

Maven : Integrating Maven with Selenium provides following benefits. Apache Maven provides support for managing the full lifecycle of a test project. Maven is used to define project structure, dependencies, build, and test management.

Frameworks in Selenium

JUnit : JUnit is a unit testing framework for the Java programming language. JUnit has been important in the development of test-driven development, and is one of a family of unit testing frameworks which is collectively known as xUnit that originated with SUnit.

Cucumber : Cucumber is a software tool used by computer programmers for testing other software.[7] It runs automated acceptance tests written in a behavior-driven development (BDD) style. Central to the Cucumber BDD approach is its plain language parser called Gherkin.

TestNG : TestNG is a testing framework designed to simplify a broad range of testing needs, from unit testing (testing a class in isolation of the others) to integration testing (testing entire systems made of several classes, several packages and even several external frameworks, such as application servers).

Impressed with our Course Content?
Attend a Free Demo Session to Experience our Quality!

Selenium Training Course Syllabus in Chennai

Selenium Training Course Content


  • What is automation testing?
  • What is the use of automation testing?
  • What we need to Automate?
  • What is Selenium?
  • Advantages of Selenium
  • What is the difference between Selenium and QTP?

Different flavors in Selenium

  • IDE
  • Selenium Web Driver/Selenium 2.0
  • Selenium-Grid

Selenium IDE

  • Installing Selenium IDE
  • Selenium IDE icons
  • Recording your first test with Selenium IDE
  • IDE Context Menu
  • Assert
  • Verify
  • Adding Selenium IDE comments
  • Synchronization commands
  • Working on pages with AJAX
  • Storing elements
  • Creating test suites
  • What you cannot record

Locators & Object Identification

  • Tools to identify elements/objects
  • Firebug
  • IE Developer tools
  • Google Chrome Developer tools
  • Locating elements by ID
  • Finding elements by name
  • Finding elements by link text
  • Finding elements by XPath
  • Finding Elements by using CSS
  • Summary
  • Some Special IDE commands
  • Write your own Selenium IDE script without record and playback

Java For WebDriver

    Introducing the JAVA technology:

    • 1. Relating Java with other languages
    • 2. Showing how to download, install, and configure the Java environment on a Windows system
    • 3. Key features of the technology and advantages of using Java
    • 4. Java Features
    • 5. Write Simple Java Program
    • 6 Compile and Run the class files
    • 7. Java Programming format
    • 8. Java Keywords
    • 9. Java Data Types
    • 10. Declarations and Access Control
    • 11. Operators and Assignments
    • 12. Flow Control
    • 13. Typecasting
    • 14. Arrays
    • Packages:

    • 1. Introduction to all predefined packages
    • 2. User Defined Packages
    • 3. Access Specifiers

      Object Oriented Programming Concepts:

    • 1. Introduction
    • 2. Class
    • 3. Object
    • 4. Local, Instance and static variables
    • 5. Constructors
    • 6. This keyword
    • 7. Inheritance and Types
    • 8. Working with super classes and subclasses
    • 9. Using types of polymorphism such as overloading, overriding, and dynamic binding
    • 10. Abstraction
    • 11. Encapsulation
    • 12. Abstract classes
    • 13. Interfaces

    String Processing:

    • 1. String manipulation with String Builder and String Buffer
    • 2. Essential String Methods

    Exceptions and Assertions:

    • 1. Introduction
    • 2. Exceptions categories
    • 3. Standard Java Exception classes
    • 4. Using Try-catch and finally clause

    I/O Streams:

    • I/O using Java
    • Files (Create/Read/Write operations on files)

    Wrapper Classes:

  • Introduction
  • Byte, Short, Integer, Long
  • Float, Double
  • Character
  • Boolean classes


  • Introduction to Collections framework
  • util Package
  • List, Set and Map
  • Difference of All Collections Interfaces and classes
  • Reading data from Property files using java program
  • Reading and Writing data from/to Excel files using Apache POI API and JXL API

Junit FrameWork:

  • Running Java Programs using junit
  • Writing Selenium tests from scratch using Junit FrameWork
  • JUNIT Annotations
  • JUNIT Methods
  • Frequently used Selenium commands
  • Test Suites using JUNIT
  • Parameterized test cases using junit framework

TestNG FrameWork

  • Overview of TestNG
  • Environment of TestNG
  • Writing WebDriver Test Cases using TestNG
  • Basic Annotations of TestNG
  • Executing Tests
  • Executing Test Suites
  • Ignore Test
  • Dependency Test
  • Parameterized Tests
  • TestNG XML
  • Report Generation


  • Why WebDriver?
  • Downloading web driver Jars configuring in eclipse
  • Architecture of selenium webdriver
  • Drivers for Firefox, IE, Chrome, Iphone, Android etc
  • What is the difference between Selenium RC and WD?

Sample programs in webdriver

  • Handel Text box
  • Handel HyperLink
  • Handel Button and Check box
  • Handel Radio Button and DropDown Controls
  • Select value from DropDown
  • Display all values
  • Select values step by step
  • Capture screenshots
  • Synchronization Commands In Web Driver
  • Why Implicit wait and Implementation of Implicit wait
  • Why Explicit wait and Implementation of Explicit wait
  • Web Driver Fluent wait and Thread Sleep functionality
  • File uploads and File downloads (Handling Window based controls using Robot and Sikuli API)
  • Handling alerts box and Verfying the Alert Texts
  • Handling confirmation messages
  • Keyboard actions
  • Mouse actions
  • Handling Iframes working with Nested Iframes
  • Handling multiple tabs
  • Handling popups
  • Preparing web driver test cases using customized x-path
  • Identifying controls using x-path predefined functions

Web Tables

  • 1. What is Web Table
  • 2. Extracting data from web tables
  • 3. Examples on static and dynamic Web Tables
  • 4. Creating Reusable functions for Web Tables
  • Web Driver with TEST NG Frame Work
  • Batch Running Test cases using TestNG
  • Validations and its usage in Automation test scripts
  • Customized Report Generation
  • Implementing Logs using Apache Log4j API
  • Database testing using Web Driver

Working with multiple browsers

  • Executing Automation Test Cases in multiple browsers Sequentially
  • Working with Chrome and IE browsers
  • What is Firefox Profile And Implementation of Firefox Profile
  • What is WebDriver Desired Capabilities class
  • Executing Automation Test Cases in multiple browsers Parallel

Maven Project Management Tool

  • Introduction about maven
  • High Level Overview
  • Ant vs Maven
  • Installation of Maven
  • Demo using Sample Maven Project
  • Maven Structure

    • 1. Introduction of Maven Folder Structure
    • 2. The pom.xml
    • 3. Dependencies
    • 4. Goals
    • 5. Local Reo Structure
    • 6. Defaults
    • 7. Sample Demo of Build Session of Maven Project

    Maven Dependencies

  • 1. Dependency version
  • 2. Versions
  • 3. Types
  • 4. Transitive Dependencies
  • 5. Scopes

Maven Repositories

  • What is a Repository
  • Dependency Repository
  • Adding a Repository
  • Plugin Repository

Maven Eclipse Integration

  • 1. Demo Installation
  • 2. Importing Projects
  • 3. Converting Existing Projects
  • 4. Pom Viewer
  • 5. Effective Pom

Version controlling tool GITHUB

  • Downloading and configuring Github
  • Difference between CVC Versus DVC
  • Basic Git Commands
  • Working with Repositories
  • Setting up Repositories
  • Local and Remote Repositories
  • Create repository and cloning projects
  • Committing and Syncing the code
  • Reverting and Rolling Back the Code
  • Branch and Merging Concepts and Implementation
  • Stashing Changes
  • Resolving the Conflicts

Database testing using web driver

  • Installing MySQL Database
  • sql package
  • Overview on Connection Interface, Statement Interface, Prepared Statement and Result set Interfaces.
  • Example program to Access Database.
  • Some examples on SELECT,UPDATE and DELETE queries
  • Some Web driver examples using Data fetched from Database

Automation Test Frame Work

How to develop Test automation frame work in live environment

  • What is a frame work
  • Types of frame work
  • Data driven frame work
  • Modular driven frame work
  • Keyword driven frame work
  • User Defined Keyword driven framework with implementation
  • Execute test scripts from the framework

Continuous Integration Testing using Jenkins

  • About Jenkins
  • History of Jenkins
  • Splitting of Projects
  • What is Continues Integration
  • Installing Jenkins
  • Creating a simple job
  • Integrating Jenkins to the Project

The Fundamentals of RESTFul Services in Java

  • What is Jersey?
  • RESTFul Architecture
  • Using HTTP GET Demo
  • Test Created New REST Service USING HTTP GET
  • JSON Output for HTTP GET
  • Using HTTP POST Demo
  • Test Service USING HTTP POST
  • JSON Output for HTTP POST
  • Using HTTP PUT Demo
  • Test Service USING HTTP PUT
  • PUT vs POST
  • JSON Output for HTTP PUT
  • Using HTTP DELETE Demo
  • Test Service USING HTTP DELETE
  • JSON Output for HTTP DELETE

Interview Questions on

  • Selenium IDE
  • Selenium webdriver and Automation Testing
  • Core Java
  • Manual Testing Concepts
  • Overview on Selenium Grid

share training and course content with friends and students:

  • selenium training Chennai
  • selenium training in Chennai OMR
  • selenium training in Chennai Adyar
  • selenium training center Chennai
  • selenium realtime course with frnds
  • selenium online training best institute
  • selenium course greens technologys
  • best selenium training in Chennai
  • selenium tutorial
Click here to view detail course along with subtopics in each module.

High Facts which makes us the BEST Selenium Training Institute in Chennai

  • Practical oriented Selenium Training in Chennai and Online Training by Industrial experts.
  • Also, we provide Basics to Advanced level concepts in training series.
  • Furthermore, our Instructor has 10+ years of experience in Selenium Training & Testing Automation.
  • As a result, You can get updated knowledge in Selenium Testing.
  • We have Best Lab facilities, so you can use it as much as you want.
  • Almost Interview focused Selenium Training for beginners in Chennai.
  • Therefore, we guarantee 100% Selenium jobs placement support for freshers.
  • Consequently, Practical Assignments, Assessments and Mock interview will be conducted post training sessions.
  • We are also Ranked Best Selenium Training Center in Chennai Velachery as much as all positive Reviews
  • Most noteworthy Less selenium training fees in Chennai.
  • Hence, We offer Hands-on Selenium Training in Chennai and placement assistance for candidates.
  • Also, We provide adequate knowledge about Selenium automation testing and the different frameworks.
  • Our value is the attention each student receives from us while learning the Selenium Training in Chennai.
  • Since Compact batch size for Best Selenium Automation Testing Training in Chennai.
  • Our Selenium Training in Chennai classes will make sure that you get confidence in Software Test Automation.
  • Especially our Course content formulated for the Job based Selenium Training in Chennai.
  • Yet GREENS TECHNOLOGYS offers Selenium corporate training for Software Developing Companies.
  • In addition, Special care will be taken for the Freshers during Selenium Training Chennai.
  • Finally, Affordable Selenium course fee with special offers for Students/Freshers at Best Selenium Training in Chennai.
  • In result, You can get Highly skilled Selenium Training with Less course fees in Chennai.
  • It is our esteemed duty to communicate the current prominence and requirements to accomplish tasks and jobs through Selenium Training in Chennai.
  • Minimum Selenium training cost in Chennai.

Live Selenium Project

This selenium classes in chennai will put you in a Corporate Test Environment. You will be automating Selenium test cases for banking and Ecommerce website. You will create & execute automation scripts and have an opportunity to compare it with scripts created by our experts. Students Will learn to create Webdriver Test Script for a Banking application. How to parameterize a Script using Excel. How to use TestNG for a script. How to take screenshots of test output & add verification steps to the script. The project will last 7 daywith your work allocation for that day.

Selenium Placement Training in Chennai

Greens Technologys has placed many students and help companies to hire certified and trained candidates on QTP and Selenium. GT now serve companies to find rightful talent who successfully fill up the gap for required set of skilled professional.

Selenium training in Chennai Reviews

Greens Technology Reviews given by our students already completed the training with us. Please give your feedback as well if you are a student.

Selenium training in chennai Reviews from our Students

Selenium training chennai

Velmurugan Prabhakar j! I am really delighted about the Selenium course and i am surprised to see the depth of your knowledge in all aspects of the software testing. I see that many architects with over 15+ yrs experience doesn't have the knowledge that you have. I really enjoyed your sessions, definitely look forward to learn more from you in the future. Thanks again." "

Best Selenium training institute in Adyar

Selenium training chennai

Friends I am from Manual testing background having 6+ years experienced. I planned to Move into Selenium. I Came to know about Greens technologies and Velmurugan Prabhakar who is working in Selenium. They Really helped me to clear the interview. Thanks to Velmurugan Prabhakar Sir. Knowledgeable Presenters, Professional Materials, Excellent Support" what else can a person ask for when acquiring a new skill or knowledge to enhance their career. Greens Technology true to its name is the place to gather,garner and garden the knowledge for all around the globe. My Best wishes to Greens Technology team for their upcoming bright future in E-Learning sector.

Best Selenium training center in OMR

Selenium training in chennai

" I am glad to have taken complete Selenium course in Greens Technologys. It helped me a lot in understanding various concepts before which I was depending on many other sources. I will recommend this Selenium course to beginners as well as experienced developers/ Testers to attend the courses offered by Velmurugan @ Greens Technologies Adyar. The course curriculum is meticulously prepared and also followed without any compromise. Thus, the beginners can understand how to begin learning a vast technology without any confusion. In my case, attending this course, helped me firstly how to learn the subject in a different approach (understandings basics level to in depth concepts), instead of rushing through various text books or online sources. Velmurugan explains every concept in a very interesting way and it always creates an excitement in learning more about Selenium. Moreover the material, notes from training also helps us prepare for interviews, certification, real time projects as well.

Learn Selenium Training In Chennai From The Experts!

Looking for best selenium training in Chennai, Greens Technology is the no 1 selenium Training institute in Chennai offering placement focused selenium course by selenium experts. Call +91 89399-15577 for more details.


1.Write a plsql blocks using bulk collect, to select rows from employees table and insert it into another table

2. Select first 3 employees details for each department

3. Select the number of 'a' in a string

4. What is subquery and correlated sub query

5.Difference between views and materialized views

6.Diff between procedures n functions

7.Where did u use refcursor in the project

8.How to delete duplicates using joins

9.Diff types of subqueries

10. Collections and types

11. Which collection u used in the project

12.Analytical function , triggers , index , performance tuning. ,

13 You have 10000 records in one table and u have to copy 5000 records to another table...

14. Group function

15. Exceptions,package,function,procedure difference,analytical functions ,using exception some problems

1.What is normalization?
2.How to convert Listtag into normal table view?
3.I have 100 lines of procedure and 23 line not executed but I want remaining line will be executed what You do?
4.Where did you use partition table in your application?
5.What is collection which collection you used recently in your application?
6.What is SQL loader?
7.delete duplicate using join?
8.sub query type and recently used sub query and how did you use?
9.what is correlated sub query did you use so for?


1,brief about your self and your current project.
2,have you worked on development environment.
3,Tell me the last procedure code.
4,What is collection and Types.
5,scenario given based on Varray. I have an variable which contains 100 records now I want delete last 10records.
6:Save exceptions and pragma
7,Why we use for all and save exceptions
8,Analytical function query scenario given,
9,what is DBMS profiler and explain plan.
10,why you used DBMS profiler
11, exceptions
12, scenario given based on exceptions. My procedure have to run without getting error msg which types of exception you will use.
14, Tel me something about View.
15,merge query
16,Do you know about dbms scheduling job.

1.SQL loader. 

2.What is constraint? 

3. Difference between primary key and foreign key?

4.What is view? 

5. Difference between delete and truncate?

6.can we perform dml operation in view? 

7.difference between procedures and functions? 

8.rank & dense rank. 

9.cursor in detail.     

10.null functions

1.How ur getting requests
2.If u need any clarification in task who is the contact person
4. What r the things u ll do once task completed
5.Aggregate functions
6.Listagg with Concate query
8.Can u able to create Index for columns which is having null values? Will Optimizer read that index?
11.All loading concepts(sql loader detailed)
12.Procedure using truncate
13.Procedure detailed
14.Functions detailed
15.Explain plan
16.About performance tuning
17.Bulk collect & bulk bind
18. Save exception
19. Few Unix commands
20. Use of anonymous block

1. Tell me about yourself?
2. Performance tuning?
3. Index is invalid what you will do that?
4. How you rebuild the index?
5. Explain plan?
6. Gather stats?
7. What happens if gather stats command executing?
8. Table partitioning and its types?
9. Mview and its refresh method?
10. Collections ?
11. How to use nested table inside the plsql block?
12. Explain Varray?
13. Have you experience in 11g and 12c?
14. What is cursor ?
15. Refcursor ?
16. Dynamic sql??
17. Is it possible to use execute immediate for select statement?
18. Pipeline function?
19. Forall with save exceptions?
20. Where will you get the failed records?
21. Difference between rank and dense_rank?
22. Difference between lead and lag?
23. Row_number?
24. Difference between delete and truncate?
25. Physical classification of oracle?

1. Tell about your self
2.what is index . types and when you used index
3. What is trigger and types
4.exception and types to alter the sequence value 10000 to 5000 (reduce)
6.what is pragma autonomous transaction ..and where it is used
7. How to find the error in SQL and plsql
8. Table A having 10 records , table B having 6 records .. I am insert 4 records in Table A then truncating table B insert 3 records in Table A ...then insert 5 records in table B now I am going to do ROLLBACK table A and Table B records ?
9. What is function and its types
10. Employees table having column Emp_I'd ,Dept_I'd,Dept_name,
Department table having column is Dept_I'd,name
Write a query for above two tables
(1). Create syntax for this two tables
(2). Find the duplicate records in employees table based on department table
(3). Select highest salary for each department ..
11. Materialized view and why you are  using in you project

Tell about yourself
Tell about your project
Delete duplicate records from table
Joins and types
Write a query on 5th maximum salary
Diff b/w delete,drop,truncate
Diff b/w views and materialized view
What is gtt
What is Stored procedure and example
What is compound trigger
Functions and purposes
When you used pragma autonomous transaction
What is dynamic SQL?
Some queries asked

Today I attened 2 round in chain sys..

1.about ur self
2. Performance tuning
3. What is index
4. Last incident request
5.last change request
6.Which employees getting max salary than manager salary
7.write a query We having emp table in that who is getting max salary than Krishna.

1st round questions

1. Tell about yourself
2. What is analytical functions?
3. What is cursor and its types?
4. What is exception handling and its types?
5. What is collections and its types?
6. What are the types of triggers?
7. What is compound trigger?
8. What is mutating table error? How you over come that in your project?
9. Difference between cursor and ref cursor
10. What is package?
11. What is overloading?
12. Write a procedure for scenario based question
13. How many procedures you have created so far?
14. Explain about performance tuning
15. Steps to improve the performance of the query

Chain-sys interview questions

1.introduce yourself
2.what is truncate, delete to delete duplicates
4.what about triggers and types
5.diff b/w decode and case
6.cursor types
7.exception handling
8.have u handled exception in ur project
9.why we use bulk collect

And then two scenario based questions

Chain-sys interview questions

About your self
Do you know Oracle forms
Different between detele and truncate
Different between case and decode
What is cursor and attributes and types
Why we use ref cursor
What is aggregate functions
What is listag function and quirey
How to delete duplicates in table
Different between rank and densrank
What is utl_file
What is table partitions


Chain-sys interview questions

1.Tell about yourself
2.describe about single row function
3.describe about group function
4.describe about joins
5.if there is table t1
First we will insert then update , then alter table after that we will give rollback.what is the output.
6.write query to show first 5 highest salary.
7.difference between %type and %rowtype.
8.difference between unique key and foreign key. will you call procedure and function.
10.write store procedure where employee_id input and salary as output. will you raise an error. will you use sqlloader, describe the steps.

Chain-sys interview questions

1.introduce yourself
2.what is truncate, delete to delete duplicates
4.what about triggers and types
5.diff b/w decode and case
6.cursor types
7.exception handling
8.have u handled exception in ur project
9.why we use bulk collect

And then two scenario based questions

Chain-sys interview questions

1st round
1. Introduce yourself.
2. Rate in SQL and PLSQL.
3. Explain about subquery.
4. Explain right outer join.
5. Explain performance tuning.
6. What are the methods using in performance tuning.
7. Explain views.
8. Datas insert in view, it will affect in master table?
9. Different user inset the data in same table, what will happen.
10. Explain about trigger.
11. You can use commit inside trigger?
12. Explain about pragma autonomous transactions.
13. Explain about anonymous block
14. Different between procedure and function.
15. Able to call procedure inside function?
16. Explain about cursor.
17. Cursor types.
18. Explain refursor.
19. Explain about bulk collect.
20. Explain about exception.
21. Exceptions types.
22. Advantages of bulk collect.

Chainsys interview questions

Tell about Ur self and daily work
Dml and ddl
Delete and truncate different
SQL loder
Log file
Performance tuning in SQL
What is the use of procedure in Ur project
Where Ur using function in Ur project
Questions from resume
U know about Oracle forms
Structure of plsql block
Exception handling
List out the Predefine exception handling

1.Tell about your self
2.can you use any function in your project
3. SQL function
4.Error handling
5. Second maximum salary - write query
6.Analytical function
12.pragma autonomous
13.have u used pragama autonomous in your project...
14.difference between decode and case
15. Difference between NVL and NVL2

Chain sys 1st round interview question

1.what is views uses of views and write syntax
2.what is synonym uses of synonym. Where ur is used in our project
3.what is index
4.what is constraint uses of constraint where ur in used in our project
5.what is cursor and its types
6.what is packages how to execute the package
7.structure of plsql block
8.where is located in ur company

1. Tell me about yourself.
2. Stud-table
slno same gender smark
1. X M. 81
2. Y. M. 75
3. Z. F. 79
From_mark. To_mark. Rank
1. 45. 5
46. 60. 4
61. 75. 3
76. 90. 2
91. 100. 1
Sname. Gender. Rank
X. M. 2
Y. M 3
Z. F. 2
Asked not to hard code.
2. Write a trigger using the above stud table in which we can modify the sname and gender column but it should not allow to modify smark column.
3. How to add a new parameter to an already existing procedure.
4. Diff b/w view and materialized view.
5. What is pragma autonomous transaction and where you used in your project.
6. Asked to write scenario based programs using implicit cursor, explicit cursor, bulk collect, ref cursor and collections.

Beyontec Interview Questions

1.What is index
2.wht is cluster
3.shall we create index by using select statement
3.types of join
4.showed 2 tables t1 and t2 asked output for inner join, outerjoin (left,right)
5.What is collection
6.write a procedure using collection for inserting data's from table t1 to to
7.Write a trigger to show exception when someone try deleting rows from table t1 to disable multiple triggers in a table using a single query
9.what are the features of 11g and 12c

1.tell me ur roles and responsibilities
2. External table and table partitioning table partitioning using joing date of the employee do the interval partitioning
4.performance tuning
5. What are all the stored procedure u created
6. How to data migrate from one server to another server

1. Tell about your self
2. Roles and responsibilities
3. How to insert and update in single query
4. Types of index
5. Explain bree and bitmap index
6. Diff view and mview
7. Type of constraints
8. Explain forgin key
9. Perform tuning
10. Explain about sequence
11. What is the cursor
12. Where u r using in your project
13. You have any thing with out using cursor to move the data one table to another table
14. Explain Triggers
15. Explain row level trigger and where u r using in your project
16. Explain about partition
17. Explain the range partition
18. Do you know unix
19. Do you know shell scripting
20. We are looking for DBA developers

Tell about your project
Working timing
What's index and type
What is view
What is synonym and purpose
What's constraints

Write query need answers like this Mahesh, suresh

Different between stored procedure and procedures
R u working now..
Y did u leave the job...
What is c in 12c what is g in 10and11g

1.procedure vs function
2.wat is trigger
3. Can we create index on view?
4.what is index?
3. Write a full query for a table t1 a 0,1,0,1 update 0 as 1 and update 1 as 0
4. Delete duplicate values in a table
5.write 2 max sal in a table

1. Explain ur project
2. Write a query to get n th salary
3. Rank the employee using rownumber

4. Analytical fn
5. Synonym
6. View
7. Materialized view
Why we use mview
8. Index
D/b bit map and b tree index
9. Forward declaration
10. Pragma autonms trasctio
11. Constraints
D/b primary key and foreign kry
12 Stored procedure and local procedure
13. Update the gender f as m, m as f
14. Emp_name

Get output as raja,mani

1st round
3. difference between views and mviews
7.difference bw procedure and function
8. Difference bw joins and set operator
9 .joins types
10 cursor
12.difference bw runtime error and syntax error
13.any ideas about MySQL
14.write program user defined exception
15. Difference between union and Union all
16.difference bw statement level trigger and row level trigger.
18 . difference between primary key and unique

1 What is materialized view. What types of refresh it have ?
2 What is index ? Types of index ?
3 What is collection ? Types of collection ?
4 Difference between index by table and nested table ?
5 If you declare index by table or nested table what will
Be the default value ?
6 What is cursor ? Why we are using cursor? Why can't we use index by table or nested table ? The difference?
7 Difference between function and piperow ?
8 How does the explain plan work ?
9 Do you know gather statistics ? Explain ?
10 How will you find tablelock ?
11 What is mutating error ?
12 What is exeception ? Types ?
13. Tell some predefined exception you gone through?
14 Why we use others in exception ?
15 what is hints ?
16 What is table partitioning ?
17 In bulk collect what is the use of save exception ?
18 You are using save exception how will you find the
Records that are not inserted ?
19 In table which scan will perform faster. Unique or Full scan ?
20 Difference between analytical function and aggregate functions ?
21 How you write rank functions ?

1.technical stuff which u have many incident u r working on daily basis
3.tell some frequently receiving incident and how u resolve it
4.How u r using SQL query in Ur current project
5.Last faced issue
6.future career plans for next two years
7.are u willing to learn new technologies
8.which one u r preferring support or Dev

1.what are the types of table partitions you known about composite partition.
3.view and materialized view different
4.delete and truncate different
5.aggregate function and analytical function different
6.rank and dense rank difference
7.what are the hints use used to insert bulk data
9.what is save exception
10.have u work with perform tunning will u to the query optimization
12.where will index scan increase the performance and where full scan increase the performance
13.have used utl function. Why u use utl function
14.about cursor

1. About ur self
2.project to day activities you have experience in bulk collect, collection you have experience in creating table view constraints which place is your company. process
8.noties periods

2nd round:

1.Tell me about your self?
2.What is diff between stored procedure?
3. What is cursor?
4.what is view?
5. What is dbms jobs
6. What are indexs and types?
7. What is a package
Salary table
Sal column:
Write a query to get 1st name ,max of salary from salary table.

9. T1 table
Update B in place of A and A in place B. What is the query sir?

1. Self intro
2. Day to day activities
3. Package and forward declaration
4.Difference between collection and record
5.identify the duplicate rows
6.Complexed need o/p like this
7. Gtt
8. In gtt concept one table created on commit preserve rows. User doing some activities in session 1 and suddenly he power off the system ,now the data will save in gtt table or not
8. Trigger
9.which methodology you are working
10. In toad what is the data module.


1.Tell about u r self
2. Synonyms and Sequence
3. What is primary key and how it works?
4. What is cursor and types?
5.tell how you work on release management.
6.write any procedure for % rowtype
7.views and mviews
8. Write correlated subquery
9. Exception and how its works?
10. What is know exception.
11. What is index? use of index in your project?
12 in Mview how we insert data and types of Mview?

MSc today interview question 1st round:

1.tell about yourself
2.explain your project
3.diff b/w views and tables
4.what is triggers and triggers type
5.diff b/w row level trigger and statement level trigger
6.diff b/w union and union all
7.what is index and it's type
8.diff b/w b*tree index and bitmap index
9.what is ref.cursor
10.what is join and it's type
11.diff b/w equi join and outer join
12.what is constraint and it's type
13.diff b/w primary constraint and unique constraint
14.what is Mviews
15.what is packages and uses of packages
16.what is Sequence and write the syntax
17.performance tuning
18.write the feature in 11G and 12c
How many time trigger fires in row level
And how many time trigger fires in Statement level above the table

MSC interview questions

1.what is table
2.what r the constraints
3.what is index and its types
4.what is joins and types of joins
5.why we use join
6.give join example based on ur project
7.what is table partitions why we are using
8.what is view
9.type of views
10.why we r using view
11.what is force view
12.what is materialized view and its type
13.why we use materialized view
14.what is materialized view u created explain based on ur project will log file created
16.what is methodology ur using performance tunning how will u find the problem line.
18.what is cursor and its type and attributes
19.write example for explicit and implicit cursor
20.why we are creating package
21.what is parent and child table name the table u created
22.explain correlated subquery
23.are u used toad tool
24.are u raised ticket
25.what are methods u follow to improve query performance
26.are u used trigger type of triggers
27.what trigger u used in ur project
28.write trigger to restrict data insertion in particular table
29.what are the collection types
30.where u used collection in ur project

1st round ques

1. Tell about yourself
2. What ticketing tool you have used?
3. Different between problem and request?
4. How did you response for the incident?
5. Create two tabels and perform inner join.
6. About aggregate function?
7. Write query to get count of students group by course id from stud and course table.
8. Willing to work in 23/7 shift?

2nd round

1. Tell about yourself
2. What is your role in your project.
3. Have you interact with customer's call?
4. Have worked in performance tuning and what is that?
5. Day to day activities?
6. What are the enhancement you have done?

Virtusa first round

1. Write a function with ref cursor

2. Write a dynamic sql

3. In sql what is Exit and In

4. Write a unix command to find sql files

5. How do you conncet proc with database

6. Tell me what you know about proc

7. How do you connect your database

8. Select 1 from employees what is the result..employees table contain 10 rows

9. What was your role in support

10. How will u handle the issues

11. How many character can a varchar2 handle

12. Write a query to change datatype for column

13.have you done any performance tuning

14. How do you know if there is a problem with index

15. Different types of index and how will you decide which index is better

Virtusa for Developing

1.Tell about yourself
2. Day to day activities
3. Incident , problem ticket tool
4. What is package and it’s advantanges
5. Materialized view
6. How the data will get update in M.view
7. How the M.view log will get created
8. Global temporary table
9. Write Refcursor program
10. Query for nth max salary
11. How will Analazy the query slowness and how will u rectify that
12. Performance tuning experience and example
13. Table t1
A b
1 A,b,c
2 A,b,c
O/p will be like
1 A
1 B
1 C
2 A
2 B
3 C
14. What is collection
15. Dynamic sql
16. How to implement ddl in plsql
17. Index and when you use it
18. Do you know Pro*c?
19. Have experience in writing complex sql queries ?
20. Refresh methods in M.view and explain with real time
21. What is Utl_file ? Where it can be stored ?
22. What is debugg? Explain
23. Explain plan ?
24. Exception handling

Virtusa 1st round:

1. Tell about yourself
2. Sequence scenario based question
3. Synonym and it purpose.
4. Diff betw delete and truncate
5. How to load flat files into table
6. Regexp_substr scenario
7. Display negative and positive value from the table
8. Pro c basic
9. Whether dml operation can perform in external table and materialized view
10. Write Bulk collect and bulk bind with exception combined program to fetch data and insert data into table
11. Unix commands any
12. How to copy file from one server to another server
13. How to fetch first 10 data and last 10 data
14. How to edit particular char in the file and exact command
15. Some dba privileges.
16. Performance tuning approach for slower query in a table step by step
17. Table partition approach syntax any.

Second round

1. Tell about your project activity
2. Is multiple joins are possible in a table and how many condition can give.
3. Self join scenario
To retrive data from 3 table. Eg. Order, sales and supplier table
4. Pro c basics of our own.

1. Self intro
2. Day to day activities
3. Cursor and advantages, which type of cursor using your project and reason
4.Trigger and where you used in your project
5. How to know exception handling and list out the few errors
6. Collection and types
7. Which concept you are using to load data in oracle database and explanation
8. Do u have performance tuning knowledge
9. Have you connected with server
10. Do u have knowledge in Unix comments

Msc technology 16/3/19

1. Self intro
2. Day to day activities
3. Cursor and advantages, which type of cursor using your project and reason
4.Trigger and where you used in your project
5. How to know exception handling and list out the few errors
6. Collection and types
7. Which concept you are using to load data in oracle database and explanation
8. Do u have performance tuning knowledge
9. Have you connected with server
10. Do u have knowledge in Unix comments

Capgemini interview questions

Tell about your project
Your role in your project
Difference b/w function and procedures
How many return statement we can use in function
Cursor attributes
Use of refcursor
Table partition
Is it possible to create a partition already defined table,if yes then explain how .
Will u able to create primary key for already defined table
Use of index
In u r project where u use index
Performance tuning
Do u know any Oracle packages
Use of UTL files

Capgemini - First round

Joins query with employee table
Diff bet view and table
Diff bet nested table , varry and nested table
about types of exception in collection
update mr if male and mrs if female in front of employee name in employee table. use cursor to process one by one record and use error log table to insert exception records captured
when a transaction will start in oracle
how will you identify a complex view and how to update a record in it
DB Architecture and normalisation
What happens when we get xception in plsql block
What happens internally when we perform dml and ddl operation in sql
How will u access a schema object from another schema
Can a column with Alias name be used in query stored in view
Query to display departments having more than two employees

1.diff b/w truncate and delete
2.diff b/w aggregate and analytical function
3.disadvantages of indexes
4.what is corelated subquery to delete duplicates in a table
6.what is bulk collect
7.if we delete rows in a table and create a new table . Now roll back what will happen
8. Exception handling
9.diff b/w procedure and functions
10.maximum how many columns can create in a table to get first 100 rows in table using dual.
Without using table name.
12.basic unix commands
13. Which is faster union or union all



1.What is view and view types?
2.What is index and you will create index on two column for ename,Eno and we use where clause in ename then what will happen index will perform or not?
3.Different in table and truncated?
4.What is mview? to delete duplicate records in a table?
6.diff between join and sub querys?
7.what is minus ? many columns inserted in a one table?
9.What is unique key?
10. If you truncate one table and give roll back then what will happen?

1.what is pragma autonomous transection?
2.write program in Plsql to print 10 records?
3.for and forall different?
4.external table? to known how many rows inserted and it query?

TCS interview questions:


1. Rate itself
2.diff bw truncate and delete
3. Diff bw group function and analytical function
4. index explain
5. Parallel hint explain
6. Delete duplicate
7. Materialize view and how to refresh
8. If I drop table wt abt index and procedures
9. Need only structure of table and no need of u create table
10. Find birthdate
11. Display only year
12.wt is synonym
13. Procedure contain 100 SQL statement .how to identify which is slow
14. Composite index select statement has two columns but in where clause only one column mentioned.wt is the output
15.diff bw instr and substr

In Plsql

1. Bulk collect explain
2. Procedure and function diff
3. Package explain
4. Can we use commit in trigger, procedure and function
5. How to print deleted no of rows in Plsql
6.collection methods

2. Sed
3. Awk
4. Cat

2st round interview questions.

1.about yourself
2.Explain about project
3.Exception handling
4.Sturucture of Exception Block
4.why use bulk collect
5.Explain Performance Tuning
6.11g features
7.difference between cursor and bulk collect
8.Are you check the execution time of bulk collect data
9.Given Reason bulk collect is faster then cursor
Maximum question ask in Collection and bulk Collection...

1. Materialized view
2. What is bulk collect
3. Difference between leftouter join and right outer join
4. Uses of packages
5. How to execute a procedure
6. Sql load and write its program
7. Write a prigram to repy the result as production 20, sales 40 by using two table

Write a program using joins
8. Difference between local variable and bind variable
9. Tell me aboit youself
10. Rate u in sql and plsql

3i Infotech 1st Round Interview Questions :
1) Tell about yourself
2) Tell about your project
3) Logics you implementaed in your project
4) Roles & Responsibilities in Support
5) Roles and responsibilities in development
6) Cursor Attributes
7) Trigger & Purpose of trigger
8) Write a query to track the trigger for scenario

Scenario : We have a table named employees having columns emp id, emp name, address, age , date of joining.
If customer entered string in age column instead of number... How will u track in trigger??

3i infotech interview questions:-
1.tell me about yourself
2.what is bulk collect.
3.what is cursor.
4.difference between trigger and constraint.
5.write procedure using pragma autonomous transaction. will you handle error.
7.tell about performance tuning.
8.if there is multiple error what is the range for raising error.
9.what is collect and attributes.
10.cursor and refcursor difference.

Ebix 1st Round Questions

Ebix 2nd Round Questions

1.tell about yourself
2.find duplicated in table
4.cursor vs loop which is best
5. Where exception used in your project it possible to insert sqlerrm directly into table if yes mean how?
7.set operators
8. Use of Anonymous block and where u used in project
9. If Function return multiple value and how?
10. What WR u got?

1.Tell about yourself.
2.Explain in your project and where you expert in your project.
3.write a procedure to display the dublicate row.
4.Explain index. can index increase the performance.
6.what is the view and mview.
7.about dbms_job.
8.explain trigger. to insert the value using trigger?
10.Perfomence tuning.

Ebix 2nd Round Questions

1. Explain your project
2. What is your Recent work request
3. How to delete duplicate records in a table with scenarios
4. Can function returns multiple values
5. What is Sequence
6. What is SQLERRM
7. How will you store the error datas in seperate table
8. Explain about execute immediate
9. What is Synonyms

Ebix 2nd Round Questions

1)about gavs technology full detail.
2)about ur projects
3)give 3 features b/w 11G and 12C
4) by using function
1st parmeter "ababcabacaba"
2nd parameter char(1) ie "a"
How many a place in fst parameter.
5) boolean variables.
6)implicit cursor

Ebix 2nd Round Questions

1.Self Introduction
2.explain your project
3.write a procedure by giving dept Id as input and output should be the total count of duplicate values.
4.Explain table partitioning and it's advantages .
5. Explain btree index.
6.difference between view and mview
7.Explain index hints
8.what is a package

Ebix 2nd Round Questions

1. Tell about yourself
2. Day to day activities
3. Project details
4. Procedure to delete duplicate rows
5. Indexes
6. Explain about exceptions
7. Performance tuning
8. Last work request
9. What is SQLERRM?

1. What is Sga and PGA
2.hard parse vs soft parse.which one take more time.explain why
3.syntatic and semantic check
4.bind variable Vs local variable
5.query for self join in real time
6. Write a query to convert hours into minutes.
7. Two table employee and department.employee table having two column and three records.dept tab having two column and two record
Emp Id. Dept is
123. 1
246. 2
129. 1

Dept table
Dept I'd. Location
1. Chen
2. Pune
Write query to find count of employee location wise in each department u have support experience
9.are to convinient to work in this location to day activities

2.Your roles and responsibilities
3.What module you use in your project
4.Last you and yours team faced ir
5.Last 3 month wr,cr
6.Cursor types will you handle error.
8.tell about performance tuning.
9.Difference between delete and truncate
10.Last u create procedure and use input parameter.
11.what is use of single row function
12.What are the null function u used in project
13.round and trunc function used in your project.
14.What purpose round function in your project
15.write merge operation program
16.cross join and write query
17.difference between trigger and constraint
18.table1. table 2
Col a. Col B
1. 1
2 2
3 3
4. 4
5 5
7 7
10 8
Output like
10 functions.
20 global variable.
21.what is bulk collect
22 company location .
23.shift time.

3i infotech Interview questions:

1.Roles and reponsibilities
2.Tell about your project.
3.what is refcursor and its type?
4.what are all the collection methods?
5.Write the query to find more than 3 employees in the department?
6.what are all the 11g features?
7.How will you fetch a table data into a single variable?
8.what is global variable and where will you declare that variable?
9.Tell me the types of cursor?
10.If i give department id as input. So i need o/p as all employee_id in the same row.(Ex: dept_id 90, o/p should be
11.what is bulk collect?
12.In last 6moths what is the challenged task you faced in your project?
13.what kind of CR you faced from last 6months?
14.Write a query using collection type(nested table) to fetch the data FIRST_NAME from employees table?
15.I need to stop the trigger action on friday alone so what will you do?
16.what is Pragma autonomous transaction?

1.Tell me about yourself.
2.Triggers and its types.
3.Where we use instead of?
4.write a query to fetch a table data into a single variable?
5.what is exception handling and its types?
6.what is Sql loader?
7.How many format of files (i.e. txt,xlxs like that) you created?How will you load that file?
9.write syntax for sqlerrm and sqlerrcode?
10.what are all the cursor attributes?
11.what could be the max. Length of procedure name?
12.what could be the max. length of column name?
13.what is SDLC draw the architecture?
14.what is index?
15.what is constarints?

3i infotech technical round question

1.self intro
2.daily activites
3.diff between rollback and commit
4.write query using procedure , cursor, eception handling from t1 and t2 tables having primary and foreign key constraint.

telephonic round today in kumaran systems

1.brief about technical knowledge of yours in Oracle
2.what is view,where you used
3.Diff btwn view and materialized view
4.What is clob where it is used
5.tell about sql loader
6.tsll about external table
7.have you worked in performance tuning
8.what is procedure
9.what is function
10.What is on hold and on ice
11.diff bw union and union all you will get duplicates values in a table
13.what is there in control file

Recent Interview Questions

Infrasoft Interview Questions

Temenos interview questions

1.Consider a employee table display all records whose play more than one role
2.consider a student table display the student details with display the sum of total marks and display the percentage of total
3. Emi calculator query
4.get the aadhar details and print all the details as well as total sum of amount gaining in a year
5. Write an eassy for assinged job why u r not completed the job with a time frame

1. Self intro
2.what is role in ur project.
3. What is main nature of work
4. Nvl
5 nvl2
6 different nullif and coalesce
7.diff delete and truncate
8.diff rownum and rowid
9 how to record delete
10 I have one table. That table is 40 records . Particularly I delete 10 th record. Tell query how to delete.
11. Rating in SQL out of 10, from, where ,order by, group by, having . which order to query is execute
And explain
13. Joins &types.
15. Function based index with example
16 when did you complete oca.
17. What r the function u used in ur project.
18.set operator
19. Different bw union and union all
20. What is minus
21. What is partition by
22. Having clause
24 diff between function and procedure
25. Rowid, rownum which one is dynamic.


Selenium Training in Chennai

Our Reviews 5 Star Rating: Recommended - Best IT Training in Chennai

5  out of 5  based on 12263 ratings.

Google          5 Star Rating: Recommended - Best IT Training in Chennai

Facebook      5 Star Rating: Recommended - Best IT Training in Chennai

UrbanPro       5 Star Rating: Recommended - Best IT Training in Chennai

Sulekha         5 Star Rating: Recommended - Best IT Training in Chennai

Yet5              5 Star Rating: Recommended - Best IT Training in Chennai

Justdial          5 Star Rating: Recommended - Best IT Training in Chennai

selenium training chennai

Selenium Training in Chennai

Highlights of Selenium Testing Training

  • The presence of experts in Selenium real time as the training faculty.
  • Provides the best learning environment.
  • Limited students per each batch.
  • Faculty’s interaction with each and every student for the better subject retention.
  • Well, affordable Course Fee.

Selenium Training in Chennai


No.11 , First Street ,
Padmanabha Nagar , Adyar ,
Chennai-600 020.


No.19, Balamurugan Garden, OMR Road, Thoraipakkam,
Kancheepuram (DT).


No.28, Nagendra Nagar, Opposite Phoenix Mall, Velachery, Chennai - 600 042.


No.1, Appa Rao colony,
Chennai - 600 047.

Anna Nagar

SDV Arcade
4th floor, AB-5, 2nd Ave, Anna Nagar, Chennai - 600 040.

Selenium Training in Chennai

Selenium Training in Chennai
best Selenium training center in chennai

"HI, I have taken Selenium training in chennai at Greens technology. i'm impressed with course content and enquired for selenium. i really do not have any idea about selenium and so i attended the demo class conducted by Mr.Dinesh. this gave me a confidence with the course and tempts me to join in this particular centre for this course. i found out the extraordinary knowledge of Maven,TestNG and Jenkins tool with my trainer. this gave me a great experience of learning the course and i would suggest Greens Technology for SELENIUM"

Selenium training in chennai

"HI. This is jeni. i came to know about this institute through my friend and i felt that it was a good start for my career as an automation tester.I dont have any idea about what am going to learn. Green Technology gave me a good hands of trainee to teach me with a better course. the class starts from basic Java and ends up in advanced Selenium. i dont regret for investing my money and timing here. Mr. Kamal gave me good knowledge of Selenium. thank you Greens Technology. "

Selenium training classes in chennai

"i'm happy to comment for you about the training which you gave me. " I have completed my selenium Training in automation at Greens Technology. i had a very good experience of learning selenium. The content was precise and the classes were informative and interactive. they provided me with the required materials to learn the language. Our trainers cleared our doubts whenever required." Thank you GREENS TECHNOLOGY. After learning the course, i got placed in In Selenium with Java Training"

Selenium training chennai

"I did Selenium Training in Chennai at Greens technology. Training was Really Good and we had a real time experience. Mr.Velmurugan Sir is our trainer who has very good knowledge of Selenium he helped us a lot in preparing our resume according to my domain. Overall I am very much satisfied with this Selenium Classroom training. Now I am having the confidence to attend any interview in Selenium Technology. Thanks to Greenstechnology for providing wonderful hands-on Training in Selenium Course."

Greens Technologys Overall Reviews

Greens Technologys Overall Reviews

5 out of 5 based on 17,981 ratings. 17,981 user reviews.

Related Trainings

Job Trends

software testing training

Greens Locations




Relevant Courses