Interview SQL Questions

1. What is DBMS ?

DBMS is a set of programs which is used to maintain the database. It provides us some tools to perform different operations such as creation of  database, inserting data into tables, deleting tables, altering data in tables.  It is more secure than file management system.

2. What is database ?

Logical grouping of related data is called as Database.

3. What is a database system?

The collection of database and DBMS software together is known as a database system.

4. What are the advantages of DBMS ? 

  • Data Integrity
  • Data Security
  • Better data integration
  • Better Data Transferring
  • Minimized Data Inconsistency
  • Better decision making

Java most frequently asked interview questions ...



 1.      What is java?

Java is a high level object oriented programming language. It consists of mainly classes and objects. We can create any number of objects for a class. It was developed by Sun Microsystems. It was developed by James Gosling in June 1991. There are a lot of applications, websites, and games that are developed using java.

 2.      What are the primitive data types in java ?

Int

Double

float

Long

Char

Boolean

Short

byte

 3.      List some of features of java.

·        Simple – java is easy to learn.

·        Object oriented – Code reusability and maintenance will be good.

·        Portable – java supports read once write any where. Java program is converted to byte code which can run on any machine.

·        Platform independent –  java doesn’t depend on operating system to get executed.

·        Secured   java is secured because it doesn’t use explicit pointers.

·        Robust – java is a strong programming language as it uses strong memory management. The concepts like garbage collector, exception handling make it more robust.

·        High performance – As java uses ‘JIT – just in time’ compiler that reduces                          compile time.

4.      What is type casting in java?

It is a process of assigning a value of one primitive data type to another type.

Widening casting

Converting a smaller type to a larger type size.

Byte -> short -> char -> int -> long -> float -> double

Narrow casting

Converting a larger type to a smaller size type

Double -> float -> long -> int -> char -> short -> byte

 5.      What is JIT compiler ?

The compiler used by the java for compiling is JIT compiler. It is mainly used to improve the performance and reduces the amount of time needed for compilation.

 6.      What is function to find string length in java?

txt.length()

Example

String txt = "KJIHGFEDCBA";

System.out.println("The length of the txt string is: " + txt.length());

 

 7.      Mention some of the string methods in java.

txt.toUpperCase()

txt.toLowerCase()

txt.indexOf("sub-string"))

Example

String txt = "Hello World";

System.out.println(txt.toUpperCase());   // Output  HELLO WORLD

System.out.println(txt.toLowerCase());   //  Output  hello world

 

String txt = "i love java and python";

System.out.println(txt.indexOf("and"));   // Output 12

 8.      Mention some of the math functions in java.

·        Math.max(x,y)

·        Math.min(x,y)

·        Math.sqrt(x,y)

·        Math.abs(x)

·        Math.random()

9.      What do you know about ‘break’?

The break statement can be mainly in used in two forms.

1.      Switch case

The break is used to "jump out" of a switch statement.

2.      Loops

The break statement can also be used to “jump out” of a loop.

10.   What do you know about ‘continue’ in java?

The continue statement skips one iteration (in the loop), and continues with the next iteration in the loop.

 

11.   What is an array?

An array is a collection of similar data type items stored at contiguous memory locations.

12.   Any two applications of arrays.

·        Arrays can be used for CPU scheduling.

·        Used to implement other data structures like Stacks, Queues, Heaps, Hash tables, etc.

 

  1.   13.   What is method overloading?

In a class when multiple methods have same name but different parameters.

NOTE

Return types may or may not be same.

 

14.   Tell about scope in java.

a.      Method scope

Variables declared directly inside a method are available in that method only.

b.     Block scope

The code between curly braces {} is referred as a block. Variables declared inside blocks   are only accessible inside that specific block only I mean between the curly braces.

 

15.   What is recursion?

Recursion is the technique of making a function call itself. This technique provides a way to break complicated problems down into simple problems which are easier to solve.

 

16.   What is ‘HALTING CONDITION’ ?

