iResearch Services 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

Nothing much just some idiotic questions. office has no member strength, they just call and make candidate wait for 4 hours and recruit referred candidates

Q1. Even after attending all queries they did not bother to select and inform and selection process starts based on references.
Add your answer
Q2. Reporting, analysis
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

Aptitude test of 30 min is conducted

Normal aptitude questions

Q1. Interview with manager
Add your answer