Deloitte Business Technology Analyst Interview Questions, Process, and Tips for Experienced

Easy to medium difficulty mcq questions

Q1. Just a minute round with a technical topic
Add your answer
Q2. Use of AI in health care
Add your answer

Q1. Basic testing concepts SQL joins
Add your answer

Q1. SQL queries using where use of having, group by Difference between DELETE & TRUNCATE
Add your answer

Q1. Scenario based testing concept like how will you deal if issues comes in production
Add your answer

Q1. Speaking, listening, reading test
Add your answer

Q1. How did you come to know about Deloitte?
Ans. 
Through research on top consulting firms and networking with professionals in the industry.
• Researched top consulting firms online and Deloitte consistently appeared as a top choice

• Attended networking events where professionals in the industry spoke highly of Deloitte's reputation

• Received recommendations from professors or mentors to consider Deloitte for career opportunities
Answered by AI
Add your answer
Q2. How do you use logminer?
Ans. 
LogMiner is a utility provided by Oracle to analyze and mine redo log files for data changes.
• LogMiner is used to analyze and extract data from redo log files generated by Oracle databases.

• It can be used for tasks like auditing, troubleshooting, and recovering lost data.

• LogMiner can help track changes made to the database, such as INSERT, UPDATE, and DELETE operations.
Answered by AI
Add your answer
Q3. How do you clone database?
Ans. 
Cloning a database involves creating an exact copy of an existing database.
• Use database management tools like SQL Server Management Studio or MySQL Workbench to clone a database.

• Backup the existing database before cloning to avoid data loss.

• Restore the backup file to create a new database with the same schema and data.

• Update connection strings and configurations to point to the new cloned database.

• Test the cloned datab...read more
Answered by AI
Add your answer
Q4. What are the backup strategies?
Ans. 
Backup strategies are plans and procedures put in place to protect data in case of loss or corruption.
• Regularly scheduled backups to ensure data is up to date

• Offsite backups to protect against physical damage or theft

• Incremental backups to save storage space and time

• Automated backups to reduce human error

• Testing backups to ensure they can be restored successfully
Answered by AI
Add your answer
Q5. How do you find block level corruption and resolve it?
Ans. 
Block level corruption can be found using tools like checksums and resolved by restoring from backups or repairing the corrupted blocks.
• Use checksums to detect block level corruption by comparing the checksum of the data against a known good checksum.

• Regularly run integrity checks on storage devices to identify any corrupted blocks.

• Restore the corrupted blocks from backups if available, or repair them using tools like ...read more
Answered by AI
Add your answer
Q6. In shell scripting how to use a particular type shell like korn or bash shell ?
Ans. 
To use a particular type of shell like korn or bash shell in shell scripting, specify the shell at the beginning of the script.
• Specify the shell at the beginning of the script using the shebang line (#!/bin/bash for bash shell, #!/bin/ksh for korn shell, etc.)

• Make sure the specified shell is installed on the system where the script will be executed

• Use shell-specific syntax and features in the script based on the chosen
Answered by AI
Add your answer

Q1. What is BDE in Infor LN ?
Add your answer
Q2. How does Infor ION works & implementation done on number of projects
Ans. 
Infor ION is a middleware platform that connects disparate systems and enables data exchange.
• Infor ION uses a publish-and-subscribe model to facilitate communication between systems.

• It can be implemented on a variety of projects, including ERP, CRM, and supply chain management systems.

• Infor ION also includes pre-built connectors for popular systems like Salesforce and SAP.

• Implementation typically involves configuring t...read more
Answered by AI
Add your answer
Q3. Basics of ERP LN & Cloudsuite
Add your answer

Q1. Basics of ERP Implementation
Add your answer

Q1. Basics of ERP Implementation
Add your answer

Q1. Basics of ERP Implementation
Add your answer