Lochan & Company Associate 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

Q1. Previous company key responsibilities
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

Q1. Market research related and market estimation
Add your answer

Aptitude test contains 2 round - 1. Report writing 2. Basic Apti questions

Q1. Basic Introduction about experience
Add your answer
Q2. Past experience and resume discussions
Add your answer
Q3. Questions regarding skills like excel, tablue - simple basic questions
Add your answer

Q1. Basic intro with team manager
Add your answer
Q2. Discussion about roles and responsibilities
Add your answer
Q3. Questions regarding primary and secondary research, CATI and CAWI (have you done or not) normal discussion on compensations
Add your answer

Questions related to Data Interpretation, logical reasoning and mathematics

Q1. What would be my approach for conducting a research for a market?
Ans. 
To conduct research for a market, one should start by defining the research objectives, identifying the target audience, collecting relevant data, analyzing the data, and drawing conclusions.
• Define the research objectives and goals

• Identify the target audience and market segment

• Collect primary and secondary data through surveys, interviews, and market reports

• Analyze the collected data using statistical tools and techniq...read more
Answered by AI
View 1 more answer

Q1. Basic details personal information experience
Add your answer

Write up on topic given by them