Greens Technologys phone
Greens Technologys Whatsapp

DevOps Training in Chennai


Agile DevOps Training in Chennai by Certified Professionals. Become an expert DevOps engineer from Best DevOps Training Institute in Chennai with the most experienced and DevOps certified expert trainers in the field. Greens Technology provides DevOps training and certification in Chennai to professionals and corporates on Deployment and automation using devops tools - Chef, Docker, Puppet, Ansible, Nagios, Git, TestNG, SonarQube, Jenkins, and Project Object Model (POM) in Maven. We offer DevOps job assistance (subject to project availability and partner requirements) for positions in India, Singapore, Dubai and the UK.

FREE Demo Session: Try two FREE CLASS to see for yourself the quality of training.
Duration: 55 - 60 hours

About The Trainer

- Gani work as an DevOps Consultant & Instructor, He has over 11 years of Implementation experience and recognized expert in Linux, AWS, Azure, DevOps, OpenStack Gani is a professional agile coach and Certified Scrum Developer (CSD) trainer. He is having 11 years of experience in software development and have worked with many organizations and on multiple technology stacks including .Net/C#, Java, Ruby, Python and JavaScript etc. Gani is Certified LeSS (Large-Scale Scrum) Practitioner and have helped organizations is agile adoption. He is one of the early adopter of DevOps practices and teaches DevOps culture, practices and tools to development team and operation team.

Flexible Timings / Weekend classes Available.

Talk to the Trainer @ +91-8939915577

DevOps Training Course Overview

Git and Unit Testing

Get introduced to Git; learn Git installation, configuration, commands, branching strategy; Git in DevOps orchestration; different types of unit testing; writing a simple JUnit test; and get introduced to TesNG

Build Tool and Orchestration Using Jenkins

Learn about Apache Maven® installation and its configuration; Maven® repositories and plugins; profiles and release; understand Project Object Model (POM) in Maven®; using a POM file to run unit testing (Jenkins); build setup in Jenkins; test automation; security in Jenkins; and notification system

Web Server and Deployment

Different types of web servers, proxy servers, mail servers, installation of Apache Tomcat®, manual deployment, and automated deployment within continuous integration

Code Quality

Different types of code quality tools, installation of SonarQube and code analyzer, and running SonarQube for a project.

Automated Testing

Different kinds of automation testing tools, use of test automation in the CI/CD pipeline, introduction and configuration of Selenium, writing Selenium scripts, understanding sample test automation framework, execution of framework in web applications, and Selenium for Mobile Application Automation

Containerization Using Docker

Container and Containerization, different types of Containers, Docker installation, Docker Run commands, advanced Docker run commands, overview of Docker Compose, and creating your own images

Puppet

What, why, and how; Use Case 1 (Why use Puppet); Puppet installation and configuration; Puppet architecture; Basic Puppet terminologies; Puppet language constructs; resource implementation; managing files and executing programs; Puppet modules; defining the QA environment; changing the Base Module path; Hiera backend creation in Puppet; using Puppet modules; and Puppet forge GitHub repo

Continuous Monitoring Using Nagios

Combining Jenkins, Docker and Puppet, Introduction to Nagios, Nagios Plugins, Nagios Objects, Nagios Commands, and Nagios Notification

