LTIMindtree Database Admin Interview Questions and Answers

Q1. Scenario baes questions
Add your answer

Multiple choice which is conducted in online and they asked me to take help from google as well to finish the aptitude but the questions which is asked is bit hard

Q1. Related to SQL and GTM
Add your answer
Q2. What is standalone database
Ans. 
A standalone database is a database that is independent and does not require connection to a network or other databases.
• Standalone databases are typically used for small-scale applications or for testing purposes.

• They do not rely on a network connection to function.

• Examples of standalone databases include SQLite and Microsoft Access.
Answered by AI
Add your answer
Q3. How to segregate alphabet and numbers in a table
Ans. 
Use SQL queries to segregate alphabet and numbers in a table
• Use the SQL function REGEXP to filter out alphabets and numbers

• For example, to select only alphabets: SELECT column_name FROM table_name WHERE column_name REGEXP '^[a-zA-Z]'

• For numbers: SELECT column_name FROM table_name WHERE column_name REGEXP '^[0-9]'
Answered by AI
Add your answer

Q1. Database related
Add your answer

Q1. Salary expectation
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. All technical knowledge
Add your answer
Q2. Any challenges that you faced
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