Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by DXC Technology Team. If you also belong to the team, you can get access from here

DXC Technology Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

DXC Technology Interview Questions, Process, and Tips

Updated 7 Mar 2025

Top DXC Technology Interview Questions and Answers

View all 424 questions

DXC Technology Interview Experiences

Popular Designations

796 interviews found

MS SQL DBA Interview Questions & Answers

user image Anonymous

posted on 12 Dec 2020

I applied via Naukri.com and was interviewed before Dec 2019. There were 3 interview rounds.

Interview Questionnaire 

32 Questions

  • Q1. Introduce yourself
  • Q2. What are blockings ? What are deadlocks and difference to blockings ?
  • Ans. 

    Blockings occur when one transaction holds a lock on a resource, preventing other transactions from accessing it. Deadlocks are a specific type of blocking where two or more transactions are waiting for each other to release resources.

    • Blockings happen when one transaction holds a lock on a resource and other transactions are blocked from accessing it.

    • Deadlocks occur when two or more transactions are waiting for each ot...

  • Answered by AI
  • Q3. How to know about deadlocks in sql server?
  • Ans. 

    Deadlocks in SQL Server can be identified using SQL Server Profiler or by querying the system_health extended event session.

    • Use SQL Server Profiler to capture deadlock events

    • Query the system_health extended event session to view deadlock graphs

    • Use sp_whoisactive to identify blocking and deadlocking processes

    • Enable trace flag 1222 to capture deadlock information in the SQL Server error log

  • Answered by AI
  • Q4. What is the parameter (-1) used in DBCC TRACEON(1204,-1) ? Why it is used?
  • Ans. 

    Parameter (-1) in DBCC TRACEON(1204,-1) is used to enable deadlock tracing for all sessions.

    • DBCC TRACEON(1204,-1) enables deadlock tracing for all sessions

    • The parameter -1 specifies that the trace flag should be enabled for all sessions

    • Deadlock tracing helps identify and resolve deadlocks in SQL Server

  • Answered by AI
  • Q5. What is the backup strategy you have?
  • Ans. 

    Our backup strategy includes full backups weekly, differential backups daily, and transaction log backups every 15 minutes.

    • Weekly full backups

    • Daily differential backups

    • Transaction log backups every 15 minutes

    • Backups stored on separate disk

    • Regular testing of backups for restoration

  • Answered by AI
  • Q6. What is point in time recovery?
  • Ans. 

    Point in time recovery is the ability to restore a database to a specific moment in time.

    • It allows for recovery of data up to a specific point in time.

    • It requires regular backups and transaction logs.

    • It is useful in case of accidental data deletion or corruption.

    • It can be done manually or through automated tools.

    • Example: Restoring a database to its state before a specific transaction occurred.

  • Answered by AI
  • Q7. What are the issues you faced in log shipping?
  • Ans. 

    Issues faced in log shipping

    • Network latency causing delays in log shipping

    • Log backups not being taken frequently enough

    • Failure to restore logs due to mismatched log backups

    • Lack of monitoring and alerting for log shipping failures

  • Answered by AI
  • Q8. What are some critical issues you faced in your previous projects?
  • Q9. While applyong patching, some msi files are missing ? How do you resolve this?
  • Ans. 

    Check if the missing msi files are required for the patch. If yes, download and install them.

    • Verify if the missing msi files are essential for the patch

    • Check if the msi files are available in the original installation media or backup

    • If not, download the missing msi files from the vendor's website

    • Install the missing msi files before applying the patch

  • Answered by AI
  • Q10. Do you have idea on replication ?
  • Ans. 

    Yes, replication is the process of copying and distributing data from one database to another.

    • Replication is used to improve data availability, scalability, and disaster recovery.

    • It involves a publisher database that sends data to one or more subscriber databases.

    • There are three types of replication: snapshot, transactional, and merge.

    • Snapshot replication copies the entire database to the subscriber.

    • Transactional repli...

  • Answered by AI
  • Q11. How to index reorganize and index rebuild based on index fragmentation?
  • Ans. 

    Index reorganize and rebuild based on fragmentation level

    • For fragmentation level < 5%, use reorganize

    • For fragmentation level > 30%, use rebuild

    • For fragmentation level between 5% and 30%, choose based on table size and usage

    • Use ALTER INDEX statement to perform reorganize or rebuild

    • Monitor fragmentation level regularly to maintain optimal performance

  • Answered by AI
  • Q12. When to update statistics with respect to index rebuild and reorganize ? (Maintenance plans)
  • Ans. 

    Updating statistics is necessary after index rebuild or reorganize to ensure query optimization.

    • Statistics provide information about the distribution of data in a table or index.

    • Index rebuild or reorganize can change the distribution of data, making old statistics inaccurate.

    • Outdated statistics can lead to poor query performance.

    • Updating statistics after index rebuild or reorganize ensures query optimization.

    • Maintenanc

  • Answered by AI
  • Q13. What is the database size you jave used in your previous project?
  • Ans. 

    The database size I have used in my previous project was approximately 500 GB.

    • The database size was around 500 GB.

    • It contained various tables, indexes, and stored procedures.

    • The data included millions of records from different sources.

    • We regularly optimized the database to ensure efficient performance.

    • Backup and recovery strategies were implemented to safeguard the data.

  • Answered by AI
  • Q14. What is the backup strategy for the biggest database you handled?
  • Ans. 

    The backup strategy for the biggest database I handled involved regular full backups, daily differential backups, and hourly transaction log backups.

    • Regular full backups were performed to capture the entire database.

    • Daily differential backups were taken to capture the changes since the last full backup.

    • Hourly transaction log backups were taken to capture the changes since the last differential backup.

    • Backups were store...

  • Answered by AI
  • Q15. Every day i take full backup at midnight, log backup every one hour. Can i perform point in time recovery upto 07:30pm ?
  • Q16. What is the command for the Tail log backup?
  • Ans. 

    The command for Tail log backup is BACKUP LOG WITH NORECOVERY

    • Use the BACKUP LOG command to create a tail log backup

    • Add the WITH NORECOVERY option to allow further log backups

    • Tail log backups are used to capture any transactions that occurred after the last log backup

    • Syntax: BACKUP LOG database_name TO disk = 'backup_device' WITH NORECOVERY

  • Answered by AI
  • Q17. What is your notice period in your current company?
  • Q18. Do you have any idea on SQL Profiler ?
  • Ans. 

    SQL Profiler is a tool used to capture and analyze SQL Server events and activities.

    • SQL Profiler captures events such as queries, stored procedures, and errors.

    • It can be used to troubleshoot performance issues and optimize queries.

    • Profiling can be done on a live server or on a trace file.

    • Events can be filtered and grouped for easier analysis.

    • SQL Profiler has been replaced by Extended Events in newer versions of SQL Ser

  • Answered by AI
  • Q19. If TempDB is full, how do you resolve it?
  • Ans. 

    To resolve TempDB full issue, identify the cause and take appropriate action.

    • Identify the cause of TempDB full issue using DMVs or third-party tools

    • Check for long-running transactions or open transactions

    • Check for large sorts or hash joins

    • Increase the size of TempDB or add more files

    • Move TempDB to a faster disk

    • Restart SQL Server to clear TempDB

    • Modify application code to reduce TempDB usage

  • Answered by AI
  • Q20. What are the isolation levels in sql server?
  • Ans. 

    Isolation levels in SQL Server determine how transactions interact with each other.

    • There are five isolation levels: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SNAPSHOT, and SERIALIZABLE.

    • Each level has its own trade-offs between concurrency and consistency.

    • The default isolation level is READ COMMITTED.

    • Isolation levels can be set at the transaction level or for the entire database.

    • For example, the SNAPSHOT isolat...

  • Answered by AI
  • Q21. What is the default isolation level in sql server? What happens with that isolation level ?
  • Ans. 

    The default isolation level in SQL Server is READ COMMITTED. It ensures that each transaction sees only committed data.

    • The default isolation level in SQL Server is READ COMMITTED.

    • READ COMMITTED ensures that each transaction sees only committed data.

    • It provides a balance between concurrency and data consistency.

    • Under READ COMMITTED, a transaction can read data that has been modified by another transaction but not yet co...

  • Answered by AI
  • Q22. What is the default port of sql server & Can we change the default port, if so where can we change it?
  • Ans. 

    The default port of SQL Server is 1433. Yes, we can change the default port by modifying the SQL Server Configuration Manager.

    • The default port for SQL Server is 1433.

    • To change the default port, open SQL Server Configuration Manager.

    • Navigate to SQL Server Network Configuration and select Protocols for the desired SQL Server instance.

    • Right-click on TCP/IP and choose Properties.

    • In the IP Addresses tab, scroll down to the ...

  • Answered by AI
  • Q23. If someone has deleted the table in a database, then how can you find out the user that has deleted the table ? Can you find out using the log file? Can you retsore the table using the tail log backup?
  • Ans. 

    Yes, the user who deleted the table can be identified using the transaction log file.

    • To find out the user who deleted the table, you can query the transaction log file using the fn_dblog function.

    • The transaction log contains information about all the transactions performed on the database, including the table deletion.

    • By analyzing the log records, you can identify the specific transaction that deleted the table and ret...

  • Answered by AI
  • Q24. When we run CheckDB, what command it runs in the background ?
  • Ans. 

    CheckDB runs DBCC CHECKDB command in the background.

    • CheckDB is a command used to check the logical and physical integrity of all objects in the specified database.

    • DBCC CHECKDB is the command that CheckDB runs in the background.

    • DBCC CHECKDB checks the allocation and structural integrity of all the objects in the specified database.

    • DBCC CHECKDB also checks for common errors like torn pages, index and data page corruption

  • Answered by AI
  • Q25. What is the difference between Summary.txt and Detail.txt ?
  • Ans. 

    Summary.txt contains summarized information while Detail.txt contains detailed information.

    • Summary.txt provides a brief overview of data while Detail.txt provides a more comprehensive view.

    • Summary.txt may contain aggregated data while Detail.txt contains individual data points.

    • Summary.txt is useful for quick analysis while Detail.txt is useful for in-depth analysis.

    • Example: Summary.txt may contain total sales for a mon...

  • Answered by AI
  • Q26. Do you use any monitoring tool for monitoring Sql server?
  • Ans. 

    Yes, I use SQL Server Management Studio (SSMS) and SQL Server Profiler for monitoring SQL Server.

    • I use SSMS to monitor server activity, query performance, and resource usage.

    • I use SQL Server Profiler to capture and analyze SQL Server events and performance data.

    • I also use third-party tools like SolarWinds Database Performance Analyzer and Redgate SQL Monitor for more advanced monitoring and alerting.

    • Regularly monitorin...

  • Answered by AI
  • Q27. What ticketing tool you use?
  • Ans. 

    We use ServiceNow as our ticketing tool.

    • ServiceNow is a cloud-based platform that offers IT service management (ITSM), IT operations management (ITOM), and IT business management (ITBM) solutions.

    • It allows us to manage incidents, problems, changes, and service requests in a single system.

    • We can also track the status of tickets, assign them to team members, and set priorities and deadlines.

    • ServiceNow also provides repor...

  • Answered by AI
  • Q28. What do you used to do using the ticketing tool?
  • Ans. 

    I used the ticketing tool to track and manage database-related issues and requests.

    • Create and assign tickets for database-related issues and requests

    • Monitor ticket status and update as necessary

    • Communicate with stakeholders regarding ticket status and resolution

    • Close tickets once issues are resolved

    • Generate reports on ticket volume and resolution time

  • Answered by AI
  • Q29. Will you only work on the tickets or do you raise any tickets ?
  • Q30. Do you have any questions to me?
  • Q31. Are you fine with rotational shifts?
  • Q32. Are you immediate joiner?

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well on routine activites of your job role as SQL DBA.

