Chopra Autotech Interview Questions and Answers

There are simple technical test before manger round and it was very easy to crack

Q1. Why you interested in this job
Add your answer
Q2. Are you comfortable in rational shift
Add your answer
Q3. Tell me something about your study
Add your answer
Q4. Do you read all the policy about companies
Ans. 
Yes, I make sure to thoroughly read and understand all company policies.
• I believe it is important to read and understand company policies to ensure compliance and avoid any misunderstandings.

• Reading company policies helps me stay informed about the rules and regulations within the organization.

• I make it a priority to review and familiarize myself with all policies to ensure I am following the correct procedures.

• For exa...read more
Answered by AI
Add your answer

Q1. Why this job you want to do
Add your answer
Q2. Why this job in gfk
Add your answer

Moderate level, maths reasoning questions

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

Aptitude test of 30 min is conducted

Basic aptitude questions of quant and reasoning and general english

Case study of varies products asked around 15-20 which were easy to attempt

Q1. About yourself, practical knowledge, family, data related,etc.
Add your answer
Q2. What is sql. Excel formulas
Ans. 
SQL is a programming language used for managing and manipulating relational databases. Excel formulas are used for performing calculations and data analysis in Microsoft Excel.
• SQL is used to retrieve, insert, update, and delete data from databases.

• Excel formulas are written using functions and operators to perform calculations and manipulate data.

• SQL example: SELECT * FROM customers WHERE age > 30;

• Excel formula example...read more
Answered by AI
Add your answer

Normal aptitude questions

Q1. Interview with manager
Add your answer