Upload Button Icon Add office photos

Teradata

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Teradata Senior Database Administrator Interview Questions, Process, and Tips

Updated 18 Nov 2021

Teradata Senior Database Administrator Interview Experiences

1 interview found

I applied via Naukri.com and was interviewed in May 2021. There were 3 interview rounds.

Interview Questionnaire 

8 Questions

  • Q1. Teradata Architecture
  • Q2. Data protection techniques
  • Ans. 

    Data protection techniques are essential for safeguarding sensitive information from unauthorized access or theft.

    • Encryption of data at rest and in transit

    • Access controls and authentication mechanisms

    • Regular backups and disaster recovery plans

    • Data masking and anonymization

    • Monitoring and auditing of database activity

  • Answered by AI
  • Q3. Difference between Role and Profile
  • Q4. What is hop Amp CPU and how it is caused
  • Ans. 

    Hop Amp CPU is a performance issue caused by excessive CPU usage in a database server.

    • Hop Amp CPU occurs when a database server is overloaded with too many queries or transactions.

    • It can also be caused by poorly optimized queries or inefficient database design.

    • Hop Amp CPU can lead to slow response times, system crashes, and other performance issues.

    • To prevent Hop Amp CPU, database administrators should monitor server p...

  • Answered by AI
  • Q5. Various methods to solve spool space issue
  • Ans. 

    Various methods to solve spool space issue

    • Optimize queries to reduce spool space usage

    • Increase spool space allocation for the user

    • Use temporary tables to reduce spool space usage

    • Use compression techniques to reduce spool space usage

    • Avoid Cartesian joins to reduce spool space usage

  • Answered by AI
  • Q6. Teradata Utilities: Mainly Multipload and Fastload
  • Q7. Grant and Revoke command
  • Q8. Data dictionary tables and where the history Data is stored
  • Ans. 

    Data dictionary tables store metadata about database objects. History data is stored in audit tables or separate history tables.

    • Data dictionary tables contain information about database objects such as tables, columns, indexes, and constraints.

    • History data can be stored in audit tables that track changes to data over time.

    • Separate history tables can also be used to store historical data.

    • Examples of data dictionary tabl...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I had a good experience with the interview. There are teradata wiki links available to go through topics mentioned.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Monster and was interviewed before Mar 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. How much salary you are expecting? Was my last question. .

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was really easy going. Technical was informative round. By answering questions, interviewer also help me to reach out to the depth of the topic. Work culture is also good here.

I applied via Recruitment Consultant and was interviewed in Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basics of redux and react es6 js css3

Interview Preparation Tips

Interview preparation tips for other job seekers - First of all go through the job description .Brush up all your basics .And do practice hands on coding.

I applied via Naukri.com and was interviewed in Apr 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions on java spring boot, java 8 new features with examples, core java questions on generics and garbage collection.

Interview Preparation Tips

Interview preparation tips for other job seekers - Knowledge on microservices and java 8 is necessary

I applied via Company Website and was interviewed before Jul 2021. There were 2 interview rounds.

Round 1 - Coding Test 

Data Structure related questions

Round 2 - One-on-one 

(1 Question)

  • Q1. Java related interview questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Study Data structure and Java code properly

I applied via Referral and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Most will be performance tuning in SQL server database administrator

Interview Preparation Tips

Interview preparation tips for other job seekers - Need to be confident level more waht you knowing
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Full stack question with java and angular and sql

Round 2 - Case Study 

Case study on project

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Coding Test 

2 questions on arrays

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Oct 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What is Kubernetes ? why it is required? how it is different from Docker swarm?
  • Ans. 

    Kubernetes is an open-source container orchestration platform that automates the deployment, scaling, and management of containerized applications.

    • Kubernetes is required to manage and scale containerized applications efficiently.

    • It provides features like automatic scaling, self-healing, load balancing, and rolling updates.

    • Kubernetes uses a declarative approach to define the desired state of the application and ensures ...

  • Answered by AI
  • Q2. What is ECS? How it is different from EKS?
  • Ans. 

    ECS is a container management service by AWS, while EKS is a managed Kubernetes service.

    • ECS (Elastic Container Service) is a container management service provided by AWS.

    • ECS allows you to easily run and scale containerized applications on AWS.

    • EKS (Elastic Kubernetes Service) is a managed Kubernetes service by AWS.

    • EKS simplifies the process of deploying, managing, and scaling containerized applications using Kubernetes.

    • ...

  • Answered by AI

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. It include basic questions regarding the framework, OOPS concepts, some behavioral questions, etc, They also asked to open a notepad and show how to create a singleton class, write a program related to cir...
Contribute & help others!
anonymous
You can choose to be anonymous

Teradata Interview FAQs

What are the top questions asked in Teradata Senior Database Administrator interview?

Some of the top questions asked at the Teradata Senior Database Administrator interview -

  1. Data dictionary tables and where the history Data is sto...read more
  2. Various methods to solve spool space is...read more
  3. What is hop Amp CPU and how it is cau...read more

Recently Viewed

SALARIES

Health Prime Services (India)

INTERVIEWS

Ness Digital Engineering

No Interviews

SALARIES

Health Prime Services (India)

SALARIES

Health Prime Services (India)

INTERVIEWS

Omullane Management Solutions

No Interviews

LIST OF COMPANIES

Health Prime Services (India)

Overview

INTERVIEWS

Eduzell Technologies & Solutions

No Interviews

INTERVIEWS

Cimpress

No Interviews

SALARIES

Ness Digital Engineering

INTERVIEWS

Teradata

No Interviews

Tell us how to improve this page.

Interview Questions from Similar Companies

Amazon Interview Questions
4.1
 • 5k Interviews
IBM Interview Questions
4.0
 • 2.3k Interviews
Oracle Interview Questions
3.7
 • 848 Interviews
Google Interview Questions
4.4
 • 826 Interviews
Amdocs Interview Questions
3.7
 • 514 Interviews
Dell Interview Questions
4.0
 • 386 Interviews
Cisco Interview Questions
4.1
 • 371 Interviews
SAP Interview Questions
4.2
 • 283 Interviews
Adobe Interview Questions
3.9
 • 234 Interviews
View all
Teradata Senior Database Administrator Salary
based on 22 salaries
₹9 L/yr - ₹25 L/yr
12% more than the average Senior Database Administrator Salary in India
View more details

Teradata Senior Database Administrator Reviews and Ratings

based on 3 reviews

4.7/5

Rating in categories

4.7

Skill development

4.5

Work-life balance

4.5

Salary

4.1

Job security

3.6

Company culture

3.9

Promotions

4.5

Work satisfaction

Explore 3 Reviews and Ratings
Software Engineer
242 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Consultant
191 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Technical Associate
158 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Engineer
157 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
125 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Teradata with

IBM

4.0
Compare

SAP

4.2
Compare

Oracle

3.7
Compare

Microsoft Corporation

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