Skills evaluated in this interview

Top DXC Technology MS SQL DBA Interview Questions and Answers

Q1. If someone has deleted the table in a database, then how can you find out the user that has deleted the table ? Can you find out using the log file? Can you retsore the table using the tail log backup?
View answer (3)

MS SQL DBA Interview Questions asked at other Companies

Q1. If someone has deleted the table in a database, then how can you find out the user that has deleted the table ? Can you find out using the log file? Can you retsore the table using the tail log backup?
View answer (3)
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

Artificial Intelligence Developer Interview Questions asked at other Companies

Q1. what is difference between array and liked list?
View answer (1)
DXC Technology Interview Questions and Answers for Freshers
illustration image
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
No response

I applied via Job Portal and was interviewed in Dec 2024. There was 1 interview round.

Top DXC Technology Windows Server Administrator Interview Questions and Answers

Q1. What is the potential of artificial intelligence (AI)?
View answer (1)

Windows Server Administrator Interview Questions asked at other Companies

Q1. Do the files need to be downloaded to a particular director
View answer (1)
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I appeared for an interview in Feb 2025.

Interview Preparation Tips

Interview preparation tips for other job seekers - Good company salary come in time

Change Manager Interview Questions asked at other Companies

Q1. What is the difference between emergency and urgent change? Emergency change is raised to resolve an incident. It doesn’t follow the normal change process and do not have a lead time. ECAB needs to be arranged. Urgent change needs to be imp... read more
View answer (1)

