HCLTech SQL Database Administrator Interview Questions and Answers for Experienced

Q1. End to end approach when given data.
Add your answer
Q2. Diff in clustered index and non clustered index with example
Ans. 
Clustered index determines physical order of data while non-clustered index is a separate structure.
• Clustered index sorts and stores data in the table based on the key values

• Non-clustered index creates a separate structure to store the index data

• Clustered index can only be created on one column while non-clustered index can be created on multiple columns

• Example: Clustered index on a customer table can be created on the...read more
Answered by AI
Add your answer
Q3. Diff composite and non composite key and then to create primary key without defining primary key what are other alternatives. Ana - Like. Unique, not null, candidate key.
Ans. 
Composite key is made up of multiple columns while non-composite key is made up of a single column. Primary key can also be defined using unique, not null, or candidate key.
• Composite key uses multiple columns to uniquely identify a row while non-composite key uses a single column

• Primary key can be defined using unique, not null, or candidate key instead of explicitly defining it

• Candidate key is a unique key that can be
Answered by AI
Add your answer
Q4. Recursive stored Procedure Optimising techniques Recovery and backup. How to do Loading of Jason file in sql How is Scheduling done On/off set count with curser example.
Ans. 
Questions on SQL Database Administration including recursive stored procedures, optimization, recovery and backup, loading JSON files, scheduling, and cursor examples.
• For recursive stored procedures, use common table expressions (CTEs) to simplify the code

• Optimization techniques include indexing, query tuning, and partitioning

• Regular backups and testing of recovery procedures are essential for data protection

• To load JS...read more
Answered by AI
Add your answer
Q5. There were many more sql question is been asked by giving scenario and tables.
Add your answer

Q1. Formal discussion and salary negotiations
Add your answer

Q1. Discussion about roles and responsibilities
Add your answer

Q1. What major issues have you faced in your professional experience?
Add your answer

Q1. What are your salary expectations for this position?
Add your answer

Q1. Basics of SQL and Joins
Add your answer

Aptitude test was conducted.

Q1. Technical questions were asked
Add your answer

Q1. What's the salary expectation
Add your answer

It was good interview everyone was friendly

Q1. Why are you switching your current job
Ans. 
Seeking new challenges and growth opportunities in a more dynamic environment.
• Looking for new challenges and opportunities for growth

• Interested in working in a more dynamic environment

• Seeking to expand my skills and knowledge in a different setting
Answered by AI
Add your answer
Q2. What is your expected CTC
Ans. 
My expected CTC is negotiable based on the job responsibilities and market standards.
• My expected CTC is based on my experience, skills, and the job requirements.

• I am open to discussing the salary range during the interview process.

• I am looking for a competitive salary package that aligns with industry standards.

• I am flexible and willing to consider other benefits in addition to the salary.
Answered by AI
Add your answer

Q1. Surprisingly, the person started asking knowledge about Linux commands.
Add your answer
Q2. Grep, Kill, Call, chmode etc. etc. .
Add your answer
Q3. Syntaxes, rwx combo etc. .
Add your answer

Q1. Basic questions
Add your answer

Q1. Asking over past experience
Add your answer
Q2. RAC and GG related questions. Data guard gap resolve. RMAN scenario based question. Oracle architecture.
Add your answer