Greens Technologys phone
Greens Technologys Whatsapp
Greens Technologys phone
Greens Technologys Whatsapp

JAVA and J2EE Training in Chennai


Learn Java Training In Chennai At Greens Technologys – No 1 Java Training Institute In Chennai. Call 89399-15577 For More Details. Register today for learning basic core Java Training to go for advanced J2EE Java Training in Chennai.


java training chennai

Learn JAVA from the best JAVA Training center in Chennai which offers complete JAVA training in Chennai with Placement by well experienced Java Certified Trainer having more than 12+ years of Real time Development experience using Java Technologies. We are proud to mention that we are the Best institutes to provide JAVA COMPLETE PRACTICAL REALTIME TRAINING and hence, closely working with various companies in India. We are, today, one of the few best training companies providing complete practical trainings on Java Technologies.


JAVA Training Course in Chennai


JAVA training course content is exclusively designed with Basics through Advanced Concepts. This Java courses in Chennai at Greens Technology branches is specifically designed as per the Java Official Curriculum (MOC) to provide COMPLETE PRACTICAL Training on Java Technologies.


  1. Core Java 7 Training
  2. Advanced Java Training
  3. J2EE Training
  4. Servlet Training
  5. JSP Training
  6. JSF Training
  7. Struts framework
  8. EJB Training
  9. Hibernate Framework
  10. Spring Framework
  11. Live Project as in real time environment following all SDLC Principles


Java Training In Chennai Course Syllabus


This Java SE 8 Programming training covers the core language features and Application Programming Interfaces (API) you will use to design object-oriented applications with Java Standard Edition 8 (Java SE 8) Platform. Use this Java course to further develop your skills with the Java language and prepare for the Oracle Certified Professional, Java SE 8 Programmer Exam!


