{"id":385,"date":"2017-07-24T17:56:03","date_gmt":"2017-07-24T17:56:03","guid":{"rendered":"http:\/\/www.codeinsightacademy.com\/blog\/?page_id=385"},"modified":"2019-12-31T04:26:38","modified_gmt":"2019-12-31T04:26:38","slug":"interview-questions","status":"publish","type":"page","link":"https:\/\/codeinsightacademy.com\/blog\/interview-questions\/","title":{"rendered":"Interview Questions"},"content":{"rendered":"

 <\/p>\n

Php<\/strong><\/p>\n

    \n
  1. What is PEAR<\/li>\n
  2. Full form of PHP<\/li>\n
  3. Difference between GET and POST<\/li>\n
  4. Array Functions (any 5)<\/li>\n
  5. String Functions (any 5)<\/li>\n
  6. What are the data types available in Php<\/li>\n
  7. New features in PHP 7<\/li>\n
  8. What is session how does it work. Where does session store.<\/li>\n
  9. What is cookie<\/li>\n
  10. Difference between session and cookies<\/li>\n
  11. How to get extension of file.<\/li>\n
  12. Difference between include and require<\/li>\n
  13. What are magic methods in php<\/li>\n
  14. Types of errors in php<\/li>\n
  15. How to disables errors in php<\/li>\n
  16. How to set the execution time of a script<\/li>\n
  17. How to secure SQL in php<\/li>\n
  18. What is MVC design pattern<\/li>\n
  19. What is XSS and CSRF<\/li>\n
  20. Difference between Apache and Nginx<\/li>\n<\/ol>\n
    \n

    OOPS<\/strong><\/p>\n

      \n
    1. What are major and minor pillars of OOPS<\/li>\n
    2. What is Encapsulation and Abstraction<\/li>\n
    3. Difference between Abstract Class and Interface<\/li>\n
    4. What is the use of static modifier<\/li>\n
    5. What are the different access specifier<\/li>\n
    6. What is method overloading and method overriding<\/li>\n
    7. What is final keyword<\/li>\n
    8. Why php doesn’t support multiple inheritance<\/li>\n
    9. How to achieve multiple inheritance in OOPS<\/li>\n
    10. Can we create object of abstract class<\/li>\n
    11. Design Patterns: Singleton<\/a>\u00a0(description<\/a>) and Factory<\/a><\/li>\n
    12. Can methods in interface have private or protected visibility<\/li>\n<\/ol>\n
      \n

       <\/p>\n

      SQL \/ Database<\/strong><\/p>\n

        \n
      1. What is DDL, DML, DQL, DCL and DTL<\/li>\n
      2. What are Joins<\/li>\n
      3. Inner Join, Left outer Join, Full outer join<\/li>\n
      4. What is Union<\/li>\n
      5. Inner Query<\/li>\n
      6. Subquery<\/li>\n
      7. How to get the highest and second highest salary holders<\/li>\n
      8. Difference between LEFT JOIN and RIGHT JOIN<\/li>\n
      9. Select employees and their manager names from\u00a0 employees table<\/li>\n
      10. How to use REGEX in DQL<\/li>\n
      11. Difference between stored procedure and functions<\/li>\n
      12. What is trigger<\/li>\n
      13. How to create views, procedure, function and package<\/li>\n
      14. What is indexing. How indexing work in RDBMS<\/li>\n
      15. What is the difference between InnoDB and MyISAM database engine<\/li>\n<\/ol>\n
        \n

        Angular JS<\/strong><\/p>\n

          \n
        1. How to pass data from one controller to another<\/li>\n
        2. Why to use Angular JS over jquery or javascript<\/li>\n<\/ol>\n
          \n

          Web Services<\/strong><\/p>\n

            \n
          1. What is Web API\/Web Service?<\/li>\n
          2. Difference Between Web API\/Web Service?<\/li>\n
          3. Overview of RPC, XML-RPC, REST<\/li>\n
          4. What is HTTP GET\/POST\/PUT\/DELETE<\/li>\n
          5. Securing API (Token, JWT, OAuth2)<\/li>\n
          6. Please describe some potential issues with developing a REST API with Laravel and how you would mitigate them<\/li>\n<\/ol>\n
            \n

            Security<\/strong><\/p>\n

              \n
            1. What is CSRF attack<\/li>\n
            2. What is XSS attack<\/li>\n
            3. What is SQL injection How can we protect<\/li>\n
            4. How can we secure web services<\/li>\n
            5. iFrame cross-origin<\/li>\n
            6. What are some of the things you would do to make sure the code you develop is both optimised and secure?<\/li>\n<\/ol>\n
              \n

              Project Management<\/strong><\/p>\n

                \n
              1. What are a few of your favorite development tools and why?<\/li>\n<\/ol>\n
                \n

                [accordion]
                \n[toggle title=”What are the ways to create object of class” state=”closed”]<\/p>\n

                There are four different ways to create objects in java:<\/b><\/div>\n
                \n
                  \n
                1. A. Using new keyword. This is the most common way to create<\/b> an object<\/b> in java<\/b>. …<\/li>\n
                2. B. Using Class<\/b>.forName() If we know the name of the class<\/b> & if it has a public default constructor we can create<\/b> an object<\/b> in this way<\/b>.<\/li>\n
                3. C. Using clone() …<\/li>\n
                4. D. Using object<\/b> deserialization.<\/li>\n<\/ol>\n<\/div>\n

                  [\/toggle]
                  \n[\/accordion][accordion]
                  \n[toggle title=”What are methods of Object class” state=”closed”]<\/p>\n\n\n\n\n\n\n\n
                  Object class methods<\/b><\/th>\nDescription<\/th>\n<\/tr>\n
                  int hashCode();<\/td>\nReturns a hash value that is used to search objects<\/b> in a collection<\/td>\n<\/tr>\n
                  void notify();<\/td>\nUsed in synchronizing threads<\/td>\n<\/tr>\n
                  void notifyAll();<\/td>\nUsed in synchronizing threads<\/td>\n<\/tr>\n
                  String toString();<\/td>\nCan be used to convert the object<\/b> to String<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                  [\/toggle]
                  \n[\/accordion]<\/p>\n","protected":false},"excerpt":{"rendered":"

                    Php What is PEAR Full form of PHP Difference between GET and POST Array Functions (any 5) String Functions (any 5) What are the data types available in Php New features in PHP 7 What is session how does it work. Where does session store. What is cookie Difference between session and cookies How […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":10,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/pages\/385"}],"collection":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/comments?post=385"}],"version-history":[{"count":31,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/pages\/385\/revisions"}],"predecessor-version":[{"id":629,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/pages\/385\/revisions\/629"}],"wp:attachment":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/media?parent=385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}