Tata Play Manager Interview Questions and Answers for Experienced

Q1. About work experience & job profile Manpower handling Vendors management Material management Operations task KPI
Add your answer

Q1. About company & his vision
Add your answer

It is a 30 minute test based on genral aptitude questions

Q1. Database and types of DBMS?
Ans. 
A database is a collection of organized data. Types of DBMS include relational, object-oriented, hierarchical, and network.
• Relational DBMS: Organizes data into tables with rows and columns. Examples include MySQL, Oracle, and SQL Server.

• Object-oriented DBMS: Stores data as objects. Examples include MongoDB and Cassandra.

• Hierarchical DBMS: Organizes data in a tree-like structure. Example: IBM's Information Management Sy...read more
Answered by AI
View 1 more answer
Q2. What is SQL and tell two query?
Ans. 
SQL is a programming language used for managing and manipulating relational databases.
• SQL stands for Structured Query Language.

• It is used to communicate with and manipulate databases.

• Two common types of SQL queries are SELECT and UPDATE.

• SELECT query is used to retrieve data from a database.

• Example: SELECT * FROM Customers;

• UPDATE query is used to modify existing data in a database.

• Example: UPDATE Customers SET City = 'N
Answered by AI
View 1 more answer

Q1. Need confidence don't worrk about experience whatever you have idea we have to input then only we will take our goals
Add your answer

Q1. What are the challenges you have faced in previous company ?
Ans. 
Faced challenges in team dynamics, project deadlines, and resource allocation, which enhanced my problem-solving skills.
• Team Dynamics: Managed conflicts between team members that affected collaboration. Implemented regular check-ins to improve communication.

• Project Deadlines: Encountered tight deadlines on a critical project. Prioritized tasks and delegated effectively, resulting in on-time delivery.

• Resource Allocation...read more
Answered by AI
Add your answer
Q2. Oracle Architecture & its functions
Ans. 
Oracle Architecture consists of various components that manage data storage, retrieval, and processing efficiently.
• 1. Oracle Database: The core component that stores data in tables and manages data retrieval.

• 2. Instance: The combination of memory structures and background processes that manage database files.

• 3. SGA (System Global Area): A shared memory area that contains data and control information for the Oracle inst...read more
Answered by AI
Add your answer
Q3. Data Guard steps
Add your answer
Q4. Performance Tunning
Add your answer
Q5. Backup & Recovery
Add your answer
Q6. Patching & Upgradation
Add your answer
Q7. Database Migration
Add your answer
Q8. Multiple database knowledge
Add your answer
Q9. Challenges faced while working
Ans. 
I faced various challenges in my previous roles, including team dynamics, project deadlines, and resource management.
• Team Dynamics: Navigating conflicts between team members, such as when two colleagues disagreed on project direction, required mediation skills.

• Project Deadlines: Managing tight deadlines, like when a key project was moved up by two weeks, necessitated prioritization and effective communication.

• Resource ...read more
Answered by AI
Add your answer
Q10. Support party for every databases
Add your answer

Q1. RTR and related process
Add your answer
Q2. AML and KYC process
Add your answer

Q1. Your experience,Qualifications, expertise
Add your answer

Q1. Reason of switching the job
Add your answer

Devise a marketing plan for one of the top channels