If we consider a loop there is a problem called infinite looping. In recursion there is a problem called infinite recursion. Infinite recursion is when the function never stops calling itself. Every recursive function should have a halting condition, which is the condition where the function stops calling itself.

 

17.   What are various access specifiers in java?

a.      Public

The classes, methods, or variables which are defined as public, can be accessed by any class or method.

b.     Protected

Protected can be accessed by the class of the same package, or by the sub-class of this class, or within the same class.

c.      Default

Default are accessible within the package only.

d.     Private

The private class, methods, or variables defined as private can be accessed within the class only.

 

18.   What  is a package ?

Package in Java is a mechanism to encapsulate a group of classes, sub packages and interfaces.

It is also defined as collection of modules.

 

19.    

What do you know about virtusa  ?

 

Virtusa Corporation is an American information technology services company founded in 1996 in Sri Lanka and has its headquarters in Southborough, Massachusetts, United States. The company provides IT consulting, business consulting, systems implementation and application outsourcing services to large enterprises and software vendors. The company has several delivery centers in India and Sri Lanka with the ones in Hyderabad, Chennai and Colombo being the largest. In February 2021, Baring Private Equity Asia acquired the company for US$2 billion. Kris Canekeratne, Tushara Canekeratne, John Gillis and Sandy Gillis were the founders of Virtusa. Santosh Thomas is the CEO of Virtusa.In November 2009, Virtusa acquired Insource for $7.3 million. Insource is a technology consulting company which specialized in the insurance and healthcare industries. On 29 March 2018, Virtusa had around 20,000 employees. Virtusa will have a global presence with offices throughout US, Europe and Asia, and advanced development centers in the United States, Europe and Asia. Virtusa Corporation was named the 2021 AWS Industry Solution NSI Partner of the Year. Virtusa is a Salesforce Platinum partner with expertise in delivering large-scale, complex CRM implementations, thereby helping clients scale to market needs. Virtusa Named SIIA CODiE Award Finalist for Best Healthcare Technology Solution.

References

https://www.virtusa.com/about/awards

https://www.virtusa.com/news-room/press-releases/year_2020/april/SIIA-CODiE-Finalist

https://en.wikipedia.org/wiki/Virtusa

HR Interview most asked questions







1. Why should I hire you ? 

I am a very flexible kind of person and feel very comfortable in team as a contributing member. I can adopt to any kind of environment easily. I am confident that my combination of practical work experience and solid education knowledge will provide your organization a productive employee upon completion of your development training.

2. Mention your strong points or strengths?

Adapting to new atmosphere and grasp things at great pace. Positive attitude, workaholic and flexible person. I always believe in time management and believe in making things happen. Above all my greatest strength is self confidence. I also have qualities with enthusiasm, persistence, punctuality.

3. What are the changes you can bring into our company?

I am innovative and willing to adapt to changes in work. i get along well with people and can promote good team play, which will lead to a good working environment.

4. Why do you want to work at our company?

Sir I have learnt much about the best practices followed at the company. seniors from our college have told about the company, the best of the training, state of the art infrastructure and the company has best environment to work and it's a better platform where my ideas are recognized and encouraged.

5. Can you work in night shifts and weekends?

Sir I know how important for a company it is to complete work on time before the announced deadlines. If it is necessary to work at nights and on weekends then I will work without giving any second thought. My strength is to be flexible working with any shift timings.

6. What is the difference between confidence and over confidence (give an example)?

Confidence is inner strength that can make you achieve anything you really desire to achieve whereas overconfidence is something that turns this inner strength to weakness since excess of anything is bad.

7. Are you willing to relocate or travel?

Sir Yes, I'm very much willing to travel or relocate as it provides me the opportunity to work in a new environment where i can meet with people coming from different culture and learn new ideas techniques that can enhance my career goal within the organization. To have a very long and successful career with the same organization it's necessary imperative to understand the work culture and functions of the organization in different locations.

