Markone Technologies Interview Questions and Answers

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...read more

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

I am a dedicated and experienced PostgreSQL developer with a strong background in database management.

• Over 5 years of experience working with PostgreSQL

• Proficient in writing complex SQL queries and optimizing database performance

• Familiar with database design principles and normalization techniques

• Hands-on experience with data migration and replication processes

• Strong problem-solving skills and ability to troubleshoot d...read more

As a PostgreSQL developer, I am responsible for designing, implementing, and maintaining database systems.

• Designing database schemas based on project requirements

• Writing efficient SQL queries and stored procedures

• Optimizing database performance through indexing and query tuning

• Ensuring data integrity and security

• Troubleshooting and resolving database issues

• Collaborating with other team members for database-related task...read more

Our company utilizes a combination of physical and cloud-based backups for PostgreSQL data.

• We regularly perform full and incremental backups of our PostgreSQL databases.

• Physical backups are stored on dedicated backup servers located offsite for disaster recovery purposes.

• Cloud-based backups are encrypted and stored on a secure cloud storage service like AWS S3.

• We test our backup and restore processes regularly to ensur...read more

VACUUM FULL reclaims space by rewriting the entire table, while AUTOVACUUM automatically manages the vacuum process.

• VACUUM FULL locks the table exclusively during the process, while AUTOVACUUM can run concurrently with other operations.

• VACUUM FULL is more resource-intensive and requires downtime, while AUTOVACUUM is less intrusive and can be scheduled to run automatically.

• VACUUM FULL is typically used for major table m...read more

SQL concepts - Procedure, Functions, Joins, Sub queries, Constraints, Triggers, Package

• Procedure - a set of SQL statements that perform a specific task

• Functions - a set of SQL statements that return a single value

• Joins - used to combine rows from two or more tables based on a related column

• Sub queries - a query within another query

• Constraints - rules that enforce data integrity

• Triggers - a set of SQL statements that au...read more

Triggers and procedures are database objects used to automate tasks and enforce business rules.

• Triggers are special types of stored procedures that are automatically executed in response to certain events, such as insertions, updates, or deletions of data.

• Procedures are a set of SQL statements that are stored in the database and can be executed repeatedly.

• Triggers can be used to enforce business rules, such as preventi...read more