DXC Technology interview questions for popular designations

 Associate Software Engineer

 (50)

 Associate Professional

 (37)

 Software Engineer

 (36)

 Associate Professional Software Engineer

 (27)

 Software Developer

 (21)

 Associate Engineer

 (18)

 Business Analyst

 (16)

 Senior Assistant Service Delivery Coordinator

 (15)

Office Clerk Interview Questions & Answers

user image Anonymous

posted on 4 Jan 2025

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.

Interview Preparation Tips

Interview preparation tips for other job seekers - My total experience is with the HQ 22 INF Division, spanning 10 years, and if I join, I will do my best.

Office Clerk Interview Questions asked at other Companies

Q1. if compney not give slary in pendamic sitution what u do with compney
View answer (1)

Get interview-ready with Top DXC Technology Interview Questions

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 23 Feb 2025

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

Data Engineer Interview Questions asked at other Companies

Q1. Optimal Strategy for a Coin Game You are playing a coin game with your friend Ninjax. There are N coins placed in a straight line. Here are the rules of the game: 1. Each coin has a value associated with it. 2. The game involves two players... read more
View answer (1)

Jobs at DXC Technology

View all

Associate Interview Questions & Answers

user image Anonymous

posted on 10 Jan 2025

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Indeed and was interviewed in Dec 2024. There was 1 interview round.