8. Give me an example of your creativity and innovativeness?

Sir, I have a creative imagination, when ever any one describes a situation, place or a person i built an image of it in my mind, this helps me to recall and understand things well, also mention some of the innovative ideas you are going to enforce in your project.

9. How long will you work for this organization?

Sir, I am here because I want to be a part of your esteemed organization and want to grow with this organization by contributing my skills. " I - will work for the organization as long as I can meet the requirements of the organization"

10. Do you have plans of doing your higher studies?

Sir, I would like to gain more knowledge to serve the best for the organization but at present would like to earn practical experience for at least three years and then plan my higher studies.

11. Why do you say that you will not do higher studies now?

Sir, all these long years I have acquired a lot of theoretical knowledge and I believe that it's the right time to make those knowledge count by earning practical experience from your esteemed organization. And I also believe that my higher studies will have a lot of integral values with the experience that I am going to acquire at the workplace.

12. What is your salary expectation?

Sir, I'm expecting the salary according to the company's norms, designation and industry standards.

13. Can you lead a team on your own as a fresher? How and what are the strategies would you enforce to run an effective team?

Sir, gladly I would be interested to run a team as a fresher. As a leader I would know the strengths of each team member and get the best out of them. Initially I would call them to inform the nature of the job assigned and the deadline would be set for the entire project. I would be constantly monitoring and with motivation from all ends I believe things will happen.

14. What have you learnt from your failures?

"From my failures I have learnt to analyze myself and find out my shortcomings. Those shortcomings are the areas of future improvement for me and I have undertaken those factors seriously to improve myself on those relevant areas. One more thing I learned is never to give up, never to feel rejected". Quote:" Accepting a failure is a man's great trait."

15. Where do you see yourself after ten years?

I would like to gain a solid foundation in the position and I am sure as I continue to grow, there will be opportunities within the company to offer me upward professional growth and new challenges. I would like to be a person who is well verse with technical knowledge and Enhanced Soft skills.

16. How important is money to you?

Money is a good motivation for many people. I do enjoy my job but I've family and I need to support them.

NOTE 

Tell me about yourself,

About Project

The above 2 questions are most important which were not included in this blog as the answer changes for person to person.







what do you know about DXC Technologies ??

 



DXC Technology is an American multinational information technology (IT) services and consulting company headquartered Ashburn, Virginia U.S. DXC Technology was founded on April 3, 2017 when the Hewlett Packard Enterprise Company (HPE) spun off its Enterprise Services business and merged it with Computer Sciences Corporation (CSC). At the time of its creation, DXC Technology had revenues of $25 billion, employed 170,000 people and operated in 70 countries. By June 2021, the employee count of DXC has come down to 134,000. Mike Salvino is the CEO of DXC Technology. DXC Technology is a Fortune 500 global IT services leader. Our more than 130,000 people in 70-plus countries are entrusted by our customers to deliver what matters most. DXC use the power of technology to deliver mission critical IT services across the Enterprise Technology Stack to drive business impact. DXC is an employer of choice with strong values, and fosters a culture of inclusion, belonging and corporate citizenship. DXC provide services across the Enterprise Technology Stack for business process outsourcing, analytics and engineering, applications, security, cloud, IT outsourcing and modern workplace. DXC named 2021 AWS Global System Integrator Partner of the Year. DXC Technology has set ambitious targets for reducing its energy consumption, lowering its greenhouse gas emissions and shrinking its IT asset waste. DXC also help its customers to increase their energy efficiency and reduce their environmental impacts with next-generation solutions such as cloud computing, desktop virtualization and data center management.

References

https://dxc.com/us/en/about-us/awards-and-recognition

https://dxc.com/us/en/about-us/corporate-responsibility/our-environmental-targets

What do you know about Cognizant? Tell me about Cognizant.

 