DevOps training Course Syllabus


  • What is Cloud Computing
  • How Cloud Computing are helpful
  • Cloud's role in DevOps orchestration
  • What is AWS
  • Use cases in AWS
  • Companies using AWS and Market tends
  • Different Services offered in AWS
  • Use case: - Highly available fault tolerant systems
  • Understanding availability zone
  • region
  • Creating your own account in AWS
  • Creating a VPC
  • subnet
  • network gets way
  • Running your own EC2 instance
  • Connecting in EC2 and installing https in EC2
  • S3
  • Over viewS3
  • SNS. Cloud watch
  • Understanding the Serverless (Lambda)
  • DevOPsHistory and evolution of DevOps
  • What is the market trend of DevOps
  • Which back ground people can switch to DevOps
  • Some typical tool stack for DevOps Jobs
  • How to get maximum from the course
  • Client-Server and Distributed Version control system
  • Advantages of Git over SVN
  • Git User trends
  • Different Git tools (GitDesktop. Kraken)
  • Git Installation and Configuration
  • Setting up Git Bash and Git UI
  • Creating first repository: Local
  • Git commands: add
  • commit
  • push
  • status
  • history
  • Branch why what? Understanding Master
  • Creating a Branch
  • Merging a Branch
  • Resolving Merge conflicts
  • checking the difference
  • Understanding the tags: Modifying
  • undoing
  • deleting and discarding
  • What
  • Use Case of Unit Testing
  • Different kind of Unit Testing
  • What is JUnit
  • Writing a Simple JUnit Test
  • TesNG introduction
  • Write a Unit Testing Case in your Favourite language.
  • Use Case in Maven
  • Ant vs Maven
  • Maven installation and Configuration What is Maven Central
  • Dependency Management why and How
  • Introduction to POM
  • Build lifecycle
  • Maven repositories Maven plugins
  • Using a POM file to run unit testing(Jenkins)
  • Multi-module POM
  • dependency hierarchy
  • Artifactory management
  • Maven Release and Snapshot
  • Assignment- Create a Maven Hello world Java Project
  • Run the Unit testing and and create the artifact for that
  • Use Case (How Artifactories are managed)
  • Artifact Lifecycle
  • Basic use of Sonatype Nexus
  • Artifactory Live demo
  • Use Case WebServer Deployment in DevOps
  • Architecture
  • Different types of Webserver
  • Proxy servers
  • Mail Server
  • Installation of Tomcat
  • Manual Deployment
  • Deploying a Web application using Maven
  • Idea about Automated Deployment using Continuous Integration
  • Create a Tomcat Server and Deploy the application manually
  • Create a Tomcat Server and Deploy the Application Using Maven
  • Benefits of Code Profiling tool
  • Use case of Code Profiling tool
  • Different kind of Code quality tools
  • Over view of Sonar
  • Installation of SonarQube
  • Installation fo Code Analyser
  • Sonar profiles
  • Running Sonar for a project
  • Configuring SonarQube for one Sample Java project.
  • Why Jenkins ?
  • What is Continuous Integration and Continuous Deployment (Use Case1)
  • Jenkins installation and Configuration
  • Running Jenkins as windows service
  • Deploying Jenkins in Tomcat Server
  • Jenkins Global Configuration
  • Building your first Hello world job
  • Jenkins User Management
  • Jenkins Plugin management
  • Jenkins SCM configuration (Git SVN)
  • Understanding the Jenkins workspace
  • Build
  • pre build and post build job
  • Jenkins Unit testing
  • Automation testing
  • Mail notification
  • Jenkins Reporting
  • Matrix and trend
  • Jenkins remote executor
  • Master Slave configuration in Jenkins
  • Jenkins Most used plugin
  • Advanced Reference
  • Jenkins pipeline plugin
  • Groovy scripting
  • Scriptler
  • Jenkins Parameterized build
  • Environment inject plugin
  • Use of Jenkins environment variables
  • Deploying a specific revision
  • Customizing the Jenkins UI
  • Project based Matrix plugin
  • Parallel Execution
  • Configuring Jenkins Hub and Node in the cloud (AWS)
  • Configuring a Selenium Desktop node with a Linux Server (AWS)
  • Case Study
  • Real time implementation of Automated role back
  • Multi branch Deployment.
  • What is Virtual Machine
  • Why we need it
  • What is Container
  • Difference between Containers and Virtual Machine
  • Docker Installation and Configuration
  • Major Docker Components
  • Container Management Running Containers
  • Dockerfile
  • Working with Registries
  • Docker Port Forwarding
  • What is Configuration Management
  • Configuration Management Challenges
  • Configuration Management in DevOps Ecosystem
  • Some tools
  • Trends
  • What is Ansible
  • Advantages of Ansible
  • Environment Provisioning
  • Configuration Deployment
  • Installation of Ansible (AWS)
  • Modules
  • Playbooks and Writing a Playbook
  • What is Monitoring
  • Why we need monitoring
  • Different tools of monitoring
  • What is Nagios
  • Nagios Architecture
  • Different components of Nagios
  • A typical Nagios Dashboard
  • Installation and Configuration
  • What is Container and Containerization
  • Different types of Containers
  • DOCKER: What why how ?
  • Use Case 1 (Why Docker)
  • Docker installation
  • Docker VS Vagrant
  • Docker Run commands
  • Advanced Docker
  • run commands
  • Docker volume persistence
  • Overview of Docker Compose
  • Docker Hub
  • Creating your own image
  • Advanced reference
  • Create a Docker container to run Jenkins
  • Create a Docker container to run a CI/CD pipeline
  • Use case 1 (Why puppet)
  • Puppet installation and configuration
  • Resource implementation
  • Managing files and executing programs
  • Testing your code Using Puppet Languages
  • Variables Numbers and Strings
  • Facts
  • control flow
  • Regex
  • Loops
  • Resource Processing
  • Advanced Course
  • Puppet Modules
  • Define QA environment
  • Changing Base Module path
  • Separation of Data from Code
  • Introduction to Hiera
  • Hiera Backend creation in Puppet
  • Variables and Function lookups
  • Using Puppet modules
  • Puppet Forge-Server- GitHub repo.

