Add office photos
Filter interviews by
Markone Technologies Postgresql DBA Interview Questions and Answers
Markone Technologies Postgresql DBA Interview Experiences
1 interview found
I applied via Job Fair and was interviewed in Mar 2024. There were 2 interview rounds.
(1 Question)
- Q1. Normal and Official Interview for Me.
(4 Questions)
- Q1. Manager or Client ask Company Based Technical Questions to Me.
- Q2. Do you know about MySQL and MSSQL ?
- Ans.
Yes, MySQL and MSSQL are both popular relational database management systems similar to PostgreSQL.
MySQL is an open-source RDBMS known for its speed and ease of use.
MSSQL is a proprietary RDBMS developed by Microsoft, known for its scalability and integration with other Microsoft products.
PostgreSQL is also a popular open-source RDBMS known for its advanced features like support for JSON data types and full-text search
- Q3. What is the backup tools to you used in your Company?
- Ans.
We use pg_dump and Barman for PostgreSQL backups.
pg_dump is a standard PostgreSQL tool for logical backups
Barman is a tool for physical backups and disaster recovery
We schedule regular backups using pg_dump and Barman to ensure data safety
- Q4. What is the messaging app to you used in your Company?
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. Explainyour job role
- Ans.
ETL Developers are responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into a data warehouse.
Designing ETL processes to extract data from multiple sources
Transforming data to meet business requirements
Loading data into a data warehouse or other target systems
Developing and maintaining ETL jobs using tools like Informatica, Talend, or SSIS
- Q2. Explain implementation of SCD 1 in IICS
- Ans.
SCD Type 1 in IICS involves overwriting existing data with new data without maintaining historical changes.
In IICS, use the Mapping Designer to create a mapping that loads data from source to target.
Use a Lookup transformation to check if the record already exists in the target table.
If the record exists, update the existing record with new data using an Update Strategy transformation.
If the record does not exist, inse...
Skills evaluated in this interview
Oracle Database Administrator Interview Questions & Answers
Sutherland Global Services
Anonymous
posted on 28 Sep 2024
Selected
I applied via Campus Placement and was interviewed in Aug 2024. There were 8 interview rounds.
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
(5 Questions)
- Q1. Database Management system
- Q2. SQL and PlSQL Mango Data And Manu Database Management system
- Q3. C Language and C++Language and Java
- Q4. Data Analysis and Data entry
- Q5. DBMS C,C++ Java Data Entry Ms Excel Ms Word Ms PP
Interview Preparation Tips
Oracle Database Administrator Interview Questions & Answers
Hexaware Technologies
Anonymous
posted on 22 Oct 2024
(2 Questions)
- Q1. How to sync primary and standby?
- Ans.
Primary and standby databases can be synced using Data Guard in Oracle.
Configure Data Guard on primary and standby databases
Enable redo transport services
Monitor and resolve any synchronization issues
Perform switchover or failover when necessary
- Q2. Performance tuning?
(2 Questions)
- Q1. Why you want to change the job?
- Ans.
Seeking new challenges and growth opportunities in a dynamic environment.
Looking for new challenges to enhance my skills and knowledge
Seeking growth opportunities for career advancement
Interested in working in a more dynamic and innovative environment
- Q2. Expected salary.
Skills evaluated in this interview
Aptitude , reasoning, general questions
(2 Questions)
- Q1. What is spark architecture and partitions
- Ans.
Spark architecture refers to the structure of Apache Spark framework, while partitions are units of data distribution for parallel processing.
Spark architecture includes components like Driver, Executor, and Cluster Manager
Partitions are units of data distribution for parallel processing in Spark RDDs
Increasing the number of partitions can improve parallelism and performance
Example: In Spark, data is divided into parti...
- Q2. What is rdd, trsnsformations
- Ans.
RDD (Resilient Distributed Dataset) is a fundamental data structure in Apache Spark for distributed data processing. Transformations are operations that create a new RDD from an existing one.
RDD is a fault-tolerant collection of elements that can be operated on in parallel.
Transformations are functions that produce a new RDD by applying a computation on the existing RDD.
Examples of transformations include map, filter,
(2 Questions)
- Q1. Salary expectations
- Q2. Current ctc n expected ctc
- Ans.
The current CTC (Cost to Company) and expected CTC (Cost to Company) are typically discussed during salary negotiations.
Be honest about your current salary and provide a realistic expectation for your future salary.
Consider factors such as your experience, skills, industry standards, and the company's budget when discussing CTC.
It is important to have a clear understanding of your worth and negotiate accordingly.
Skills evaluated in this interview
Selected
I applied via Recruitment Consulltant and was interviewed in Jan 2024. There was 1 interview round.
(2 Questions)
- Q1. Basic Question Answer
- Q2. Basic SQL , SNWOFLAKE AND ETL Concepts
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed before Jul 2023. There were 2 interview rounds.
There was a small test which included few mcqs and one sql coding question. It was about 30 mins. It was fairly easy if you have knowledge on SQL.
(2 Questions)
- Q1. What is rollback and commit?
- Ans.
Rollback and commit are database transactions used to manage changes made to the database.
Rollback is used to undo changes made in a transaction and restore the database to its previous state.
Commit is used to save the changes made in a transaction permanently to the database.
Rollback is typically used when an error occurs during a transaction, while commit is used when the transaction is successful.
Example: If a trans...
- Q2. What are Transactions
- Ans.
Transactions are a set of operations that are executed as a single unit of work, ensuring data integrity and consistency.
Transactions help maintain data integrity by ensuring all operations within the transaction are completed successfully or rolled back if any operation fails.
Transactions follow the ACID properties - Atomicity, Consistency, Isolation, and Durability.
Examples of transactions include transferring funds ...
(1 Question)
- Q1. Informatica scenarios and theoretical questions
(1 Question)
- Q1. Project related questions
(1 Question)
- Q1. Basic discussion in HR
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Mar 2023. There were 3 interview rounds.
Simple question related to Joins, Subquery, Procedures, Indexes.
Advanced questions on optimization
(1 Question)
- Q1. Salary related discussion
Interview Preparation Tips
I applied via Naukri.com and was interviewed in May 2021. There were 3 interview rounds.
Interview Questionnaire
6 Questions
- Q1. 1) Explain about your project
- Q2. 2) for each loop container
- Ans.
For Each Loop Container is used to iterate through a set of objects or files in SSIS packages.
Used to perform repetitive tasks on a set of objects or files
Can be used to loop through files in a directory or rows in a table
Requires a data source and a variable to store the current object or file
Can be configured to run in parallel or sequentially
- Q3. 3) SCD Type 2 dimension used in your old project
- Ans.
SCD Type 2 is used to maintain historical data in a dimension table.
SCD Type 2 is used to track changes in dimension attributes over time.
It creates a new record for each change and maintains a history of all changes.
It includes additional columns like start date, end date, and version number.
Example: Employee table with changes in job title, salary, and department over time.
It helps in analyzing trends and making info
- Q4. 4) joins in SQL
- Ans.
Joins are used in SQL to combine data from two or more tables based on a related column.
Joins are used to retrieve data from multiple tables.
Common types of joins are inner join, left join, right join, and full outer join.
Joins are performed using the JOIN keyword and specifying the tables to join and the columns to join on.
Joins can be used to filter data based on a related column.
Joins can also be used to combine dat
- Q5. 5) different between truncate, delete and drop
- Ans.
Difference between truncate, delete and drop
Truncate removes all data from a table but keeps the structure
Delete removes specific rows from a table
Drop removes the entire table and its structure
Truncate and drop cannot be rolled back, but delete can be
Truncate is faster than delete as it does not log individual row deletions
- Q6. 6) what is Normalization
- Ans.
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a table into smaller tables to reduce redundancy.
It helps to avoid data inconsistencies and anomalies.
Normalization is achieved through a series of normal forms, such as first normal form (1NF), second normal form (2NF), and so on.
Each normal form has specific rules that mus...
Interview Preparation Tips
Skills evaluated in this interview
Markone Technologies Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- MS SQL DBA Interview Questions
- Oracle Database Administrator Interview Questions
- Oracle Apps DBA Interview Questions
- DBA Consultant Interview Questions
- Lead DBA Interview Questions
- ETL Developer Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- Show more
Interview Questions from Similar Companies
Markone Technologies Postgresql DBA Reviews and Ratings
based on 2 reviews
Rating in categories
|
Oracle Database Administrator
58
salaries
|  ₹2.4 L/yr - ₹4.5 L/yr |
|
Software Engineer
25
salaries
| ₹2.5 L/yr - ₹4.7 L/yr |
|
Database Admin
14
salaries
| ₹3 L/yr - ₹5 L/yr |
|
Postgresql DBA
9
salaries
| ₹2.6 L/yr - ₹4.5 L/yr |
|
Java Developer
6
salaries
| ₹2.5 L/yr - ₹3.2 L/yr |
Infosys
TCS
Wipro
HCLTech
Calculate your in-hand salary
- Home >
- Interviews >
- Markone Technologies Interview Questions >
- Markone Technologies Postgresql DBA Interview Questions
