Learn Spoken English Training in Chennai at Greens Technologies – No 1 Spoken English Training Institute in Chennai. Call 89399-15577 for more details.
Greens Technologys offers Spoken English training in Chennai with certification and Real-World Solutions from Experienced Professionals on Spoken English.
We offer job assistance (subject to project availability and partner requirements) for positions in India, Singapore, Dubai and the UK.
There are many good reasons to learn English . There are more than 6,000 different languages spoken all over the world, but English is and will continue to be a common means of communication for speakers of all languages.
According to the most recent statistics, English is the mother tongue of more than 375 million people. English is the official language in 54 countries that cover Europe, the Americas, Africa, Asia, and Australasia, and which include countries as diverse as New Zealand, South Africa, Belize, India, Malta, and Singapore. This means that English is a truly universal language that makes communication across the globe easy and convenient.
In addition, English is the world's most popular second language choice. The British Council estimates that more than 1 billion people are learning English as a second language at any given time. English is taught at school as a second language in hundreds of countries all over the world, from France to Thailand, Israel to Malaysia, in Sweden, China, and in many other countries. Because English is taught all over the world, you will never feel alone during your learning process, and it will be very easy to find other English learners who can share their experiences with you during your wonderful journey through the world of spoken English class.
Joshua is an experienced English Language Educator and Corporate Trainer with a demonstrated history of working in the Education, Corporate and Publishing industry for over 15 years. Skilled in Corporate Communication, Strategic Planning, Course Design/Development, Coaching and Mentoring, Content Creation and Quality Enhancement and Team Management. I’ve delivered several training courses and workshops on Professional English, Business Communication, Academic English, English for Specific Purpose (ESP), Teacher Training, International Exams - Test Prep: IELTs, Cambridge IGCSE, SAT/ACT Test Prep - English Component. I’ve worked with client across India, Europe, Middle East, South East Asia, U.S. etc.
Joshua extensive experience in Training, Examining, and Materials Development gives my teaching sessions an approachable and practical style. I specialize in assisting firms with customized training courses built around difficulties that the learners face in communicating and operating effectively in culturally diverse contexts. Joshua teaching sessions follow a systematic approach, which focuses on learner needs and creative thinking.
I believe that a teacher does not only impart knowledge, but also part of oneself. Thus, teaching has also given me the chance to share my passion not only for English language, but also for drama, poetry, literature, music and dance. I, often, incorporate this in my training sessions thus creating a more holistic and fun session.
Flexible Timings / Weekend classes Available.Spoken English could be one of the best decisions that you ever make. Being fluent in English can help you in many ways, whether you are planning to travel, study in an English-speaking country, emigrate, or improve your career prospects. Think about the following:
To sum up, we live in a globalised world where only competent English speakers have the best opportunities to progress and get ahead in their personal and professional lives.
So you have decided to learn English as second language. Are you afraid of making mistakes? If you are, don't let your fears become an obstacle and stop you from achieving your goals. You're not alone: Language learners often make mistakes because they are influenced by their native language. The best strategy is to become familiar with the most common difficulties that you face when learning English as second language. This will help you avoid them and develop successful learning patterns.
Do you feel frustrated every time you try to communicate in English and people fail to understand you? It's possible that you are pronouncing certain sounds incorrectly. For example, English vowel sounds are notoriously difficult to master for speakers of languages like Spanish or Italian. Why? There are only 5 vowel sounds in Spanish, but there can be up to 20 vowel sounds in English. Chinese speakers may have problems pronouncing the different “r” sounds in English, and Arabic speakers find it difficult to pronounce the “p” sound, as it doesn't exist in their mother tongue.
Many learners transfer the grammatical patterns of their first language into English. For example, many Asian languages do not use articles (a, an, the), which results in incorrect sentences like “My mother is doctor”. Spanish speakers might translate directly from Spanish into English and say things like “I have 20 years old”. French speakers may have problems with word order and construct incorrect sentences like “I play sometimes football” or “he is your brother?”.
The incorrect use of vocabulary is another common challenge. English has dozens of “false friends': Words that are similar in your mother tongue and in English but which mean different things. For example, “piles” means batteries in French and the word also exists in English, but it doesn't mean batteries at all (it actually means hemorrhoids). Spanish speakers might misuse the word “sympathetic” (which means compassionate in English), thinking that it means the same as the Spanish word “simpatico” (friendly).
At Greens we believe that difficulties are opportunities to learn and we can help you improve your English language skills with our interactive learning methods and experienced native teachers.
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
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.
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?
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
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
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?
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?
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
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
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
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
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
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
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?
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
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
1.ls
2. Sed
3. Awk
4. Cat
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.
"The best thing about Greens Technology Spoken English training is ,The classes which I have attend was entirely hands on with practical examples. This gives a deeper understanding in subject. Sai! I am so delighted about the Big data course and I am surprised to see the depth of your knowledge in all aspects of the subject. I have seen many architects over 15+ years of experience doesn’t have the knowledge you have. I have really enjoyed your sessions, will definitely look forward to learn more from you in the future. Thanks again."
"Dear Sai, Spoken English training has been outstanding, you have covered each and every aspect of the Spoken English which would boost the confidence of the attendee to dive into greater depths and face the interviews subsequently. I feel confident after attending the Spoken English course. Each of your session is a eye opener and it is a great joy to attend your Spoken English class. Thanks and kindest regards"
5
out of 5
based on 17981 ratings.
17981 user reviews.