DevOps Training Course Objectives

DevOps training in Chennai is designed to make you a certified practitioner by providing you hands-on training on DevOps tools and teaching best practices about Continuous Development, Continuous Testing, Configuration Management, including Continuous Integration and Continuous Deployment and finally Continuous Monitoring of the software throughout its development life cycle. Our mentors are qualified DevOps Engineers with a minimum of 10+ years of experience.


DevOps Training Prerequisites

There are no specific prerequisites for this course. Any professional who has an understanding of IT Service Management can join this training. There is no programming knowledge needed and no prior DevOps experience required.

  • Systems Admins
  • Developers
  • Testers
  • Solutions Architect
  • Release Engineers
  • Cloud Professionals

What will I get in this DevOps Training course?

Apart from live mentoring, you will get access to 200 hrs of assignments and projects on the tools used in this course. You will also be given access to a case study which will include implementation of end-to-end pipelines using tools like, Jenkins, Git, Docker, and Puppet.

What is the system requirement for this DevOps Training course?

One must have a minimum of 4 GB RAM (8 GB RAM is recommended) and a Core i3 processor or higher configuration.

DevOps Certification Exam Details

DevOps is the cultural and professional movement that stresses communication, collaboration, integration and automation in order to improve the flow of work between software developers and IT operations professionals.

DevOps certifications are offered by the DevOps Institute (DOI), which brings enterprise level DevOps training and certification to the IT market. Working with thought leaders from the DevOps community, the IT Service Management field and the IT training market, the DOI is setting the standard in quality for enterprise grade DevOps education and training.

Who is DevOps for?

The DevOps certification scheme is aimed at individuals and organisations seeking a fundamental and common understanding of DevOps principles. These might include employees, managers, stakeholders and suppliers who are leading or contributing to an organisation’s DevOps initiatives. Consultants who are guiding their clients through DevOps programs will also benefit greatly from a DevOps certification.

What are the DevOps certification levels?

The DevOps certification scheme currently consists of the following certifications:

DevOps Practitioner℠ series

The series of DevOps Practitioner courses supports IT roles for the modern enterprise. Each new DevOps certification course is focused towards continually addressing the emerging and growing needs of IT professionals and organisations worldwide. The new DevOps Practitioner series will include the following roles:

  • DevOps Leader℠ (DOL)
  • DevSecOps Engineer℠ (DSOE) - Coming soon!
  • DevOps Professional℠ (DO PRO) - Coming soon!

  • DevOps objectives and vocabulary
  • Benefits to the business
  • Concepts and practices — including its relationship to Agile, Lean and IT Service Management (ITSM)
  • Improved workflows
  • Improved communication and feedback loops
  • Reliance on automation
  • Applying DevOps in an enterprise environment
  • Critical success factors and key performance indicators
  • Real-life examples and results

Who is the DevOps Foundation® exam for

  • Individuals and organisations seeking a fundamental understanding of DevOps
  • Employees, managers, stakeholders and suppliers who are leading or contributing to an organisation’s DevOps initiatives
  • Consultants guiding their clients through DevOps programs and process improvement initiatives
  • Application and infrastructure providers whose products are part of the DevOps tool chain
  • Internal and external suppliers
  • Business stakeholders

Exam Details

Number of questions: 40 multiple choice questions
Pass mark: 65% (26 out of 40)
Open book/notes: no
Exam duration: 60 minutes (75 minutes if English is not a candidate’s native tongue)

DevOps 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.

DevOps Training Venue:

Are you located in any of these areas - Adyar, Mylapore, Nandanam, Nanganallur, Nungambakkam, OMR, Pallikaranai, Perungudi, Ambattur, Aminjikarai, Adambakkam, Anna Nagar, Anna Salai, Ashok Nagar, Besant Nagar, Choolaimedu, Chromepet, Medavakkam, Porur, Saidapet, Sholinganallur, St. Thomas Mount, T. Nagar, Tambaram, Teynampet, Thiruvanmiyur, Thoraipakkam,Vadapalani, Velachery, Egmore, Ekkattuthangal, Guindy, K.K.Nagar, Kilpauk, Kodambakkam, Madipakkam, Villivakkam, Virugambakkam and West Mambalam.

Our Adyar office is just few kilometre away from your location. If you need the best DevOps training in Chennai, driving couple of extra kilometres is worth it!

Rated as Best DevOps Training in Chennai. Call 89399-15577 to know more.

Fast track DevOps Training are also available.

DevOps Related Training Courses in Chennai

Linux Admin Training in Chennai

AWS Training


     

1.tell me ur roles and responsibilities
2. External table and table partitioning
3.in 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
Raja
Mani

Get output as raja,mani

1st round
1.Views
2.Index
3. difference between views and mviews
4.triggers
5.procedure
6.function
7.difference bw procedure and function
8. Difference bw joins and set operator
9 .joins types
10 cursor
11.exception
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.
17.constraints
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
2.how 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
2.do 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
8.how to insert bulk data
9.what is save exception
10.have u work with perform tunning
11.how 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
3.day to day activities
4.do you have experience in bulk collect, collection
5.do you have experience in creating table view constraints
6.in which place is your company.
7.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
8.
Salary table
Sal column:
15000
20000
14000
Write a query to get 1st name ,max of salary from salary table.

9. T1 table
A
B
A
B
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
C
O
M
P
L
E
X
E
D
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.

MSC TECHNOLOGY QUESTIONS

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
19.A
1
2
3
6
7
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
15.how will log file created
16.what is methodology ur using
17.in 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
A B
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
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
Hints
In u r project where u use index
Performance tuning
Do u know any Oracle packages
Triggers
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
5.how 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
11.how 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

TCS F2F

SQL

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?
5.how to delete duplicate records in a table?
6.diff between join and sub querys?
7.what is minus ?
8.how 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?

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

TCS interview questions:

SQL

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 record.how 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

Unix

1.ls
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.
6.how 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
3.sequence
4.cursor vs loop which is best
5. Where exception used in your project
6.is 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.
5.how can index increase the performance.
6.what is the view and mview.
7.about dbms_job.
8.explain trigger.
9.able 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
8.do u have support experience
9.are to convinient to work in this location
10.day to day activities

1.Project
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
7.how 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
9
Output like
1
2
3
4
5
7
10
19.group 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
101,102,103,104....)
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?
8.UTL_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?
16.Triggers.

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

Questions
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
12.how 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

     


Testimonials
best DevOps training center in chennai "I want to thank you for your incredible efforts and sharing your vast knowledge. I am feeling lucky to have attended your great batch. You are awesome Karthik, I am not sure when i will be able to attain 50% of your knowledge but i got a lot inspired by you. I will keep in touch and will always try to learn from you as much as I can. Thanks once again Karthik"

DevOps training chennai ""Dear Karthik, DevOps training has been outstanding. You have covered every aspect of the DevOps which would boost the confidence of the attendee to dive into greater depths and face the interviews subsequently. I feel confident after attending the DevOps course. I am sure you would be providing us your valuable high level guidence in our initial realtime project . Each of your session is a eye opener and it is a great joy to attend your DevOps training. Thanks and Kindest Regards ""

DevOps training classes in chennai "I thought I knew DevOps until I took this course. My company sent me here against my will. It was definitely worth and I found out how many things I was doing wrong. Karthik is awesome. but i got a lot inspired by you. I will keep in touch and will always try to learn from you as much as I can. Thanks once again Karthik"

Greens Technologys Overall Reviews


Greens Technologys Overall Reviews 5 out of 5 based on 17981 ratings. 17981 user reviews.
DevOps training chennai """I think this is the best DevOps course I have taken so far..Well I am still in the process of learning new things but for me this learning process has become so easy only after I joined this course..as Sajin is very organized and up to the point.. he knows what he is teaching and makes his point very clear by explaining numerous times. I would definitely recommend anyone who has any passion for Cloud.." ""