Cognizant is an American multinational information technology services and consulting company. It is headquartered in Teaneck, New Jersey, United States. It was founded as an in-house technology unit of Dun & Bradstreet in 1994, and started serving external clients in 1996. Cognizant had a period of fast growth during the 2000s and became a Fortune 500 company in 2011; as of 2021, it is ranked as 185. Brian Humphries  is the CEO of Cognizant. On 1 April 2019, Francisco D'Souza was replaced by Brian Humphries as the CEO. In 1996, Dun & Bradstreet spun off several of its subsidiaries including Erisco, IMS International, Nielsen Media Research, Pilot Software, Strategic Technologies and DBSS, to form a new company called Cognizant Corporation, headquartered in Chennai, India. Three months later, in 1997, DBSS renamed itself to Cognizant Technology Solutions. In July 1997, Dun & Bradstreet bought Satyam's 24% stake in DBSS for $3.4 million. Headquarters were moved to the United States, and in March 1998, Kumar Mahadeva was named CEO. In 1998, the parent company, Cognizant Corporation, split into two companies: IMS Health and Nielsen Media Research. After this restructuring, Cognizant Technology Solutions became a public subsidiary of IMS Health. In June 1998, IMS Health partially spun off the company, conducting an initial public offering of the Cognizant stock. The company raised $34 million, less than what the IMS Health underwriters had hoped. They earmarked the money for debt payments and upgrading company offices. The company has 318,400 employees globally, of which over 150,000 are in India across 10 locations with a plurality in Chennai. On 20 Jan, 1994 Cognizant registered its branch in Chennai, Tamil Nadu, India with the legal name Cognizant Technology Solutions India Private Limited. Cognizant strategic partners are AWS, Adobe, Cisco, Google Cloud ,Hitachi. Cognizant has won an AI Breakthrough Award in 2021. Cognizant's philanthropic and corporate social responsibility (CSR) initiatives are conducted through the Cognizant employees for the financial and administrative support of the Cognizant Foundation. Registered in March 2005 as a "Charitable Company" under the Indian Companies Act, the Cognizant Foundation aims to help "unprivileged members of society gain access to quality education and healthcare by providing financial and technical support; designing and implementing educational and healthcare improvement programs; and partnering with Non-Government Organizations (NGOs), educational institutions, healthcare institutions, government agencies and corporations".

References

https://en.m.wikipedia.org/wiki/Cognizant

https://news.cognizant.com/2021-24-2021

https://www.cognizant.com/us/en/about-cognizant/partners

What you know about Capgemini ?




 

Capgemini was founded by Serge Kampf in 1967 as an enterprise management and data processing company. The company was founded as the Sogeti. In 1974 Sogeti acquired Gemini Computers Systems, a US company based in New York. In 1975, having made two major acquisitions of CAP (Centre d'Analyse et de Programmation) and Gemini Computer Systems, and following resolution of a dispute with the similarly named CAP UK over the international use of the name 'CAP', Sogeti renamed itself as CAP Gemini Sogeti. In 1996, the name was simplified to Cap Gemini with a new group logo. All operating companies worldwide were re-branded to operate as Cap Gemini. Capgemini signed an agreement with IBM to become an IBM Quantum Hub providing its clients access to IBM’s quantum computing systems as well as professional services Aiman Ezzat is the C.E.O of Capgemini. Capgemini wins 2019 Artificial Intelligence Breakthrough award for best virtual agent solution. Capgemini recognized as winner for 2019 Microsoft SAP on Azure Partner of the Year. Capgemini named a Leader in two IDC MarketScape 2019 Vendor Assessments for Utility Services. Collaboration is central to the Capgemini philosophy and a pillar of our service delivery. Capgemini is guided by the 4 dimensions of collaboration, we target value, mitigate risk, optimize capabilities, and align the organization to achieve the objective.


References

https://en.wikipedia.org/wiki/Capgemini

https://www.capgemini.com/operating-model/the-collaborative-business-experience/

https://www.capgemini.com/company-profile-key-figures/management-team/