Atos MS SQL Server Database Administrator Interview Questions and Answers

Q1. Analytical functions difference
Ans. 
Analytical functions are used to perform calculations across a set of rows related to the current row.
• Analytical functions operate on a group of rows and return a single result for each row

• They can be used to calculate running totals, moving averages, rank, percentiles, etc.

• Examples include ROW_NUMBER(), RANK(), SUM() OVER(), AVG() OVER()
Answered by AI
Add your answer
Q2. Which transformation uses in scd2?
Ans. 
The Slowly Changing Dimension Type 2 (SCD2) transformation is used for handling historical data changes in a data warehouse.
• SCD2 transformation is used to track historical changes in dimension tables.

• It maintains multiple versions of a record by adding new rows with updated information and end-dating the previous record.

• Commonly used in scenarios where historical data needs to be preserved and queried.

• Example: When a c...read more
Answered by AI
Add your answer
Q3. Unix basic, how to find particular file in directory?
Add your answer
Q4. Given 2 table A and B. Find count of left join, right join, inner join, full outer join?
Ans. 
To find the count of different types of joins between two tables A and B.
• Left join: Includes all records from table A and matching records from table B.

• Right join: Includes all records from table B and matching records from table A.

• Inner join: Includes only the matching records from both tables.

• Full outer join: Includes all records when there is a match in either table A or table B.
Answered by AI
Add your answer
Q5. Incremental load
Add your answer

Database Management system SQL and PlSQL

Database Base Management system SQL and PlSQL

Database Management system

Database Management system

Database Management system

Database Management system

Database Base Management system

Q1. Database Management system
Add your answer
Q2. SQL and PlSQL Mango Data And Manu Database Management system
Add your answer
Q3. C Language and C++Language and Java
Add your answer
Q4. Data Analysis and Data entry
Add your answer
Q5. DBMS C,C++ Java Data Entry Ms Excel Ms Word Ms PP
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. SQL patching, migration
Add your answer

Q1. DDL DML DCL TCL
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

Q1. Informtica with date functions
Ans. 
Informatica is a popular ETL tool used for data integration and transformation. It has built-in functions to handle date operations.
• Informatica is a powerful ETL tool used for extracting, transforming, and loading data.

• It provides a variety of built-in functions for handling date operations such as date calculations, formatting, and conversions.

• Examples of date functions in Informatica include TO_DATE, TO_CHAR, ADD_TO_
Answered by AI
Add your answer

Q1. Tell about yourself
Ans. 
Experienced Oracle DBA with 5+ years of hands-on experience in managing databases, optimizing performance, and ensuring data security.
• 5+ years of experience as an Oracle DBA

• Proficient in database management, performance optimization, and data security

• Skilled in troubleshooting and resolving database issues

• Strong knowledge of Oracle database architecture and SQL

• Certified Oracle Database Administrator (OCA/OCP)
Answered by AI
Add your answer