Top DXC Technology Associate Interview Questions and Answers

Q1. What are the projects you did? Write a c program to reverse a string?
View answer (1)

Associate Interview Questions asked at other Companies

Q1. What is mean of TTR &amp; why required for powder coating process ?
View answer (17)

Analyst Interview Questions & Answers

user image Anonymous

posted on 16 Dec 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement

Top DXC Technology Analyst Interview Questions and Answers

Q1. What do you know about Insurance
View answer (1)

Analyst Interview Questions asked at other Companies

Q1. N-th Fibonacci Number Problem Statement Given an integer ‘N’, your task is to find and return the N’th Fibonacci number using matrix exponentiation. Since the answer can be very large, return the answer modulo 10^9 + 7. Formula: F(n) = F(n-... read more
View answer (1)

Quality Engineer Interview Questions & Answers

user image Aakanksha P

posted on 20 Dec 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Nov 2024. There were 3 interview rounds.

Quality Engineer Interview Questions asked at other Companies

Q1. What is MSA and addition of msa version, type of msa ,what different between variable data and attibute data .why difine flase and miss rate calculate by msa .
View answer (8)

Analyst 1 Interview Questions & Answers

user image Anonymous

posted on 1 Jan 2025

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Selected Selected

Analyst 1 Interview Questions asked at other Companies

Q1. SQL: Group all employees by department whose salary is greater than 50,000.
View answer (1)

Senior Analyst Interview Questions & Answers

user image Ramesh Babu

posted on 31 Aug 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

Interview Preparation Tips

Interview preparation tips for other job seekers - Overall Excellent interview with two technical rounds and one HR round. Technical rounds are quite simple and easy to krack. If you have counter offer you can nigotiate in HR round.

Senior Analyst Interview Questions asked at other Companies

Q1. Explain 3 statement financial model Calculating discount rate Could you walk me through the DCF model? Other valuation methods. What PE is ideal? What is the other matrix to value the company? Difference between IRR and CAGR. What is Bond Y... read more
View answer (1)
Contribute & help others!
anonymous
You can choose to be anonymous

DXC Technology Interview FAQs

How many rounds are there in DXC Technology interview?
DXC Technology interview process usually has 2-3 rounds. The most common rounds in the DXC Technology interview process are Technical, Resume Shortlist and HR.
How to prepare for DXC Technology interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at DXC Technology. The most common topics and skills that interviewers at DXC Technology expect are Analytical, Computer science, Interpersonal Skills, Troubleshooting and Business Solutions.
What are the top questions asked in DXC Technology interview?

Some of the top questions asked at the DXC Technology interview -

  1. If someone has deleted the table in a database, then how can you find out the ...read more
  2. What is the default port of sql server & Can we change the default port, if so ...read more
  3. 1. Describe project 2. What do you understand by OOPs. 3. What all Access modif...read more
How long is the DXC Technology interview process?

The duration of DXC Technology interview process can vary, but typically it takes about less than 2 weeks to complete.

Recently Viewed

SALARIES

C.R.I. Pumps

SALARIES

C.R.I. Pumps

JOBS

Consark Advisory Services Llp

No Jobs

SALARIES

Escorts Kubota Limited

SALARIES

C.R.I. Pumps

SALARIES

VE Commercial Vehicles

SALARIES

C.R.I. Pumps

SALARIES

C.R.I. Pumps

SALARIES

C.R.I. Pumps

SALARIES

C.R.I. Pumps

Tell us how to improve this page.

DXC Technology Interview Process

based on 573 interviews

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.8
 • 8.1k Interviews
Infosys Interview Questions
3.6
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Capgemini Interview Questions
3.7
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
IBM Interview Questions
4.0
 • 2.3k Interviews
View all

DXC Technology Reviews and Ratings

based on 10.1k reviews

3.7/5

Rating in categories

3.6

Skill development

3.8

Work-life balance

3.1

Salary

3.6

Job security

3.6

Company culture

2.8

Promotions

3.4

Work satisfaction

Explore 10.1k Reviews and Ratings
SCCM-Vulmgmt-AMS-MPC-12-0146404

Bangalore / Bengaluru

3-7 Yrs

Not Disclosed

Analyst II Software Engineering

Chennai

2-6 Yrs

₹ 2.5-12 LPA

Manager ERP Package Applications

Pune

4-9 Yrs

Not Disclosed

Explore more jobs
Associate Professional Software Engineer
2.7k salaries
unlock blur

₹2 L/yr - ₹7.2 L/yr

Software Engineer
2k salaries
unlock blur

₹2.4 L/yr - ₹12 L/yr

Associate Professional
1.5k salaries
unlock blur

₹2 L/yr - ₹7 L/yr

Associate Software Engineer
1.2k salaries
unlock blur

₹3 L/yr - ₹7 L/yr

Professional 1
1.1k salaries
unlock blur

₹3.2 L/yr - ₹13.5 L/yr

Explore more salaries
Compare DXC Technology with

Cognizant

3.7
Compare

Capgemini

3.7
Compare

TCS

3.7
Compare

Wipro

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview