TEG Analytics Analytics Consultant Interview Questions and Answers

Q1. Installation and upgradation steps
Add your answer
Q2. Patching and performance tuning
Add your answer

Q1. Table space is full what action need to take
Ans. 
Free up space by deleting unnecessary data or increasing table space size.
• Identify which table space is full

• Check if there are any unnecessary data that can be deleted

• Increase the size of the table space if necessary

• Consider partitioning the table to distribute data across multiple table spaces
Answered by AI
Add your answer
Q2. Datafile addition to tablespace
Ans. 
Adding a datafile to a tablespace
• Use ALTER TABLESPACE statement to add datafile

• Ensure enough disk space is available

• Monitor tablespace usage regularly

• Example: ALTER TABLESPACE users ADD DATAFILE '/u01/app/oracle/oradata/db1/users02.dbf' SIZE 50M;
Answered by AI
Add your answer
Q3. How to add datafile to tablespace
Ans. 
To add a datafile to a tablespace:
• Identify the tablespace where the datafile needs to be added

• Create a new datafile using the 'CREATE DATAFILE' command

• Add the new datafile to the tablespace using the 'ALTER TABLESPACE' command

• Ensure that the new datafile is of the correct size and location
Answered by AI
Add your answer

Report writing- you have to present a market research overview on any of industry you can visit on their website for same

Q1. Analyse market trends
Ans. 
Market trends can be analyzed by examining consumer behavior, industry reports, and economic indicators.
• Examine consumer behavior through surveys and focus groups

• Review industry reports and forecasts for insights

• Monitor economic indicators such as GDP growth and inflation rates

• Look for emerging technologies or innovations that could impact the market

• Consider geopolitical events or regulatory changes that may influence
Answered by AI
Add your answer
Q2. Guest estimate for any industry
Ans. 
Guest estimate for any industry refers to the practice of predicting the number of guests or customers a business may expect to receive within a certain period of time.
• Consider historical data and trends to make an educated guess

• Take into account external factors such as seasonality, holidays, and economic conditions

• Utilize forecasting models or software to help with the estimation process
Answered by AI
Add your answer

Normal Group discussion

Q1. Cosing, project management etc
Add your answer

Interviewer himself did not knew python or any other data analysis language

Excel, questions that were open ended

Q1. How will you work under female manager
Ans. 
I will work under a female manager just like I would under any other manager - with professionalism, respect, and open communication.
• I will communicate openly and honestly with my female manager, just as I would with any other manager.

• I will respect her authority and expertise, and follow her guidance and instructions.

• I will collaborate effectively with my female manager and the rest of the team to achieve our goals.

• I ...read more
Answered by AI
Add your answer
Q2. Are you willing to work for lower salary than previous
Ans. 
I am open to discussing salary based on the overall compensation package and opportunities for growth.
• I am open to discussing salary based on the overall compensation package and opportunities for growth.

• I would like to understand the reasons for the lower salary offer and how it aligns with the company's budget and market standards.

• I am willing to negotiate other benefits such as flexible work hours, additional vacati...read more
Answered by AI
Add your answer
Q3. Will your accomodation or salary structure needed to be validated in case you got married
Add your answer
Q4. Will you work till 1 am in the morning as bjp politicians client can ask anything anytime
Add your answer

Q1. Why ai and machine learning is only marketing term and not a real technology
Ans. 
AI and machine learning are real technologies with practical applications in various industries.
• AI and machine learning have been successfully used in various industries such as healthcare, finance, and transportation to improve efficiency and accuracy.

• Companies like Google, Amazon, and Facebook heavily rely on AI and machine learning algorithms to enhance their products and services.

• AI and machine learning technologie...read more
Answered by AI
Add your answer
Q2. Why python is an awful language and would you be willing to work as a back end developer using spring or Node
Ans. 
Python is not an awful language, but I am open to working with other technologies like Spring or Node.
• Python is a versatile and widely-used language in data analysis and machine learning.

• It has a large community and extensive libraries like Pandas and NumPy.

• Spring and Node are also popular choices for backend development, offering different strengths and capabilities.

• I am open to learning and working with new technolog
Answered by AI
Add your answer

Q1. Will you work under bond of 2 yrs ?
Ans. 
I am open to discussing the terms of the bond and considering the overall opportunity.
• I am willing to consider a bond if the terms are reasonable and the opportunity aligns with my career goals.

• I would like to discuss the details of the bond such as its purpose, consequences of breaking it, and any potential benefits for me.

• I may negotiate the duration of the bond or explore alternative options to ensure a mutually ben...read more
Answered by AI
Add your answer
Q2. We will give 30% of your salary as Variable pay after completion of 1 yr but we will decide when to give it to you. Would you still be willing to work for us as working for our company is a prestigious opp...read more
Ans. 
I would consider the offer based on the overall compensation package and career growth opportunities.
• I would need more information on the overall compensation package to make a decision.

• I would also consider the potential career growth opportunities and learning experiences at the company.

• It would be important to understand the criteria and timing for receiving the variable pay.

• I would evaluate the offer based on my lo...read more
Answered by AI
Add your answer

Q1. Tell me about you
Add your answer
Q2. Basically every question asked is related to you given project
Add your answer

I waa given telecom market in indua

Simple math anyone can solve it

Q1. Project details
Add your answer
Q2. Hobbies were asked and asked to show proof
Add your answer
Q3. Face to face interview with HR questions
Add your answer