Tech Mahindra Database Admin Interview Questions and Answers

Q1. Scenario baes questions
Add your answer

Q1. Statup parameters of sql server
Ans. 
Startup parameters are used to configure the behavior of SQL Server when it starts up.
• Startup parameters are set in the SQL Server Configuration Manager or by using the SQL Server command prompt.

• Common startup parameters include -d for specifying the location of the master database files, -m for starting SQL Server in single-user mode, and -T for enabling trace flags.

• Startup parameters can also be configured in the Win...read more
Answered by AI
Add your answer
Q2. Differential backup query
Add your answer

Q1. What is role of HAS in RAC systems?
Ans. 
HAS (High Availability Services) in RAC systems provides automatic failover and load balancing for improved system reliability.
• HAS monitors the health of each node in the RAC cluster

• It automatically relocates services to healthy nodes in case of node failure

• It ensures high availability and scalability for the RAC system

• Examples: Oracle Clusterware, Oracle Grid Infrastructure
Answered by AI
Add your answer

Q1. How would you manage the upcoming challenging opportunities in the new role?
Add your answer

Q1. What is database ? And type of sql
Ans. 
A database is a structured collection of data. SQL is a language used to manage and manipulate databases.
• A database is a software system that stores and organizes data.

• It allows users to create, read, update, and delete data.

• SQL (Structured Query Language) is a programming language used to communicate with and manage databases.

• There are different types of databases such as relational databases, object-oriented database...read more
Answered by AI
View 1 more answer
Q2. Write the sql command of the database
Ans. 
SQL command of which database?
• Specify the name of the database you want the SQL command for

• Provide the specific query you want to execute

• Ensure that the syntax is correct and the query is optimized

• Examples: SELECT * FROM table_name; INSERT INTO table_name (column1, column2) VALUES (value1, value2);
Answered by AI
Add your answer
Q3. For example ,select *from employee table
Add your answer

Q1. Performance tuning and high availability
Add your answer
Q2. Allways on and log shipping
Add your answer

Q1. Process of mysql replication
Ans. 
MySQL replication is the process of copying data from one database server to another in real-time.
• MySQL replication involves a master server and one or more slave servers.

• Changes made on the master server are logged and then applied to the slave servers.

• Replication can be asynchronous or synchronous, with asynchronous being more common.

• Replication can be used for load balancing, failover, and data backup purposes.
Answered by AI
Add your answer

I am a B.sc computer science graduated
I am a fresher
I am live in Kolhapur
Shivaji University Kolhapur

Q1. Java subject interview question
Add your answer
Q2. Java subject asking me please
Add your answer