TCS SQL Server Database Administrator Interview Questions and Answers

Question in sql and plsql about

It was good experience to complete tgat

Q1. What is pull request
Ans. 
A pull request is a method of submitting contributions to a project on GitHub for review and merging.
• Pull requests are commonly used in version control systems like Git to propose changes to a codebase.

• They allow developers to collaborate and discuss changes before merging them into the main branch.

• Pull requests typically include a description of the changes, related issues, and any necessary tests or documentation.

• Rev...read more
Answered by AI
Add your answer

Q1. What is sateful set
Ans. 
Stateful set is a Kubernetes controller that manages the deployment and scaling of a set of pods with persistent storage.
• Stateful set ensures that each pod in the set has a unique identity and stable network identity.

• Stateful set pods are created in order and are not replaced until they are deleted.

• Stateful set is commonly used for stateful applications like databases where each pod requires persistent storage.

• Example:...read more
Answered by AI
Add your answer

Q1. Start up parameters of sql server
Ans. 
Start up parameters are used to configure the behavior of SQL Server when it starts up.
• Start up parameters are specified in the SQL Server Configuration Manager.

• Common start up parameters include -d (database files location), -e (error log location), -m (single user mode), -T (trace flags), etc.

• Start up parameters can be modified to customize the behavior of SQL Server during startup.

• Example: -dC:\Program Files\Microso...read more
Answered by AI
Add your answer
Q2. Differential backup query
Add your answer
Q3. Sql server statics
Add your answer
Q4. Log file architecture
Add your answer

Q1. Dataguard architecture
Add your answer
Q2. Rman backup and restoration
Add your answer

Q1. Why you join inm
Ans. 
I joined inm because of the company's reputation for innovation and growth in the tech industry.
• Attracted to company's reputation for innovation

• Excited about opportunities for growth in tech industry

• Impressed by company culture and values
Answered by AI
Add your answer

Q1. Architecture of sql
Ans. 
SQL architecture refers to the structure and components of a SQL database system.
• SQL architecture includes components like storage engine, query processor, and buffer manager.

• The storage engine manages data storage and retrieval, while the query processor processes SQL queries.

• The buffer manager handles caching and memory management to optimize performance.

• Examples of SQL architectures include MySQL, Oracle, and SQL Se
Answered by AI
Add your answer
Q2. Recovery models
Add your answer

Sql queries on top clause

Q1. Why u want to join
Ans. 
I am passionate about database management and eager to contribute my skills to your team.
• I have a strong background in database administration

• I am excited about the opportunity to work with a reputable company like yours

• I am eager to learn and grow in my career as a SQL DBA
Answered by AI
Add your answer
Q2. What is the salary expectation
Ans. 
I am looking for a competitive salary based on my experience, skills, and the responsibilities of the role.
• Research the average salary range for MS SQL DBAs in your location and industry

• Consider your years of experience and any specialized skills or certifications you have

• Be prepared to negotiate based on the specific responsibilities and requirements of the role
Answered by AI
Add your answer

Q1. Why this company
Ans. 
I am impressed by the company's innovative technology solutions and strong reputation in the industry.
• The company has a track record of developing cutting-edge technology solutions.

• I admire the company's commitment to excellence and continuous improvement.

• The company's reputation for providing top-notch training and development opportunities is appealing to me.
Answered by AI
Add your answer
Q2. What salary do you expect
Ans. 
I expect a competitive salary based on my experience, skills, and the market rate for Oracle Database Administrators.
• Research the average salary range for Oracle Database Administrators in your area

• Consider your level of experience and skills when determining your salary expectations

• Be prepared to negotiate based on the specific responsibilities and benefits offered by the employer
Answered by AI
Add your answer