Java Platform Overview


  • Introductions
  • Course Schedule
  • Java Overview
  • Java Platforms
  • OpenJDK
  • Licensing
  • Java in Server Environments
  • The Java Community Process

    • Java Syntax and Class Review


      • Simple Java classes
      • Java fields, constructors and methods
      • Model objects using Java classes
      • Package and import statements

        • Encapsulation and Polymorphism


          • Encapsulation in Java class design
          • Model business problems with Java classes
          • Immutability
          • Subclassing
          • Overloading methods
          • Variable argument methods

            • Java Class Design


              • Access modifiers: private, protected and public
              • Method overriding
              • Constructor overloading
              • The instanceof operator
              • Virtual method invocation
              • Polymorphism
              • Casting object references
              • Overriding Object methods

                • Advanced Class Design


                  • Abstract classes and type generalization
                  • The static and final modifiers
                  • Field modifier best practices
                  • The Singleton design pattern
                  • Designing abstract classes
                  • Nested classes
                  • Enumerated types

                    • Inheritance with Java Interfaces


                      • Java Interfaces
                      • Types of Inheritance
                      • Object composition and method delegation
                      • Implementing multiple interfaces
                      • The DAO design pattern

                        • Generics and Collections


                          • Generic classes and type parameters
                          • Type inference (diamond)
                          • Collections and generics
                          • List, set and Map
                          • Stack and Deque

                            • String processing


                              • String manipulation with StringBuilder and StringBuffer
                              • Essential String methods
                              • Text parsing in Java
                              • Input processing with Scanner
                              • Text output and formatting
                              • Regular expressions with the Pattern and Matcher classes

                                • Exceptions and Assertions


                                  • Exceptions categories
                                  • Standard Java Exception classes
                                  • Creating your own Exception classes
                                  • Using try-catch and the finally clause
                                  • Using try-with-resources and the AutoCloseable interface
                                  • The multi-catch feature
                                  • Best practices using exceptions
                                  • Assertions

                                    • I/O Fundamentals


                                      • I/O using Java
                                      • Reading the console input stream
                                      • Writing to the console
                                      • Using I/O Streams
                                      • Chaining I/O Streams
                                      • Channel I/O
                                      • Reading and writing objects using Serialization

                                        • File I/O with NIO 2


                                          • The Path interface
                                          • The Files class
                                          • Directory and File operations
                                          • Managing file system attributes
                                          • Reading, writing, and creating files
                                          • Watching for file system changes

                                            • Threading


                                              • Operating system task scheduling
                                              • Recognizing multithreaded environments
                                              • Creating multi-threaded solutions
                                              • Sharing data across threads
                                              • Synchronization and Deadlock
                                              • Immutable objects

                                                • Concurrency


                                                  • Creating Atomic variables
                                                  • Using Read-Write Locks
                                                  • Thread-safe collections
                                                  • Concurrenct synchronizers (Semaphore, Phaser, and others)
                                                  • Executors and ThreadPools to concurrently schedule tasks
                                                  • Parallelism and the Fork-Join framework

                                                    • Database Application with JDBC


                                                      • Layout of the JDBC API
                                                      • JDBC divers
                                                      • Queries and results
                                                      • PreparedStatement and CallableStatement
                                                      • Transactions
                                                      • RowSet 1.1 RowSetProvider and RowSetFactory
                                                      • The DAO Pattern and JDBC

                                                        • Localization


                                                          • Advantages of localization
                                                          • Defining locale
                                                          • Read and set locale using the Locale object
                                                          • Resource bundles
                                                          • Format messages, dates and numbers

                                                          About Instructor:
                                                          - Madhavan work as an Java Consultant & Instructor, He has over 10+ years of Java experience and recognized expert in Struts,Servlet,JSP,Ajax,Hibernate,EJB, Design Patterns and contributing to the best Java training in Chennai.
                                                          Mr. Madhavan specializes in Java and J2EE

                                                          - He is also been as Senior Instructor of Oracle University and provided 120 Corporate trainings, trained 4500 corporate & fresher employees.

                                                          He is among few of the Java Certified Master in the World to achieve below certifications in his area of research.
                                                          - Java SE 7 Programmer I 1Z0-803
                                                          - Java SE 8 Programmer II 1Z0-809
                                                          - Java SE 6 Developer Certified Master Assignment 1Z0-855


                                                          Our Java Training

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

                                                          All our trainings focuses on practical than theory model. We provide hands-on training experience which helps you Design and direct the project, including data quality and testing easily at the end of the training program.

                                                          Our retail batch strength is 5 / 6 and so we will be able to provide individual attention. We will guide you till completing your certifications and many students have cleared with 100% score.

                                                          Java Placement Training

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

                                                          Talk to the Trainer @ +91-89399 15577


                                                          What Will You Learn From Java Training In Chennai?

                                                          We are committed to provide Complete PRACTICAL Training and Java Certification Training exclusively on JAVA and J2EE. Study Material and Practice Material included with the course.


                                                          Recommended by Students as No 1 JAVA Training Institute in Chennai!


                                                          JAVA Certification Training

                                                          We have been training students since the certification has been introduced and every student has been able to clear the exam successfully(quite a few have even topped the exam with 100% score).


                                                          Oracle Certified Associate, Java SE 8 Programmer I 1Z0-808
                                                          Oracle Certified Professional, Java SE 8 Programmer II 1Z0-809


                                                          Java Basics


                                                          • Define the scope of variables
                                                          • Define the structure of a Java class
                                                          • Create executable Java applications with a main method
                                                          • Import other Java packages to make them accessible in your code

                                                            • Working With Java Data Types


                                                              • Declare and initialize variables
                                                              • Differentiate between object reference variables and primitive variables
                                                              • Read or write to object fields
                                                              • Explain an Object's Lifecycle (creation, "dereference" and garbage collection)
                                                              • Call methods on objects
                                                              • Manipulate data using the StringBuilder class and its methods
                                                              • Creating and manipulating Strings

                                                                • Using Operators and Decision Constructs


                                                                  • Use Java operators
                                                                  • Use parenthesis to override operator precedence
                                                                  • Test equality between Strings and other objects using == and equals ()
                                                                  • Create if and if/else constructs
                                                                  • Use a switch statement

                                                                    • Creating and Using Arrays


                                                                      • Declare, instantiate, initialize and use a one-dimensional array
                                                                      • Declare, instantiate, initialize and use multi-dimensional array
                                                                      • Declare and use an ArrayList

                                                                        • Using Loop Constructs


                                                                          • Create and use while loops
                                                                          • Create and use for loops including the enhanced for loop
                                                                          • Create and use do/while loops
                                                                          • Compare loop constructs
                                                                          • Use break and continue

                                                                            • Working with Methods and Encapsulation


                                                                              • Create methods with arguments and return values
                                                                              • Apply the static keyword to methods and fields
                                                                              • Create an overloaded method
                                                                              • Differentiate between default and user defined constructors
                                                                              • Create and overload constructors
                                                                              • Apply access modifiers
                                                                              • Apply encapsulation principles to a class
                                                                              • Determine the effect upon object references and primitive values when they are passed into methods that change the values

                                                                                • Working with Inheritance


                                                                                  • Implement inheritance
                                                                                  • Develop code that demonstrates the use of polymorphism
                                                                                  • Differentiate between the type of a reference and the type of an object
                                                                                  • Determine when casting is necessary
                                                                                  • Use super and this to access objects and constructors
                                                                                  • Use abstract classes and interfaces

                                                                                    • Handling Exceptions


                                                                                      • Differentiate among checked exceptions, RuntimeExceptions and Errors
                                                                                      • Create a try-catch block and determine how exceptions alter normal program flow
                                                                                      • Describe what Exceptions are used for in Java
                                                                                      • Invoke a method that throws an exception
                                                                                      • Recognize common exception classes and categories

                                                                                      Java Class Design


                                                                                      • Implement encapsulation
                                                                                      • Implement inheritance including visibility modifiers and composition
                                                                                      • Implement polymorphism
                                                                                      • Override hashCode, equals, and toString methods from Object class
                                                                                      • Create and use singleton classes and immutable classes
                                                                                      • Develop code that uses static keyword on initialize blocks, variables, methods, and classes

                                                                                      Advanced Java Class Design


                                                                                      • Develop code that uses abstract classes and methods
                                                                                      • Develop code that uses the final keyword
                                                                                      • Create inner classes including static inner class, local class, nested class, and anonymous inner class
                                                                                      • Use enumerated types including methods, and constructors in an enum type
                                                                                      • Develop code that declares, implements and/or extends interfaces and use the @Override annotation.
                                                                                      • Create and use Lambda expressions

                                                                                      Generics and Collections


                                                                                      • Create and use a generic class
                                                                                      • Create and use ArrayList, TreeSet, TreeMap, and ArrayDeque objects
                                                                                      • Use java.util.Comparator and java.lang.Comparable interfaces
                                                                                      • Collections Streams and Filters
                                                                                      • Iterate using forEach methods of Streams and List
                                                                                      • Describe Stream interface and Stream pipeline
                                                                                      • Filter a collection by using lambda expressions
                                                                                      • Use method references with Streams

                                                                                      Lambda Built-in Functional Interfaces


                                                                                      • Use the built-in interfaces included in the java.util.function package such as Predicate, Consumer, Function, and Supplier
                                                                                      • Develop code that uses primitive versions of functional interfaces
                                                                                      • Develop code that uses binary versions of functional interfaces
                                                                                      • Develop code that uses the UnaryOperator interface

                                                                                      Java Stream API


                                                                                      • Develop code to extract data from an object using peek() and map() methods including primitive versions of the map() method
                                                                                      • Search for data by using search methods of the Stream classes including findFirst, findAny, anyMatch, allMatch, noneMatch
                                                                                      • Develop code that uses the Optional class
                                                                                      • Develop code that uses Stream data methods and calculation methods
                                                                                      • Sort a collection using Stream API
                                                                                      • Save results to a collection using the collect method and group/partition data using the Collectors class
                                                                                      • Use flatMap() methods in the Stream API

                                                                                      Exceptions and Assertions


                                                                                      • Use try-catch and throw statements
                                                                                      • Use catch, multi-catch, and finally clauses
                                                                                      • Use Autoclose resources with a try-with-resources statement
                                                                                      • Create custom exceptions and Auto-closeable resources
                                                                                      • Test invariants by using assertions

                                                                                      Use Java SE 8 Date/Time API


                                                                                      • Create and manage date-based and time-based events including a combination of date and time into a single object using LocalDate, LocalTime, LocalDateTime, Instant, Period, and Duration
                                                                                      • Work with dates and times across timezones and manage changes resulting from daylight savings including Format date and times values
                                                                                      • Define and create and manage date-based and time-based events using Instant, Period, Duration, and TemporalUnit

                                                                                      Java I/O Fundamentals


                                                                                      • Read and write data from the console
                                                                                      • Use BufferedReader, BufferedWriter, File, FileReader, FileWriter, FileInputStream, FileOutputStream, ObjectOutputStream, ObjectInputStream, and PrintWriter in the java.io package.

                                                                                      Java File I/O (NIO.2)


                                                                                      • Use Path interface to operate on file and directory paths
                                                                                      • Use Files class to check, read, delete, copy, move, manage metadata of a file or directory
                                                                                      • Use Stream API with NIO.2

                                                                                      Java Concurrency


                                                                                      • Create worker threads using Runnable, Callable and use an ExecutorService to concurrently execute tasks
                                                                                      • Identify potential threading problems among deadlock, starvation, livelock, and race conditions
                                                                                      • Use synchronized keyword and java.util.concurrent.atomic package to control the order of thread execution
                                                                                      • Use java.util.concurrent collections and classes including CyclicBarrier and CopyOnWriteArrayList
                                                                                      • Use parallel Fork/Join Framework
                                                                                      • Use parallel Streams including reduction, decomposition, merging processes, pipelines and performance.

                                                                                      Building Database Applications with JDBC


                                                                                      • Describe the interfaces that make up the core of the JDBC API including the Driver, Connection, Statement, and ResultSet interfaces and their relationship to provider implementations
                                                                                      • Identify the components required to connect to a database using the DriverManager class including the JDBC URL
                                                                                      • Submit queries and read results from the database including creating statements, returning result sets, iterating through the results, and properly closing result sets, statements, and connections

                                                                                      Localization


                                                                                      • Read and set the locale by using the Locale object
                                                                                      • Create and read a Properties file
                                                                                      • Build a resource bundle for each locale and load a resource bundle in an application

                                                                                      Java training Chennai Reviews from Urvashi


                                                                                      Java training chennai

                                                                                      Madhavan Sir! I am really delighted about the Java course and i am surprised to see the depth of your knowledge in all aspects of the Java. I see that many architect 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 Java training in Chennai Reviews from Chetan


                                                                                      Java training chennai

                                                                                      I attended Java training at greens technologys OMR. The ambience is apt for studying, a calm environment. Our trainer was Madhavan Sir, he was very clear in communicating all the basic concepts for a strong foundation and cleared all doubts patiently. The course was completed within the stipulated time as promised in the beginning. The administrators were friendly and receptive, prompt action for any request/queries. Overall, it was a good experience to get trained there. I recommend Greens Technologies to anyone wanting to study Java course in Chennai.


                                                                                      Java training Reviews from Anitha


                                                                                      Java training chennai

                                                                                      I was looking out for institutions to learn Android and Java, many Institute names came up when I Google. I attended few demo classes from other institutions but when I came to Greens Technologies adyar the faculty understood my situation correctly and advised me what to do exactly to improve my career. Coming to important aspect of Greens Technologies is the flexibility, the staffs are so understanding that they arrange class the time I'm flexible. The another interesting factor is the teaching I had one on one teaching for Java it was incredibly useful. I had good time learning Java and Android through Greens Technologies.. Highly recommend those who want to learn new technologies.



                                                                                      Do not wait anymore! Call Us @ 89399-15577 to know more about JAVA J2EE Training in Chennai. You can also contact us by submitting the Quick Enquiry form on the right side of this page to know more about the JAVA Course in Chennai.



                                                                                      What is the role of the product support engineer in Unix PLSQL?


                                                                                      A Production Support Analyst is responsible for maintaining and supporting the systems and applications used by specific sets of users within an organisation.

                                                                                      Production support engineer in Unix PLSQL - Meaning supporting a system product/Application written in PLSQL language on Unix platform.

                                                                                      A production support engineer is effectively the front face of the application and provides the first line of contact to the users.

                                                                                      They are responsible for monitoring and alerting, along with major incident management and implementing changes to the production environment.


                                                                                      Production support is categorized the levels of support as L1, L2 and L3 :


                                                                                      L1 team checks the status of the deployed applications, make calls to the product users to get clarifications / convey resolutions on the production issues. They also create weekly reports needed by different teams.

                                                                                      L2 team were responsible to identify the root cause of the issues, work on the tickets created and classify the tickets (such as code fix required, deployment issues, etc.).

                                                                                      L3 team were fixing the code fix issues and giving support for any critical issues when needed - constituted of developers of the application.

                                                                                      A production support team member gets to learn a lot about entire flow of application.One can learn the “domain” in depth because the work involves a lot of exploration of Functional Solution Documents.




                                                                                      Production support as the name says is about Supporting the production environment of the company. This job needs a responsible person who can take responsibility of the production environment. Responsibility of a person working on Production support are:

                                                                                       

                                                                                      Monitoring: He/She would have to monitor the system very closely and can not afford to leave the system without someone else monitoring it. It is a 24*7 job defined within a team to work in shifts.

                                                                                       

                                                                                      On Call Support: As it is as 24*7 responsibility. In case if some issue occurs after working hours then He/she would have to be available to resolve the issue on priority.

                                                                                       

                                                                                      P1, P2, P3 Priority Issues: Issues are raised based on the priorities. P1>P2>P3… P1 has very tight timeline to resolve the issue as It means the Business is down with this issue and it needs to be fixed at priority as It would be impacting business and would cause the monetary loss to the company.

                                                                                       

                                                                                      Categorization of Issues: Report needs to be created to check what are the frequent issues we are getting and what is reason for that and If it can be resolved with some code changes so that such kind of issue do not originate in future.

                                                                                       

                                                                                      SOP Document: SOP document needs to be created. This document lists the regular issues coming and steps needs to be taken to resolve such issues. SOP document then shared with the L1 Support team so that they can resolve the issue at their end by following the steps mentioned in the document.

                                                                                       

                                                                                      Deployments: Support teams remain part of the deployments along with development team so that they will be familiar with changes that are getting deployed to the production as they would have to support the Application after it gets deployed to the Production.

                                                                                       

                                                                                      L1, L2, L3 : Support is Categorized to L1, L2 and L3 Support.

                                                                                       

                                                                                      L1: L1 team is the first point of contact when someone raises the issue. You can say Customer support team is the L1 Support whom the person contacts when he faces any issue in the product. They check information and get back to the Customer.

                                                                                       

                                                                                      L2: If issue is not getting resolved by the L1 support then that issue gets passed to the L2 Support. L2 Support check configuration and other things which can help in resolving the issue.

                                                                                       

                                                                                      L3: In case if L2 team also not able to resolve the issue and Issue might need some code changes then Issue gets transferred to the L3 Support team. L3 Support team is a technical team which works on the change requests and maintenance of the Application.


                                                                                      What is difference between testing environment and staging?

                                                                                       

                                                                                      A testing environment is an environment where you can test any change or bug fix before forwarding it into your release. It is considered a best practice to have multiple testing environments. Even a Dev environment is a testing environment, which is more like a whiteboard for developers to make a change and perform unit testing onto the code.


                                                                                      A Staging environment is also a testing environment but is dedicated to QA or software testers. Some would say “it is a copy of production”.”An environment similar to prod but without any customer.” I define it as a mirror environment meant to mimic production as precisely as possible for quality assurance. I consider it to be a Goalkeeper, standing tall as the last line of defence between the bugs brought in by the recent release process and the production environment.


                                                                                      And before you ask, Yes, staging environment should have a complete simulated copy of databases as well.

                                                                                      If you have used XAMPP than it also creates a testing environment by hosting your website on Apache web server.


                                                                                      To have a detailed understanding, have a look at best practices for Software Testing.


                                                                                      Most of the times a web-app workflow comprises of 3 environments dedicating one for each team: Dev, QA a.k.a Staging & Prod in your release workflow.


                                                                                      Workflow:


                                                                                      Developers are free to apply fix on existing bugs in any way they deem efficient in the local Dev environment.
                                                                                      Developers perform unit testing for the validation of the latest feature implemented by them.
                                                                                      Once unit testing is successful, the feature is pipelined into Staging or QA for testing and quality assurance.
                                                                                      Staging is where regression testing takes place to make sure that recent features are applying a fix to the problems without disturbing any other functionality of the existing application.
                                                                                      Release date arrives and the features who passed with flying colours in the Staging environment are migrated to Production.
                                                                                      Now that we have a good understanding of the workflow. It is time to deep-dive on best practices.
                                                                                      DEV LOCAL Environment – DEV environment allows developers to make code changes into the application for fixing an existing bug. Once the fix is applied it is unit tested by the developer. We already know by now that testers are not advised to perform testing in DEV.

                                                                                      Integration Testing Environment – When different bug fixes related to different modules are done with successful unit testing then integration testing is performed. This environment is where all different modules are integrated and hit with a plethora of test cases to bring the code up to speed after integration.

                                                                                      SANDBOX – They say “Necessity is the mother of innovation”. This playground for developers is where innovation rises in form of code to meet the necessity. This is of no use to a tester.

                                                                                      STAGING Environment – By far I hope you are pretty aware of what it does. A pre-prod deployment area that serves a quality assurance check by providing a platform almost identical to Production. Sometimes when we are in a hurry to deploy immediate fixes, we tend to miss them out on this environment after integration testing. This is not a good practice. Make sure you migrate everything and test into Staging to be safe. Remember, staging is the closest twin to prod.

                                                                                       

                                                                                      PARTIAL PRODUCTION ROLLOUT – Develop a rollout plan for thorough testing in Production, including the following mentioned major areas related to code migration:

                                                                                      Canarying
                                                                                      Monitoring
                                                                                      Exploration
                                                                                      Distributed Tracing
                                                                                      Dynamic Instrumentation
                                                                                      Feature Flagging
                                                                                      Exception Tracking
                                                                                      Traffic Shaping
                                                                                      A/B Testing
                                                                                      Chaos Testing
                                                                                      Profiling
                                                                                      Teeing
                                                                                      Load Testing
                                                                                      Shadowing
                                                                                      Load Testing
                                                                                      Usability Testing
                                                                                      Cross Browser Testing
                                                                                      Accessibility Testing


                                                                                      Production – After validation in the QA environment, you push your changes to Prod. Go-live environment that is used by your customers. This environment is not to be messed with! Developers without proper approvals cannot implement any change in it, not even a minor fix is advised without a relevant sign-off.

                                                                                      Disaster Recovery – This is where you keep a backup ready of your Production before making any change into it. If things go south you can execute a rollback to the previous version in a fly.

                                                                                      But you can’t always roll back! For instance, If you are coming up with a release that brings with it a new database structure which is conflicts with your previous release associated database then rolling back would be catastrophic and may even shatter your application.

                                                                                      Hope this clarifies your ambiguity on the difference between a testing and a staging environment. Long story short, there are plenty of testing environments in a release cycle but there will be only one Staging environment. Every Staging environment is a testing environment, however, vice-versa is not true.




                                                                                      3i infotech interview questions


                                                                                      1. Self introduction
                                                                                      2. Day to day activities
                                                                                      3. Procedure
                                                                                      4. Triggers n were it was use
                                                                                      5. Diff views n materialized views
                                                                                      6. Indexes types n give some examples
                                                                                      7. Bulk collect n forall save exceptions give example
                                                                                      8. Analytical fns
                                                                                      9. Diff sql loader n external table
                                                                                      10. Ddl, dml, dcl
                                                                                      11. Pragma autonomous
                                                                                      12. List 11g, 12c
                                                                                      13. Performance tuning
                                                                                      14. Give ex of Last development for ur project
                                                                                      15. Follows Clause



                                                                                      3i infotech interview questions


                                                                                      1.tell about yourself. 

                                                                                      2.explain your project.     

                                                                                      3.how many procedure in your projects.   

                                                                                      4.different between view and mview.             

                                                                                      5.which view is fast access. 

                                                                                      6.mview refresh methods and which one fast access. 

                                                                                      7.explain about cursor.       

                                                                                      8.write a program in implict and explicit cursor with using data manipulation. 

                                                                                      9.write trigger and where you used trigger in your project.               

                                                                                      10.explain about expection.

                                                                                      11.what are the performance tunning used in your project.       

                                                                                      12.explain about table fragmentation. 

                                                                                      13.explain about table partition and what are the types and which one used in your project.   

                                                                                      14.which life cycle model used in your project. 

                                                                                      15.sql loader two types of methods.       

                                                                                      16.I have one column added in my table how to change procedure     

                                                                                      17.explain about refcursor.   

                                                                                      18.Where you used refcursor in your project.       

                                                                                      19.roles and responsibility in your project




                                                                                      3i infotech interview questions


                                                                                      1. Tell me about yourself?
                                                                                      2. Your project experience?
                                                                                      What is ur roll in your project?
                                                                                      3. How good r u in plsql out or 5?
                                                                                      4. Where do you created package in your last project and why you used package for that?
                                                                                      5. Same for procedure, function and dynamic sql. Where and why?
                                                                                      6. Materialized view?
                                                                                      7. D/b view and materialized view?
                                                                                      8. Why should we use materialized view?
                                                                                      9. Why u r switching from your previous company?


                                                                                      Oracle Pl/sql Developer


                                                                                      Intellect Design Arena Limited


                                                                                      1 - 9 yrs : Chennai

                                                                                       

                                                                                      Job Description


                                                                                          1.Candidate should have hands on experience in Pl/sql development. 

                                                                                       

                                                                                          2. Have sound working knowledge in Oralce Cursors, Oracle Types & Collections. 

                                                                                       

                                                                                          3. Good knowledge in Sql queries. Exposure in handling Large objects.

                                                                                       

                                                                                          4. Have exposure in handling performance related issue and quick analysis skills.

                                                                                       

                                                                                          5. Good knowledge in XML file type handling & parsing the xml files & CSV file handling is preferable.

                                                                                       

                                                                                          6. Good DB Design skills is also preferable but not mandatory.

                                                                                       

                                                                                       
                                                                                      NOTE : Banking domain exposure is preferred

                                                                                       

                                                                                      Salary:  Not Disclosed by Recruiter

                                                                                      IndustryBanking / Financial Services  / Broking

                                                                                      Functional Area: IT Software - Other

                                                                                      Role Category: Programming & Design

                                                                                      Role: Software Developer

                                                                                      Employment Type: Permanent Job, Full Time

                                                                                       

                                                                                      Keyskills

                                                                                       

                                                                                      SQL Development
                                                                                      PLSQL
                                                                                      Database Design
                                                                                      Parsing
                                                                                      XML
                                                                                      SQL
                                                                                      Queries
                                                                                      oracle queries
                                                                                      Oracle SQL
                                                                                      pl
                                                                                      sql
                                                                                       

                                                                                      Desired Candidate Profile

                                                                                       

                                                                                        Please refer to the Job description above

                                                                                      Company Profile:

                                                                                       

                                                                                      Intellect Design Arena Limited

                                                                                      Intellect Design Arena Ltd, is a global leader in Financial Technology for Banking, Insurance and other Financial Services. A uniquely focused Products business, the $136 million Intellect Design Arena, is a specialist in applying true Digital Technologies and designing advanced technology products for global financial platforms. Across global consumer banking (iGCB), Central Banking, Risk, Treasury & Markets (iRTM), Global Transaction Banking (iGTB) and Insurance (Intellect SEEC), Intellect provides full spectrum, fully integrated products that run in over 200 financial institutions, across 30 countries. To know more visit us: www.intellectdesign.com

                                                                                      Contact Details


                                                                                      Email id : geetha.thyagarajan@intellectdesign.com


                                                                                      Plsql Developer

                                                                                      2 - 6 Years : Chennai

                                                                                      INR 2,00,000 - 7,00,000 P.A.    Openings: 10


                                                                                      Job Description


                                                                                      Experience in Oracle PLSQL Development.

                                                                                      Stored procedures, functions, triggers, tables, indexes, etc.

                                                                                      Writing SQL queries.

                                                                                      kindly apply if looking for a job activeli 15 days or less joiners preferred.

                                                                                      Kindly drop a mail to .

                                                                                      santhoshh@cbsiglobal.com /080-4025 4398

                                                                                      Regards,

                                                                                      santhosh Henry 

                                                                                      TAG CBSI


                                                                                      Salary: INR 2,00,000 - 7,00,000 P.A.

                                                                                      Industry: IT-Software / Software Services

                                                                                      Functional Area: IT Software - Application Programming, Maintenance

                                                                                      Role Category: Programming & Design

                                                                                      Role: Software Developer

                                                                                      Employment Type: Permanent Job, Full Time

                                                                                      Keyskills:
                                                                                       
                                                                                      PLSQL

                                                                                      Company Profile


                                                                                      CBSI India Pvt. Ltd.

                                                                                      CBSI INDIA is a technology enterprise established in MI - USA in the year 1998. We offer enterprise software services to medium and large organizations. We have our presence in the US, Brazil, Hong Kong, China, Singapore and in India. We are a $100 million turnover company with about 2500 employees working with us. 

                                                                                      CBSI INDIA is focused on enterprise applications, mobile applications and cloud enablement. We work as a technology partner to transform business and deliver measurable results. Our professional services team deploys technology professional to our client projects and fulfill their project staffing needs on long term engagements. CBSI INDIA is dedicated to provide its customers with the best possible service. 

                                                                                      CBSI INDIA has deployed several thousand top notch technical professionals to many fortune 500 companies in India. We are recognized as one of the primary global partners / core software service partner by our clients.

                                                                                      Oracle AWR Reports for Dummies


                                                                                      Life is really simple, but we insist on making it complicated. ― Confucius

                                                                                      Introduced in Oracle 10g and having evolved from the Statspack functionality of Oracle 8i/9i, the Automatic Workload Repository report or AWR report (as it is more commonly known as) is a vital tool to collect historical performance statistics of an Oracle Database by DBAs and System Performance engineers. An AWR report is primarily useful in gathering data on the Wait Events, Active Session History (ASH) Statistics, Object Usage Statistics and Resource hungry SQL Queries, which together help in identifying, analyzing and resolving performance bottlenecks of the database. Apart from this, ADDM (Automatic Database Diagnostic Monitor), the self-diagnosis utility of Oracle DB relies on the stats contained in AWR reports for accurately identifying root causes of performance issues. The AWR report in itself runs into hundreds of metrics and can be quite overwhelming to analyze at once, for someone not making a living out of doing so! This article is intended to call out the most important sections from the report as listed below, for drilling down the performance bottlenecks and fixing them fast. (For an advanced user, this can be clubbed with the recommendations from the advisory sections towards the end of an AWR report and ADDM report recommendations for getting an in-depth information of DB health, both of which are beyond the scope of this article).


                                                                                      DB/Host/Snapshot Details: The topmost part of AWR contains a row indicating DB Name, Instance Name, Startup Time and if the DB is RAC enabled, followed by a row containing Host Configuration details like Host Name, OS Platform, number of CPUs/Cores and total memory available in GB. This is followed by the Snapshot details which basically indicate the start and end of the time interval represented in the report and the time elapsed between them. Elapsed DB Time takes into consideration the cumulative time elapsed for all the CPU cores and hence is usually greater than the actual elapsed time on clock, for a multi core system. Also, by default snapshots of the relevant data are taken every hour and retained for 7 days in an Oracle DB, but this can be altered as per need.




                                                                                      2. Load Profile: The first row in this table i.e. DB Time per second is the ratio of Elapsed DB Time to elapsed Clock time as listed in the Snapshot details section, while DB CPU per second indicates average number of CPU cores in use per second. Ideally this value should be less than the total number of CPU cores available for most of the time in order for the DB to perform well. Next metric to look for in this section is the ratio of Hard Parses and Parses, which should not be much higher when compared to the baseline report, as it indicates potential issues with cursor management and bind variables (More on Parsing). High hard parse rates cause serious performance issues. A high hard parse rate is usually accompanied by latch contention on the shared pool and library cache latches. Frequent hard parses are caused by inadequately sized shared pool and ineffective utilization of bind variables.




                                                                                      3. Instance Level Statistics: All the metrics in this section like Buffer Hit % (% of times a particular block was found in buffer cache instead of performing a physical I/O (reading from disk), buffer Nowait% and Latch Hit % are targeted at 100% for best performance. % Non-Parse CPU indicates percentage of CPU time spent in non-parsing activities which is preferred to be on the higher side for better DB performance, since parsing is CPU intensive. Also, the execute to parse ratio should be very high in an ideal situation.




                                                                                      4. Top 5 Timed Events: This is the most important table to consider when identifying potential bottlenecks. The last column Wait Class if having the value "Concurrency" indicates serious issues. Also, the Average wait time in fourth column should be noticed for alarmingly high values when compared to the other events listed. The fifth column %DB Time or %Total Call Time denotes the percentage of total DB time spent on the corresponding event and ideally DB CPU should be taking the major chunk of it. If not, then the corresponding event (say X) needs to be investigated further. For this, one can click on SQL Statistics link in the Main Report Section and click on the 'SQL Ordered by' link closest to the wait event (X) identified earlier. The obtained table can be used to drill down the SQL Statements using the maximum of the identified resource (X) for further optimization.




                                                                                      5. Shared Pool Statistics: Indicates percentage usage of memory allocated to the shared pool and the percent of SQLs with execution count > 1. Extremely high percent usage of Shared pool indicates a need for increasing the shared pool size while a very low utilization indicates a larger than required pool size for the given workload. Also, the percent of SQL with executions > 1, should be near to 100 for effective utilization of shared SQL statements. If not so, this indicates ineffective utilization of bind variables.




                                                                                      6. Time Model Statistics: This section provides a summary of components where the database is spending it's time. The table contains system resource consumption metrics, which can be ordered by Time (s) and % of DB Time. One has to look for the statistic taking maximum % of DB time and compare it with baseline for any abnormal behavior. If SQL time>>DB CPU time then the system needs to be diagnosed for I/O issues. Also, as stated earlier, hard parse time is an important metric to watch for and compare with baseline.




                                                                                      7. OS Details: Lists the CPU Utilization breakup across system, user, busy, iowait and idle along with load statistics.




                                                                                      8. SQL Statistics: This section gives the option of sorting all the SQL Queries executed in desired fashion like 'SQL ordered by elapsed Time', 'SQL ordered by CPU Time' etc. Any query figuring in top five of two or more sorted lists is a definite candidate for tuning. This section when used in combination with 'Top 5 Timed events', is the most vital and fastest way to identify the bottleneck from an AWR Report. More specifically, a query with less number of executions and high value of 'Elapsed Time per Exec (s) ' should be a prime suspect. Similarly, in case of a high CPU Utilization observed on the DB, one should check for queries with highest 'CPU per exec(s)' and low execution count and target them for optimization.




                                                                                      Appendix


                                                                                      • Baseline: A statistical baseline is collection of statistic rates usually taken over time period where the system is performing well at peak load. Comparing statistics captured during a period of bad performance to a baseline helps discover specific statistics that have increased significantly and could be the cause of the problem. A baseline should ideally be taken at times of peak load and good performance.

                                                                                       

                                                                                      • Latching: Latches are a lightweight serialization mechanism that is used to single-thread access to internal Oracle structures.

                                                                                       

                                                                                      • ADDM: ADDM is a self diagnostic engine designed to analyze AWR data automatically after an AWR snapshot while making specific performance recommendations.



                                                                                      Indusland bank:


                                                                                      1.what is the role in your project
                                                                                      2.what is function and its types
                                                                                      3.what is sequence and where u used
                                                                                      4.index and its type of index.explain function based index with example
                                                                                      5.1000th line of coding u have an error .what u can do?
                                                                                      6.query slowness what u can do?




                                                                                      My questions are .. Indusland bank


                                                                                      1. Tell about urself and project
                                                                                      2. What are fix u done in tunning
                                                                                      3. What are analysis u done..
                                                                                      4. To whom u get instructions to done fix and analysis.
                                                                                      5. Most frequent bug u attend in project..
                                                                                      6. Tell about ur SLA..
                                                                                      7. Where u use virtual coloum in project and syntax
                                                                                      8. What are index u use in project..with syntax
                                                                                      9. Why we use composite index.
                                                                                      10. Where trigger use in project.
                                                                                      11. What is issue overcome in compound trigger in ur project..
                                                                                      12. What need of mview in ur project.
                                                                                      13. Why u prefer sequence in ur project...
                                                                                      14. possible to get function call with in procedure and how ..


                                                                                      INDUS Interview Questions.


                                                                                      1. About yourself.
                                                                                      2. About Project.
                                                                                      3. Analytical Function.
                                                                                      4. Joins
                                                                                      5.Functions.
                                                                                      6. Create procedure inside the trigger.
                                                                                      7. View & Materialized view.
                                                                                      8. Performance Tuning.


                                                                                      Interview Questions


                                                                                      1.About your project/Day to Day Activities

                                                                                      2.Identifying duplicates and Deleting duplicates
                                                                                      Ans : delete from emp where rowid not in (select max(rowid) from emp group by empid);

                                                                                      Ans :delete from emp a where rowid not in (select max(rowid) from emp b where b.empid=a.empid);

                                                                                      Ans : select department_id , count(department_id) from employees group by department_id having count(department_id) >1

                                                                                      3.2nd maximum salary

                                                                                      Ans : with w as (select first_name , salary , dense_rank() over(order by salary
                                                                                      desc) as rnk from employees ) select * from w where rnk=2;

                                                                                      Ans : select * from (select first_name , salary , dense_rank() over(order by salary
                                                                                      desc) as rnk from employees) where rnk = 2;

                                                                                      Ans : select max(salary) from employees where salary <> ( select max(salary) from employees );

                                                                                      Department wise maximum salary

                                                                                      Ans : with w as (select first_name , salary ,department_id, dense_rank() over(partition by department_id order by salary desc) as rnk from employees )
                                                                                      select * from w where rnk=1;

                                                                                      4. rownum and rowid diff
                                                                                      Ans : Rownum : It just displays sequence number to the query output. It doesn't stored in database. it will work for = 1 and <= n in select stmnt.
                                                                                      Rowid : For every row in a table , oracle creates unique 18 digits alpha numeric id which is stored in database.mainly used for performance improvement

                                                                                      5.case and decode diff
                                                                                      Ans : Case : We can use relational operators. case is faster. can be assigned to a variable. case can be written independently or in select statement
                                                                                      Decode : We cannot use relational operators. can't be assigned to a variable. Only it can be used in select statement.

                                                                                      6.write all the sql and plsql concepts you know

                                                                                      7.what is synonym and purpose?
                                                                                      Ans : synonym - alternative name for an object
                                                                                      we can create multiple synonym for an object
                                                                                      we can create multiple synonym for a synonym
                                                                                      if table is dropped then what abt synonym ?
                                                                                      invaild - synonym translation is no longer valid
                                                                                      is it possible to perform dml on synonym ? yes
                                                                                      is it possible to create synonym with the same name of an object name ? yes

                                                                                      Purpose : To access a particular db object by different user with different access

                                                                                      create or replace synonym st1 for t1;
                                                                                      create or replace synonym st2 for st1;
                                                                                      select * from user_synonyms;
                                                                                      drop synonym st1;


                                                                                      sqlplus hr/admin
                                                                                      create user omr identified by omr;
                                                                                      create user tbm identified by tbm;

                                                                                      create table t1(a number);
                                                                                      create synonym omr.t1 for hr.t1;
                                                                                      create synonym tbm.t1 for hr.t1;
                                                                                      grant select on omr.t1 to omr;
                                                                                      grant insert on tbm.t1 to tbm;
                                                                                      connect omr/omr
                                                                                      select * from t1;
                                                                                      connect tbm/tbm
                                                                                      insert into t1(a) values(1);

                                                                                      8.sequence and purpose
                                                                                      Ans : It generates unique number automatically . mainly used to generate pk column values.

                                                                                      create table t2( b number primary key, c varchar(5) );
                                                                                      create sequence t2sq;
                                                                                      insert into t2(b,c) values(t2sq.nextval,'hi');

                                                                                      Don't execute currval after creating sequence.

                                                                                      9.diff between group fun and analytical fun
                                                                                      Ans : Group functions : min / max / sum / avg / count
                                                                                      Analytical functions : Rank / Dense_rank / Row_number / Lead / Lag / Listagg

                                                                                      Group functions : It groups the rows and retrieves one row for each group
                                                                                      Analytical functions : It retrieves one row for each row

                                                                                      10.11g features
                                                                                      Ans : Listagg / interval / follows / compound trigger / virtual column / pivot / regexp_count

                                                                                      11.replace and translate diff
                                                                                      Ans : Single row functions
                                                                                      replace : we can change a word by word
                                                                                      translate : we can change a letter by letter

                                                                                      select replace('tamil book','tamil','english') from dual;
                                                                                      select translate('zoho','zh','lg') from dual;

                                                                                      12.instr and substr diff with examples
                                                                                      Ans :
                                                                                      instr : 4 arguments - it displays position of a character
                                                                                      substr : 3 arguments - it displays a particular string of a string

                                                                                      13.identify the no of 'a' in a string
                                                                                      Ans : Balakrishnaa
                                                                                      select regexp_count('Balakrishnaa','a') from dual;
                                                                                      select length('select') - length(replace('select','e')) from dual;

                                                                                      14. what is view - why ? - functionality
                                                                                      Ans : View contains a query - virtual table - memory can not be utilized. simple / complex view. (simple view - with check option / with read only). we can not create index on views. we cannot perform dml on with read only, complex view. dml possible on with check option and simple views. we can create trigger on views by using instead of(timing point). we can create view for non existing table by using force keyword

                                                                                      15.mview and refresh methods
                                                                                      It is nothing but snap of a query result. mainly used for report generation.
                                                                                      compelete / fast / force

                                                                                      16.constraints
                                                                                      Ans :
                                                                                      primary key => no null , no duplicate
                                                                                      foreign key => yes null , yes duplicates
                                                                                      unique => yes nulls , no duplicates
                                                                                      not null => no nulls , yes duplicates
                                                                                      check => conditional insert


                                                                                      17.delete and truncate diff
                                                                                      Ans : both used to delete the records
                                                                                      Delete : dml / high water mark will be at the end of the data block / where clause / non auto commit so we can rollback or commit.
                                                                                      Truncate : ddl / high water mark will be at the top of data block / where not applicable / auto commit so tcl not applicable

                                                                                      18.nulls first and null last
                                                                                      Ans :
                                                                                      select * from employees order by department_id asc nulls first;
                                                                                      select * from employees order by department_id desc nulls last;

                                                                                      19.null functions with real time scenario
                                                                                      Ans : nvl / nvl2 / nullif / coalesce
                                                                                      select coalesce(email,phno) from employees;

                                                                                      20.write a query with group by clause
                                                                                      Ans :
                                                                                      select department_id , max(salary) from employees group by department_id;

                                                                                      21.joins - diff - cartesian product

                                                                                      inner join => matching records
                                                                                      left outer join => matching of both , unmatching of left table
                                                                                      right outer join => matching of both , unmatching of right table
                                                                                      full outer join => matching and unmatching of both tables
                                                                                      self join => joining table within itself
                                                                                      cross join => cartesian poduct , no of rows in first table * no of rows in second table

                                                                                      22.why we are using gtt ? disadvantages
                                                                                      Ans : The project ( application ) has many tab kind of events. for every event user may give input or delete some records. to manage this activities we are going for gtt. user from one session , may do dml but can not be visible to diff user

                                                                                      23.what is index ? functionality - types
                                                                                      Ans :
                                                                                      why ? to retrieve the data faster but not all the times
                                                                                      decision maker - optimizer
                                                                                      when ? whenever a column frequently called in where clause

                                                                                      b*tree
                                                                                      bitmap
                                                                                      unique
                                                                                      composite
                                                                                      reverse key
                                                                                      function based

                                                                                      24.procedure and functions diff

                                                                                      1.both are called as subprograms. both are used to implement a specific business logic. these are used to convert a business into technical.

                                                                                      2.procedure may or may not
                                                                                      return a value and you can perform anything inside a procedure but for ddl we have to use execute immediate(dynamic sql).

                                                                                      3.whereas in function we can not perform dml and it must return a value. to make dml perform we can use pragma autonomous_transaction. we can not do ddl in function.

                                                                                      4. procedure can be executed in anonymous block or exec or execute but function only in select statement.

                                                                                      5.we can assign a function to a variable.


                                                                                      25.how many table u 've created?
                                                                                      Ans : so many tables / product owner / tl / bu manager

                                                                                      tbl_customer_details / tl_debit / tl_credit / tbl_pymnt / tl_pymnt_ref/
                                                                                      tbl_order_info / tl_trans_data / tbl_placed_orders / tl_reject_orders

                                                                                      26.how many subprograms u 've created?
                                                                                      Ans : so many 15 programs

                                                                                      27.how exceptions handling in your project ?

                                                                                      28.recently created procedure/function/package ?

                                                                                      29.yesterday the query was running fast but not today why ?

                                                                                      30.what is cursor ? - attributes - real time example
                                                                                      Ans :
                                                                                      cursor - cursor is a private sql work area , it will fetch only one row at a time. compile time data fetching process

                                                                                      implicit cursor found / notfound (select not applicable) / rowcount
                                                                                      explicit cursor isopen / notfound / rowcount

                                                                                      31.diff between cursor and ref cursor - real time scenario
                                                                                      Ans :


                                                                                      32.files handling concepts in oracle - which is faster ?
                                                                                      Ans :
                                                                                      Sql loader / External Tables / utl_file

                                                                                      33.write a query for delete and update with joins
                                                                                      Ans :
                                                                                      update emp set salary = (select salary from employees where employee_id = emp.employee_id);

                                                                                      34.insert values using select statement
                                                                                      Ans :
                                                                                      insert into emp select first_name , salary , manager_id from employees;

                                                                                      35.create table using select statement and structure ?
                                                                                      Ans :
                                                                                      create table emp as select first_name , salary , manager_id from employees where employee_id <= 109;

                                                                                      create table emp as select first_name , salary , manager_id from employees where rownum = 2;

                                                                                      36.how take insert scripts using sql developer/toad
                                                                                      Ans :
                                                                                      Toad => query => select all data => export dataset => choose options

                                                                                      37.how to check the program error and debug ?

                                                                                      38.connect by level - hierarchycal query

                                                                                      39.collection types - where u used in your project

                                                                                      40.collection type as table column

                                                                                      41.mutating table error - hw to solve it ?

                                                                                      42.where u 've used trigger in ur project

                                                                                      43. :new ? :old ?

                                                                                      44.what is compound trigger

                                                                                      45.recently faced issue , ur contribution ?

                                                                                      46.how oracle works while executing the query
                                                                                      Ans :

                                                                                      47.how to read explain plan
                                                                                      Ans :
                                                                                      sqlplus : set autotrace on;
                                                                                      Explain plan for select * from employees;
                                                                                      select dbms_xplan.display from dual;
                                                                                      toad => ctl+e

                                                                                      48.function based index - issue - why ?
                                                                                      Ans :
                                                                                      Whenever a column called frequently with function in where clause.
                                                                                      Avoid using virtual column and function based index - performance issue

                                                                                      49. any two 12c features
                                                                                      Ans :
                                                                                      Identity Columns
                                                                                      Versioning

                                                                                      50.packages - advantages

                                                                                      51.authid definer and authid current user ?

                                                                                      52.have u worked in dts preparation ?
                                                                                      Ans : Detailed Technical specification
                                                                                      db developers will be defining everything about proc/fun parameters

                                                                                      53.write a query - who joined on tuesdays ?
                                                                                      Ans :
                                                                                      select first_name , salary , to_char(hire_date,'DAY')
                                                                                      from employees where to_char(hire_date,'D') = 3;

                                                                                      select first_name , salary , to_char(hire_date,'DAY')
                                                                                      from employees where to_char(hire_date,'DY') = 'TUE';

                                                                                      54.list all the alphabets - write a query
                                                                                      Ans :
                                                                                      select chr(64+level) from dual connect by level <= 26;

                                                                                      55.possible to create fk for the same table ?
                                                                                      Ans :
                                                                                      create table t11( a number primary key , b number);
                                                                                      alter table t11 add constraint a_fk foreign key(b) references t11(a);
                                                                                      select * from t11;
                                                                                      insert into t11(a,b) values(4,3);

                                                                                      56. how to generate awr report ? - how to read it

                                                                                      57.query tuning - how do u do that ?

                                                                                      58.what is table fragmentation ?

                                                                                      59.explain plan - how to get it ? and how to read it ?

                                                                                      60.sample real time procedure and function

                                                                                      61.database connection strings - dba work

                                                                                      62.basic unix commands - 10 frequently used commands

                                                                                      63.what is olap ? Online Analytical Processings

                                                                                      64.what is oltp ? Online transaction Processings

                                                                                      65.what is subquery ? correlated sub query?

                                                                                      66. joins and sub query diff

                                                                                      67.with clause and sub query
                                                                                      Ans :
                                                                                      with s as
                                                                                      (
                                                                                      select a.employee_id , a.first_name ,
                                                                                      (select b.department_name from departments b where b.department_id = a.department_id) as department_name
                                                                                      from employees a
                                                                                      ) select * from s;

                                                                                      select a.employee_id , a.first_name ,
                                                                                      (select b.department_name from departments b where b.department_id = a.department_id) as department_name
                                                                                      from employees a;

                                                                                      68.Inline view ?
                                                                                      Ans :
                                                                                      if sub query placed in from clause.
                                                                                      select * from (select first_name , salary , dense_rank() over(order by salary desc) as rn from employees ) where rn=1;

                                                                                      69.who is getting the maximum salary ?
                                                                                      Ans :
                                                                                      select * from (select first_name , salary , dense_rank() over(order by salary desc) as rn from employees ) where rn=1;

                                                                                      select first_name from employees where salary = (select max(salary) from employees);

                                                                                      70.dynamic sql ?

                                                                                      declare
                                                                                      a varchar(50) := 'first_name';
                                                                                      c varchar(50) := 'salary';
                                                                                      b employees.first_name%type;
                                                                                      d employees.salary%type;
                                                                                      begin
                                                                                      select a into b from employees where salary = 24000;
                                                                                      dbms_output.put_line(b);
                                                                                      execute immediate 'select '||a||' from employees where salary = 24000' into b;
                                                                                      execute immediate 'select '||c||' from employees where first_name = ''Neena''' into d;
                                                                                      dbms_output.put_line(b);
                                                                                      dbms_output.put_line(d);
                                                                                      end;
                                                                                      /

                                                                                      71.how to insert values in clob , blob and bfile ?

                                                                                      72. There is a column name Inv-128 how you print separately char alone and number alone?
                                                                                      Ans : select regexp_replace('inv123','[a-z]') , regexp_replace('inv123','[0-9]') from dual;


                                                                                      Pt for Interview Questions


                                                                                      I ve good understanding of pt concepts. i ve hands on experience in pt like to generate awr report , sql query tuning , explain plan analysis . i ve been part of pt team for last 3, 4 months. i got the clear understanding of application flow.

                                                                                      we recently faced an issue of
                                                                                      application latency
                                                                                      blank report
                                                                                      query slowness
                                                                                      memory usage full

                                                                                      for application latency , our dba will be sending the awr reprt to us and i will analyze the report based on the check list give to us. we have standard process to follow for pt, whether we can go for joins instead of sub query , null functions to be replaced by case or decode to be replaced by case .. etc

                                                                                      i will check the explain plan for the query first with screenshot, then i will analyze which scans have been done by optimizer whether index has been read (if index there), or index required , hints to be forced , sub query to be replaced ... if i found any cost decrease then i will force hint or iniating index .. or gathering table statics

                                                                                      we faced more application slowness (particular page will be blank at specific point of time ) issues. for that we will be doing

                                                                                      exec dbms_stats.gather_table_stats('hr','employees');

                                                                                      after running this .. index may go for unusable status so we have to check the index status in user_indexes. if it is in unusable status then

                                                                                      alter index index_name rebuild online; ( if production time issue ) or
                                                                                      alter index index_name rebuild;

                                                                                      i have some knowledge of analysing awr report

                                                                                      select * from dba_hist_snapshot;

                                                                                      first of all we need to get the application slowness issue timings from L1 people
                                                                                      based on that i will be checking in the respective database to get the snap start id , snap end id , db id , instance number to generate awr report.

                                                                                      using select * from
                                                                                      table(dbms_workload_repository.awr_report_html(dbid,insnumber,snapsid, snapeid));

                                                                                      i will check top 10 fore ground events and then i can easily identify the query which took more time to execute. if the cost of the query says 100% above then i will tune the query...

                                                                                      table partitioning
                                                                                      awr report
                                                                                      index
                                                                                      hints
                                                                                      bind variable
                                                                                      avoidance of null functions
                                                                                      use case instead of decode
                                                                                      collections / bulk collect ..

                                                                                      How to see explain plan

                                                                                      in sqlplus => set autot on
                                                                                      in toad => ctl+e

                                                                                      General way

                                                                                      explain for select * from emp;
                                                                                      select dbms_xplan.display from dual;


                                                                                      Interview Questions


                                                                                      1.About your project/Day to Day Activities

                                                                                      2.Identifying duplicates and Deleting duplicates
                                                                                      Ans : delete from emp where rowid not in (select max(rowid) from emp group by empid);

                                                                                      Ans :delete from emp a where rowid not in (select max(rowid) from emp b where b.empid=a.empid);

                                                                                      Ans : select department_id , count(department_id) from employees group by department_id having count(department_id) >1

                                                                                      3.2nd maximum salary

                                                                                      Ans : with w as (select first_name , salary , dense_rank() over(order by salary
                                                                                      desc) as rnk from employees ) select * from w where rnk=2;

                                                                                      Ans : select * from (select first_name , salary , dense_rank() over(order by salary
                                                                                      desc) as rnk from employees) where rnk = 2;

                                                                                      Ans : select max(salary) from employees where salary <> ( select max(salary) from employees );

                                                                                      Department wise maximum salary

                                                                                      Ans : with w as (select first_name , salary ,department_id, dense_rank() over(partition by department_id order by salary desc) as rnk from employees )
                                                                                      select * from w where rnk=1;

                                                                                      4. rownum and rowid diff
                                                                                      Ans : Rownum : It just displays sequence number to the query output. It doesn't stored in database. it will work for = 1 and <= n in select stmnt.
                                                                                      Rowid : For every row in a table , oracle creates unique 18 digits alpha numeric id which is stored in database.mainly used for performance improvement

                                                                                      5.case and decode diff
                                                                                      Ans : Case : We can use relational operators. case is faster. can be assigned to a variable. case can be written independently or in select statement
                                                                                      Decode : We cannot use relational operators. can't be assigned to a variable. Only it can be used in select statement.

                                                                                      6.write all the sql and plsql concepts you know

                                                                                      7.what is synonym and purpose?
                                                                                      Ans : synonym - alternative name for an object
                                                                                      we can create multiple synonym for an object
                                                                                      we can create multiple synonym for a synonym
                                                                                      if table is dropped then what abt synonym ?
                                                                                      invaild - synonym translation is no longer valid
                                                                                      is it possible to perform dml on synonym ? yes
                                                                                      is it possible to create synonym with the same name of an object name ? yes

                                                                                      Purpose : To access a particular db object by different user with different access

                                                                                      create or replace synonym st1 for t1;
                                                                                      create or replace synonym st2 for st1;
                                                                                      select * from user_synonyms;
                                                                                      drop synonym st1;


                                                                                      sqlplus hr/admin
                                                                                      create user omr identified by omr;
                                                                                      create user tbm identified by tbm;

                                                                                      create table t1(a number);
                                                                                      create synonym omr.t1 for hr.t1;
                                                                                      create synonym tbm.t1 for hr.t1;
                                                                                      grant select on omr.t1 to omr;
                                                                                      grant insert on tbm.t1 to tbm;
                                                                                      connect omr/omr
                                                                                      select * from t1;
                                                                                      connect tbm/tbm
                                                                                      insert into t1(a) values(1);

                                                                                      8.sequence and purpose
                                                                                      Ans : It generates unique number automatically . mainly used to generate pk column values.

                                                                                      create table t2( b number primary key, c varchar(5) );
                                                                                      create sequence t2sq;
                                                                                      insert into t2(b,c) values(t2sq.nextval,'hi');

                                                                                      Don't execute currval after creating sequence.

                                                                                      9.diff between group fun and analytical fun
                                                                                      Ans : Group functions : min / max / sum / avg / count
                                                                                      Analytical functions : Rank / Dense_rank / Row_number / Lead / Lag / Listagg

                                                                                      Group functions : It groups the rows and retrieves one row for each group
                                                                                      Analytical functions : It retrieves one row for each row

                                                                                      10.11g features
                                                                                      Ans : Listagg / interval / follows / compound trigger / virtual column / pivot / regexp_count

                                                                                      11.replace and translate diff
                                                                                      Ans : Single row functions
                                                                                      replace : we can change a word by word
                                                                                      translate : we can change a letter by letter

                                                                                      select replace('tamil book','tamil','english') from dual;
                                                                                      select translate('zoho','zh','lg') from dual;

                                                                                      12.instr and substr diff with examples
                                                                                      Ans :
                                                                                      instr : 4 arguments - it displays position of a character
                                                                                      substr : 3 arguments - it displays a particular string of a string

                                                                                      13.identify the no of 'a' in a string
                                                                                      Ans : Balakrishnaa
                                                                                      select regexp_count('Balakrishnaa','a') from dual;
                                                                                      select length('select') - length(replace('select','e')) from dual;

                                                                                      14. what is view - why ? - functionality
                                                                                      Ans : View contains a query - virtual table - memory can not be utilized. simple / complex view. (simple view - with check option / with read only). we can not create index on views. we cannot perform dml on with read only, complex view. dml possible on with check option and simple views. we can create trigger on views by using instead of(timing point). we can create view for non existing table by using force keyword

                                                                                      15.mview and refresh methods
                                                                                      It is nothing but snap of a query result. mainly used for report generation.
                                                                                      compelete / fast / force

                                                                                      16.constraints
                                                                                      Ans :
                                                                                      primary key => no null , no duplicate
                                                                                      foreign key => yes null , yes duplicates
                                                                                      unique => yes nulls , no duplicates
                                                                                      not null => no nulls , yes duplicates
                                                                                      check => conditional insert


                                                                                      17.delete and truncate diff
                                                                                      Ans : both used to delete the records
                                                                                      Delete : dml / high water mark will be at the end of the data block / where clause / non auto commit so we can rollback or commit.
                                                                                      Truncate : ddl / high water mark will be at the top of data block / where not applicable / auto commit so tcl not applicable

                                                                                      18.nulls first and null last
                                                                                      Ans :
                                                                                      select * from employees order by department_id asc nulls first;
                                                                                      select * from employees order by department_id desc nulls last;

                                                                                      19.null functions with real time scenario
                                                                                      Ans : nvl / nvl2 / nullif / coalesce
                                                                                      select coalesce(email,phno) from employees;

                                                                                      20.write a query with group by clause
                                                                                      Ans :
                                                                                      select department_id , max(salary) from employees group by department_id;

                                                                                      21.joins - diff - cartesian product

                                                                                      inner join => matching records
                                                                                      left outer join => matching of both , unmatching of left table
                                                                                      right outer join => matching of both , unmatching of right table
                                                                                      full outer join => matching and unmatching of both tables
                                                                                      self join => joining table within itself
                                                                                      cross join => cartesian poduct , no of rows in first table * no of rows in second table

                                                                                      22.why we are using gtt ? disadvantages
                                                                                      Ans : The project ( application ) has many tab kind of events. for every event user may give input or delete some records. to manage this activities we are going for gtt. user from one session , may do dml but can not be visible to diff user

                                                                                      23.what is index ? functionality - types
                                                                                      Ans :
                                                                                      why ? to retrieve the data faster but not all the times
                                                                                      decision maker - optimizer
                                                                                      when ? whenever a column frequently called in where clause

                                                                                      b*tree
                                                                                      bitmap
                                                                                      unique
                                                                                      composite
                                                                                      reverse key
                                                                                      function based

                                                                                      24.procedure and functions diff

                                                                                      1.both are called as subprograms. both are used to implement a specific business logic. these are used to convert a business into technical.

                                                                                      2.procedure may or may not
                                                                                      return a value and you can perform anything inside a procedure but for ddl we have to use execute immediate(dynamic sql).

                                                                                      3.whereas in function we can not perform dml and it must return a value. to make dml perform we can use pragma autonomous_transaction. we can not do ddl in function.

                                                                                      4. procedure can be executed in anonymous block or exec or execute but function only in select statement.

                                                                                      5.we can assign a function to a variable.


                                                                                      25.how many table u 've created?
                                                                                      Ans : so many tables / product owner / tl / bu manager

                                                                                      tbl_customer_details / tl_debit / tl_credit / tbl_pymnt / tl_pymnt_ref/
                                                                                      tbl_order_info / tl_trans_data / tbl_placed_orders / tl_reject_orders

                                                                                      26.how many subprograms u 've created?
                                                                                      Ans : so many 15 programs

                                                                                      27.how exceptions handling in your project ?

                                                                                      28.recently created procedure/function/package ?

                                                                                      29.yesterday the query was running fast but not today why ?

                                                                                      30.what is cursor ? - attributes - real time example
                                                                                      Ans :
                                                                                      cursor - cursor is a private sql work area , it will fetch only one row at a time. compile time data fetching process

                                                                                      implicit cursor found / notfound (select not applicable) / rowcount
                                                                                      explicit cursor isopen / notfound / rowcount

                                                                                      31.diff between cursor and ref cursor - real time scenario
                                                                                      Ans :


                                                                                      32.files handling concepts in oracle - which is faster ?
                                                                                      Ans :
                                                                                      Sql loader / External Tables / utl_file

                                                                                      33.write a query for delete and update with joins
                                                                                      Ans :
                                                                                      update emp set salary = (select salary from employees where employee_id = emp.employee_id);

                                                                                      34.insert values using select statement
                                                                                      Ans :
                                                                                      insert into emp select first_name , salary , manager_id from employees;

                                                                                      35.create table using select statement and structure ?
                                                                                      Ans :
                                                                                      create table emp as select first_name , salary , manager_id from employees where employee_id <= 109;

                                                                                      create table emp as select first_name , salary , manager_id from employees where rownum = 2;

                                                                                      36.how take insert scripts using sql developer/toad
                                                                                      Ans :
                                                                                      Toad => query => select all data => export dataset => choose options

                                                                                      37.how to check the program error and debug ?

                                                                                      38.connect by level - hierarchycal query

                                                                                      39.collection types - where u used in your project

                                                                                      40.collection type as table column

                                                                                      41.mutating table error - hw to solve it ?

                                                                                      42.where u 've used trigger in ur project

                                                                                      43. :new ? :old ?

                                                                                      44.what is compound trigger

                                                                                      45.recently faced issue , ur contribution ?

                                                                                      46.how oracle works while executing the query
                                                                                      Ans :

                                                                                      47.how to read explain plan
                                                                                      Ans :
                                                                                      sqlplus : set autotrace on;
                                                                                      Explain plan for select * from employees;
                                                                                      select dbms_xplan.display from dual;
                                                                                      toad => ctl+e

                                                                                      48.function based index - issue - why ?
                                                                                      Ans :
                                                                                      Whenever a column called frequently with function in where clause.
                                                                                      Avoid using virtual column and function based index - performance issue

                                                                                      49. any two 12c features
                                                                                      Ans :
                                                                                      Identity Columns
                                                                                      Versioning

                                                                                      50.packages - advantages

                                                                                      51.authid definer and authid current user ?

                                                                                      52.have u worked in dts preparation ?
                                                                                      Ans : Detailed Technical specification
                                                                                      db developers will be defining everything about proc/fun parameters

                                                                                      53.write a query - who joined on tuesdays ?
                                                                                      Ans :
                                                                                      select first_name , salary , to_char(hire_date,'DAY')
                                                                                      from employees where to_char(hire_date,'D') = 3;

                                                                                      select first_name , salary , to_char(hire_date,'DAY')
                                                                                      from employees where to_char(hire_date,'DY') = 'TUE';

                                                                                      54.list all the alphabets - write a query
                                                                                      Ans :
                                                                                      select chr(64+level) from dual connect by level <= 26;

                                                                                      55.possible to create fk for the same table ?
                                                                                      Ans :
                                                                                      create table t11( a number primary key , b number);
                                                                                      alter table t11 add constraint a_fk foreign key(b) references t11(a);
                                                                                      select * from t11;
                                                                                      insert into t11(a,b) values(4,3);

                                                                                      56. how to generate awr report ? - how to read it

                                                                                      57.query tuning - how do u do that ?

                                                                                      58.what is table fragmentation ?

                                                                                      59.explain plan - how to get it ? and how to read it ?

                                                                                      60.sample real time procedure and function

                                                                                      61.database connection strings - dba work

                                                                                      62.basic unix commands - 10 frequently used commands

                                                                                      63.what is olap ? Online Analytical Processings

                                                                                      64.what is oltp ? Online transaction Processings

                                                                                      65.what is subquery ? correlated sub query?

                                                                                      66. joins and sub query diff

                                                                                      67.with clause and sub query
                                                                                      Ans :
                                                                                      with s as
                                                                                      (
                                                                                      select a.employee_id , a.first_name ,
                                                                                      (select b.department_name from departments b where b.department_id = a.department_id) as department_name
                                                                                      from employees a
                                                                                      ) select * from s;

                                                                                      select a.employee_id , a.first_name ,
                                                                                      (select b.department_name from departments b where b.department_id = a.department_id) as department_name
                                                                                      from employees a;

                                                                                      68.Inline view ?
                                                                                      Ans :
                                                                                      if sub query placed in from clause.
                                                                                      select * from (select first_name , salary , dense_rank() over(order by salary desc) as rn from employees ) where rn=1;

                                                                                      69.who is getting the maximum salary ?
                                                                                      Ans :
                                                                                      select * from (select first_name , salary , dense_rank() over(order by salary desc) as rn from employees ) where rn=1;

                                                                                      select first_name from employees where salary = (select max(salary) from employees);

                                                                                      70.dynamic sql ?

                                                                                      declare
                                                                                      a varchar(50) := 'first_name';
                                                                                      c varchar(50) := 'salary';
                                                                                      b employees.first_name%type;
                                                                                      d employees.salary%type;
                                                                                      begin
                                                                                      select a into b from employees where salary = 24000;
                                                                                      dbms_output.put_line(b);
                                                                                      execute immediate 'select '||a||' from employees where salary = 24000' into b;
                                                                                      execute immediate 'select '||c||' from employees where first_name = ''Neena''' into d;
                                                                                      dbms_output.put_line(b);
                                                                                      dbms_output.put_line(d);
                                                                                      end;
                                                                                      /

                                                                                      71.how to insert values in clob , blob and bfile ?

                                                                                      72. There is a column name Inv-128 how you print separately char alone and number alone?
                                                                                      Ans : select regexp_replace('inv123','[a-z]') , regexp_replace('inv123','[0-9]') from dual;

                                                                                      73. insert - Last One year data into another table

                                                                                      insert into emp select * from employees where employee_id in (
                                                                                      select employee_id from employees
                                                                                      where hire_date between sysdate and add_months(sysdate,-12)
                                                                                      );

                                                                                      74. Get - Last 30 days data
                                                                                      select * from emp where entry_date between sysdate and sysdate-30;

                                                                                      75. Month wise employees count ?

                                                                                      select to_char(hire_date,'mon') , count(first_name) from employees group by to_char(hire_date,'mon');

                                                                                      76. Which dep is having max no of employees ?

                                                                                      select department_id , count(employee_id)
                                                                                      from employees group by department_id having count(employee_id) =
                                                                                      (select max( count(employee_id) ) from employees group by department_id);

                                                                                      77. Recently inserted record ?

                                                                                      select * from employees where rowid = (select max(rowid) from employees);

                                                                                      78. Total salary by using plsql block

                                                                                      declare
                                                                                      i number := 0;
                                                                                      begin
                                                                                      for j in (select salary from employees) loop
                                                                                      i := i+j.salary
                                                                                      end loop;
                                                                                      dbms_output.put_line(i);
                                                                                      end;
                                                                                      /

                                                                                      79.

                                                                                      t1
                                                                                      a b c d ? if male then 10 if female then 20
                                                                                      101 sai m 10
                                                                                      102 amu f 20
                                                                                      103 ram m 10
                                                                                      104 sindhu f 20
                                                                                      105 raja m 10

                                                                                      update t1 set d = case when c='m' then 10 when c='f' then 20 end;

                                                                                      80. Change fname to lname and lname to fname

                                                                                      update employees set first_name = last_name , last_name = first_name;

                                                                                      81. when parent key not found error will occur ?

                                                                                      82. when child record found error will occur ?

                                                                                      83. what is on delete cascade / on delete null ?

                                                                                      84. what is novalidate ? -- not to validate the existing data

                                                                                      t1
                                                                                      a
                                                                                      1
                                                                                      1
                                                                                      2
                                                                                      create index idx on t1(a);
                                                                                      alter table t1 add constraint a_pk primary key(a) novalidate;

                                                                                      85 . How to get no of records in a table ?

                                                                                      select count(*) from employees;
                                                                                      select num_rows from user_tables where table_name='EMPLOYEES';


                                                                                      IVYMOBILITY


                                                                                      Written round que
                                                                                      1. Write a query to display all records
                                                                                      2.Write query to display the name starts with A
                                                                                      3. Delete particular row
                                                                                      4.update particular row
                                                                                      5. Display the employee who joined in 2018
                                                                                      6.write a query to show the details of employee who got minimum salary
                                                                                      7.Display 3rd highest salary
                                                                                      8.Display duplicate rows and also count of it
                                                                                      9. Inner join related query
                                                                                      10. Display the particular record who working in payroll department


                                                                                      F2f
                                                                                      1.Tell me about itself
                                                                                      2.what is the last issue you faced
                                                                                      3.what you did for change request.
                                                                                      4. Diff bt procedure and function
                                                                                      5. Constrains
                                                                                      6. Union and union all
                                                                                      7.identity

                                                                                      HR round
                                                                                      1.tell me about urself
                                                                                      2. Ur team size
                                                                                      3. Who you don't like in ur office
                                                                                      4.Explain about ur office
                                                                                      5.why you are changing from ur office any particular reason??
                                                                                      6. Expected ctc
                                                                                      7. Share The pressurised moment you faced in ur office




                                                                                      Interview questions


                                                                                      1. Write query for view, mview, procedure, functions, leftouter joint.
                                                                                      2. Last created function or procedure and its purpose.
                                                                                      3. Write a procedure with 2 inputs 1 is sysdate, 2 is 27 and it must return all the dates of tuesday till 27?
                                                                                      4. Db view and mview?
                                                                                      5. Create a view combining 2 tables




                                                                                      Bahwan cybertech sql developer interview


                                                                                      1. write merge coding

                                                                                      2. date functions using to_date, last_day and starting date of a month

                                                                                      3. normalization and denormalization for tables

                                                                                      4. condition using null=null is valid or not

                                                                                      5. Rollback after dml operation in tables which will affect trigger or not?

                                                                                      6. exception handling examples

                                                                                      7. Anlytical function and group functions

                                                                                      8. Performance tuning






                                                                                      D&b technologies


                                                                                      Interview questions..

                                                                                      1.Retrive data from two tables without using join

                                                                                      2. Using group function query

                                                                                      3. Views and uses

                                                                                      4. Cursors

                                                                                      5. Composite constraints

                                                                                      6. Syntax for creating duplicate table










                                                                                      Second round (exela)


                                                                                      =================
                                                                                      1.tell about yourself
                                                                                      2.types of joins
                                                                                      3.explain subquery
                                                                                      4.Write Plsql block using update salary increments 500 salary who salary have 20000
                                                                                      5.explain Linked server
                                                                                      6.What is mean by index
                                                                                      7.what performance tuning you done
                                                                                      8.what is mean by cluster index


                                                                                      3i info tech interview questions today


                                                                                      1.Tell about yourself?
                                                                                      2.Why you left the job?
                                                                                      3.What is the version of the tool u have used?
                                                                                      4.Is your project is in live?
                                                                                      5.What front end technology in your project?
                                                                                      6.Tell about family?
                                                                                      7.Tell about your work location and team size?
                                                                                      8.How many procedure have you created?
                                                                                      9.Write a syntax for trigger?
                                                                                      10.Write a query for statement level trigger and row level trigger?
                                                                                      11.What is mutation error?
                                                                                      12.What is cursor?
                                                                                      13.What is collections?
                                                                                      14.What is bulk collect? What exception will you use?
                                                                                      15.In a procedure there are many lines and how will u find the error in a particular line?
                                                                                      16.What constraints and types?
                                                                                      17.Diff between primary key and foreign key?
                                                                                      18.Diff between primary key and unique constraint?
                                                                                      19.Write a query for bulk collector?
                                                                                      20.What is collections?
                                                                                      21.Can we call function in procedure?
                                                                                      22.Can we do DML statement in function?
                                                                                      23.Why we are creating procedure and function?
                                                                                      24. Write a trigger for a particular column?
                                                                                      25. What is complex procedure you have written in your project?
                                                                                      26.What is complex scenario u have faced to write procedure and how do you made it simple using procedure?




                                                                                      Definition overloading
                                                                                      How to use commit and rollback in triggers
                                                                                      How will you use if statement in SQL statement
                                                                                      Oracle index definition
                                                                                      %type and %rowtype


                                                                                      Which cannot have a default value
                                                                                      IN
                                                                                      OUT
                                                                                      R(ead)
                                                                                      Constant


                                                                                      Cursor error ques?!

                                                                                      Select to_char(trunc(sysdate), 'mm/dd/yyyy hr24:mm:ss')












                                                                                      Exela written test paper






















                                                                                      Virtusa is hiring Unix and Plsql developers on Dec 1st for L1 and L2 production Support


                                                                                      Please be available to attend interview in Virtusa tomorrow at 9:30 am sharp.











                                                                                      Bahwan cyber tek question

                                                                                      Select hi from dual where null= null-what will be the output

                                                                                      Write a query to display alternative record in a table

                                                                                      Write a query to display 4 to 7 records of a table

                                                                                      Joins

                                                                                      Can we create index for view?

                                                                                      Simple questions from analytical functions to find rank and dense rank

                                                                                      Inline view and correlated subquery with examples

                                                                                      Exception handling

                                                                                      Normalisation

                                                                                      Index
                                                                                      Diff between view and materialised view

                                                                                      Set operators

                                                                                      Performance tuning




                                                                                      Virtusa 1 round


                                                                                      1 . tell about yourself
                                                                                      2.unix commands
                                                                                      3 . what is materialized view
                                                                                      4 . what are the role for l1 and l2 support
                                                                                      5.are you currently working in.
                                                                                      6.why releived from there.
                                                                                      7.current CTC.
                                                                                      8.you need to ask any questions to me.




                                                                                      3i questions


                                                                                      1) Tell about yr self
                                                                                      2) what is different between support and develop er
                                                                                      3)what is different between view and materialized view
                                                                                      4) table partition
                                                                                      5) analytical function
                                                                                      6) 11g feature
                                                                                      7) what is pragma not transaction
                                                                                      8) collect ion
                                                                                      9)bulk collect
                                                                                      I have one table based created package , procedure function I want fetch 100 record
                                                                                      If I will drop the table what happened?
                                                                                      If I re Create table what happened?




                                                                                      bhawan cyber tek interview questions


                                                                                      1.what is refcursor
                                                                                      2.what is materialized view
                                                                                      3.Matrialized view scenario
                                                                                      4.What is bulk collect
                                                                                      5.Bulk collect scenario
                                                                                      6.what is joins
                                                                                      7.types of joins
                                                                                      8.joins scenario




                                                                                      interview in virtusa for L1 and L2 support


                                                                                      1)Tell abt yourself
                                                                                      2)what is inner join?
                                                                                      3)what is self join?
                                                                                      4)what is the purpose of using self join?
                                                                                      5)write any 10 unix command name that you are using daily..
                                                                                      6)day to day activities
                                                                                      7)How to retrive last updated record ?




                                                                                      I went for today interview and first one too
                                                                                      They asked questions like
                                                                                      1)what is procedure
                                                                                      Write some procedure
                                                                                      2)cursor
                                                                                      3)what is your work nature or flow
                                                                                      4) packages
                                                                                      5)write a query to find 2 nd max salary
                                                                                      6)diff between procedure and function





                                                                                      Dun&bradstreet technologies interview questions


                                                                                      1.Sub query types and use correlated sub query to write a query
                                                                                      2. senario table to write query to join 2 tables without joins
                                                                                      3. Views and rename a view and dml in view
                                                                                      4. Create a table with one varchar column which allow only more than 5 letters while inserting
                                                                                      5. Truncate and delete
                                                                                      6. Cursor
                                                                                      7. Unix 5 cmd (grep)








                                                                                      D and B technologies.. interview questions.


                                                                                      1.what is your roles and responsibilities?
                                                                                      2.what is your project and team size?tell me elaborately?
                                                                                      3.what is the view?
                                                                                      4.why we use view?
                                                                                      Scenario based questions.
                                                                                      A
                                                                                      Sid name
                                                                                      1. Ram
                                                                                      2. John
                                                                                      3. Vinoth
                                                                                      B
                                                                                      Sid salary
                                                                                      1. 3000
                                                                                      2. 5000
                                                                                      3. 6000
                                                                                      Display all the records from two tables.




                                                                                      We have urgent opening for PL/SQL.
                                                                                      Should able to attend Face to Face interview on this Saturday 8th Dec 2018 in DLF, Chennai.

                                                                                      JD:
                                                                                      Should have good experience in PLSQL- Packages, Functions, Procedures, Triggers, Complex SQ.
                                                                                      Good communication skills.

                                                                                      If you are interested, kindly fill below details & revert back with your updated profile.

                                                                                      Total yrs of exp:
                                                                                      Relevant exp:
                                                                                      Current CTC:
                                                                                      Expected CTC (Pls mention if Negotiable):
                                                                                      Current Location:
                                                                                      Notice Period (Pls mention if Negotiable):
                                                                                      Can able to attend Face to Face interview on this Sat 8th Dec 2018:(Yes/No):

                                                                                      Thanks & Regards,
                                                                                      Manoj S
                                                                                      L&T Infotech Ltd
                                                                                      Manoj1.S@lntinfotech.com



                                                                                      Dun and Bradstreet technologies.


                                                                                      1. Tell me abt yourself, day to day activities.
                                                                                      2. Project explanation, Wat was ur role in ur project.
                                                                                      3.Table with millions of records n asked me to fetch only the persons who use Gmail.com email.
                                                                                      4.views and materialized views.
                                                                                      5. Index and why do we use index?
                                                                                      6. Procedures, packages, functions.
                                                                                      7. Difference between drop ,delete, truncate.
                                                                                      8. Wat is composite primary key? And tell me the difference between primary key and composite primary key.
                                                                                      9. Scenario- our company is going to get closed but before that we want our database to be deleted.wat will u do?
                                                                                      10. Who do u report in ur company?
                                                                                      11. Dbms profiler, query optimization.
                                                                                      12. Gave two tables and asked me to perform different joins on it.
                                                                                      13. Cursors?
                                                                                      14. Pragma autonomous transaction? Why do we use it? Purpose of it in corporate world?
                                                                                      15. Triggers?
                                                                                      16. Which version u r currently working on?
                                                                                      17. When will mutating table error will occur?
                                                                                      18. How to check how many indexes are created per table?


                                                                                      G10x requiriting more Oracle people
                                                                                      Send mail for the below address

                                                                                      hadeel.zubair@g10x.com



                                                                                      Dear Candidate,
                                                                                      Greeting from ILABZ Technology.
                                                                                      This is an opportunity of permanent Employment with ILabz Technology, and the employee will be deployed at one of our MNC client location.
                                                                                      Looking for only immediate Joinee or who can join withus within 10 Days or Not working Candidates.
                                                                                      For Furuther process I need all the company reliving letter till now WORKING & Current company 1 payslips.
                                                                                      We have an urgent opening for a CMM Level 5 Company, Kindly read to find more details:-
                                                                                      If you are interested please shared all the details
                                                                                      Full Name:
                                                                                      Skill:
                                                                                      Total Experience:
                                                                                      Relevant Experience:
                                                                                      Contact number:
                                                                                      NP :
                                                                                      Required Time to Join:
                                                                                      Take home salary per month:
                                                                                      Expected Take home salary per month:
                                                                                      Currently working/Not Working/ Serving Notice Period:
                                                                                      Last Working Day:
                                                                                      Current Company:
                                                                                      Employment [Permanent/Contract]:
                                                                                      Required Time to Join:
                                                                                      Current Location:
                                                                                      Please let us know if you are holding any other Offers:
                                                                                      Are you willing to join our Client under ILabz Technology Payroll:
                                                                                      Ready to take F2F interview (mandatory):
                                                                                      Pan card:


                                                                                      Regards,
                                                                                      Babita Yadav
                                                                                      Executive - Talent Acquisition
                                                                                      Contact No: 9607169964
                                                                                      ID: babitayadav@ilabztechnology.com




                                                                                      1.Tel abt urself.day to day activities..
                                                                                      2.11g and 12c features.what s g and c.
                                                                                      3.what is view..3 columns in tat 1 column is not null constraint.inserting values fr 2 columns nly.inserts r not.
                                                                                      4.what is cursor?
                                                                                      5.index nd purpose..can create multiple index fr same column?
                                                                                      6.write query to get result frm 2 tables witout using joins.
                                                                                      7.using group by write query.
                                                                                      8.refcursor
                                                                                      9.create table with name column.it shld allow string more than 5 characters.
                                                                                      10.pseudocolumns?
                                                                                      11.fruit. Price color
                                                                                      Apple 100 red
                                                                                      Apple 200 green
                                                                                      Grapes 150 green
                                                                                      O/p to get total price nd use grp by
                                                                                      12..SDLC design?








                                                                                      IVY Inerview Questions


                                                                                      1.select a query to get all employee record from employee table
                                                                                      2. Get all employee record from employee table whose first name starts with A
                                                                                      3.get all employee details from employee table whose joining year 2013
                                                                                      4.get first name , project name from employee and project _ detail for which have assigned project already
                                                                                      5.write a query to get department and department wise total salary for the table
                                                                                      6.get the employee record from employee table who is having lowest salary
                                                                                      7.write a query to get second highest salary
                                                                                      8.delete particular record who's working in payroll department
                                                                                      9.write a query to update record
                                                                                      10.write a query to delete entire row


                                                                                      Intellect 2nd round question


                                                                                      1 Tell abt study's
                                                                                      2 procedure vs package
                                                                                      3 advantage of package
                                                                                      4 package with example
                                                                                      5 synonyms vs view, which is fast
                                                                                      6 sal loader vs external table, which is fast
                                                                                      7 group function
                                                                                      8 rank vs d.rank with example
                                                                                      9 view vs m.view
                                                                                      10 what are the object in schema
                                                                                      11 dcl
                                                                                      12 database vs schema































                                                                                      We are hiring for Oracle Developers for MNC based in Chennai.


                                                                                      • Oracle Developer

                                                                                      • Chennai 

                                                                                      • 2 to 8 years’ experience

                                                                                      • Immediate to 15 days joining

                                                                                      • CTC- Open

                                                                                      • No. of open positions- 6


                                                                                      Interested candidates, kindly share resume at rameez.zafar@tryfacta.ai


                                                                                      Regards,

                                                                                      Rameez Zafar

                                                                                      Talent Acquisition Manager

                                                                                      Direct: +91-8826548085




                                                                                      IndusInd bank for L1 and L2 support role Questions


                                                                                      1)Tell about your profile
                                                                                      2)your roles and responsibilities
                                                                                      3) what is index?
                                                                                      4)In which column you create index?
                                                                                      5)which ticketing tool you are using?
                                                                                      6)Tell last three incident request you have faced?
                                                                                      7)Your current CTC and your expected CTC.
















                                                                                      Experience Interview Questions Link



















                                                                                      1.tell me about yourself.
                                                                                      2.Explain about ur project.
                                                                                      Differences between function and procedures?
                                                                                      Explain about cursors and Exception?
                                                                                      What is collection?
                                                                                      What are all the procedures and triggers you created in your project?
                                                                                      Explain about package?
                                                                                      How to used bulk collect in your project and uses and for what variable you used
                                                                                      Diff between row id and rownum?
                                                                                      What's table partition and type? How to check Oracle created partition?
                                                                                      What is advantage of view and mview
                                                                                      Explain ref_cursors and types?
                                                                                      What's Cartesian product? Give me syntax.
                                                                                      Remove a primary key without removing foreign key?
                                                                                      What are the various constraints used in Oracle?


                                                                                      TCS interview questions

                                                                                      1)What is view and materialised view and what are all the differences
                                                                                      2) Julian date
                                                                                      3) Cartesian join or cross join real scenario
                                                                                      4)temporary table and wht are they
                                                                                      5) cursor with exception handling




                                                                                      1. Tell me about yourself?
                                                                                      2. Your project experience? ur roll in your project?
                                                                                      3.type of join
                                                                                      4. Where do you created package in your last project ?
                                                                                      5.Materialized view?
                                                                                      6. What is view and materialized view?
                                                                                      7. materialized view in your project.
                                                                                      8.Why you are switching from company.


                                                                                      Capgemini interview Questions. 1st Round


                                                                                      1.Bullk collect prgrm.
                                                                                      2.View & materialized view.
                                                                                      3.Delete Duplicate values.4.Truncate & delete.
                                                                                      5.Save exception.
                                                                                      6.Execute immediate. 7.Pragma autonomous transaction.
                                                                                      8.Performance Tuning.
                                                                                      9.Index.
                                                                                      10. Sql loader query.
                                                                                      11. Ctl file content.
                                                                                      12. Diff b/w sql loader & External table.

Testimonials
java training center in chennai My greetings to Java God Madhavan of Greens temple.As a java Pilgrim i have gained power of java.I know what iam before entering to this holy place and now i know i have acquired magic power of java.With your blessings iam going to enter in to programming world.I wish there was some way of showing my gratitude for all what you have done for me....Loving You...... UrsForever

java training center in chennai i would like to say few words about java training in adyar greens technology. It is really best java training center in the whole india i can say, i have never seen such an excellent faculty like Mr.Madhavan...who is the best faculty. i feel very lucky and blessed to be a student of Mr.Madhavan. He is the energetic person hyperactive. Student like me Does'nt feel bore in his class at all. I was irregular to my college but i was never absent to his class. I really love his way of class. thank you greens and thank you Madhavan sir.



Greens Technologys Overall Reviews


Greens Technologys Overall Reviews 5 out of 5 based on 17981 ratings. 17981 user reviews.



java training center in chennai