- What is MySQL and how is it different from SQL?
- How do you install MySQL on Windows and Linux?
- What are the different data types available in MySQL?
- What is the default port for MySQL?
- What is a primary key in MySQL?
- What is a foreign key?
- What are indexes in MySQL and why are they used?
- How do you create a table in MySQL?
- How do you insert data into a table?
- How do you update data in MySQL?
- How do you delete a record in MySQL?
- What is the difference between DELETE, TRUNCATE, and DROP?
- How do you retrieve data from a MySQL database?
- What is the purpose of the WHERE clause?
- How do you use the LIKE operator?
- How does the BETWEEN operator work?
- What is the IN clause used for?
- What are aggregate functions in MySQL?
- How do you group data in MySQL?
- What is the difference between GROUP BY and ORDER BY?
- How do you use LIMIT in MySQL?
- What is a NULL value in MySQL?
- How do you check for NULL values?
- How do you create a database in MySQL?
- How do you select a database in MySQL?
- How do you delete a database in MySQL?
- What are constraints in MySQL?
- What is the AUTO_INCREMENT attribute?
- What is the difference between CHAR and VARCHAR?
- How do you use the DISTINCT keyword?
- What are joins in MySQL? Name and explain types.
- How does INNER JOIN differ from LEFT JOIN?
- What is a SELF JOIN?
- How do you write a subquery in MySQL?
- What is a correlated subquery?
- How do you create a view in MySQL?
- How do you update a view?
- What are stored procedures in MySQL?
- How do you create and call a stored procedure?
- What are stored functions and how do they differ from procedures?
- What is a trigger in MySQL?
- How do you create a BEFORE INSERT trigger?
- How do you use AFTER UPDATE triggers?
- What is a cursor in MySQL?
- What are transactions in MySQL?
- What are the ACID properties?
- How do you start, commit, and rollback transactions in MySQL?
- What are MySQL storage engines?
- What is the difference between InnoDB and MyISAM?
- What is the purpose of the EXPLAIN keyword?
- How do you optimize a slow query?
- What are user-defined variables in MySQL?
- How do you create a user in MySQL?
- How do you assign privileges to a user?
- What is the difference between GRANT and REVOKE?
- What is the purpose of the INFORMATION_SCHEMA database?
- How do you back up a MySQL database?
- How do you restore a database from a backup?
- How can you import and export data in MySQL?
- What is the difference between a clustered and non-clustered index?
- How do you change the structure of a table?
- How do you rename a column or table?
- What is normalization and why is it important?
- Explain different normal forms.
- What is denormalization and when should it be used?
- How do you check the version of MySQL?
- How do you find the current user?
- What are temporary tables?
- What is the purpose of the IF EXISTS clause?
- What is a full-text search in MySQL?
- How do you handle replication in MySQL?
- What is the difference between master-slave and master-master replication?
- What is MySQL clustering?
- What is partitioning in MySQL?
- How does horizontal and vertical partitioning work?
- What is sharding in MySQL?
- What are common MySQL performance bottlenecks?
- How do you analyze query performance in MySQL?
- What are slow query logs?
- How do you configure MySQL for large data sets?
- What is the mysqlcheck utility?
- How do you repair a corrupted table?
- What is the difference between mysql and mysqldump?
- How do you schedule automated backups in MySQL?
- What are common security best practices in MySQL?
- How do you encrypt data in MySQL?
- How do you store JSON data in MySQL?
- What are common MySQL configuration files?
- How do you tune buffer pool size in InnoDB?
- What are generated columns in MySQL?
- How do you use window functions in MySQL?
- What are common locking issues in MySQL?
- How do you avoid deadlocks?
- What are common memory usage parameters in MySQL?
- How do you monitor MySQL performance?
- How do you use MySQL with a connection pool?
- How does MySQL handle concurrency?
- How do you audit changes to data in MySQL?
- What is the difference between logical and physical backups?
- How do you integrate MySQL with programming languages like Python, PHP, or Java?
- What is NoSQL and how is it different from SQL databases?
- List and explain the main types of NoSQL databases.
- Name some popular NoSQL databases and their types.
- What are the key features of NoSQL databases?
- In what scenarios would you prefer NoSQL over SQL?
- How does horizontal scaling work in NoSQL databases?
- What is CAP theorem and how does it relate to NoSQL?
- Explain BASE properties in NoSQL databases.
- How is data stored in a document-based NoSQL database?
- What is the difference between MongoDB and CouchDB?
- What is a key-value store and where is it useful?
- Explain column-family stores and give examples.
- How do graph databases differ from other NoSQL types?
- What are some common use cases for graph databases?
- What is sharding and how is it implemented in NoSQL databases?
- What is replication in NoSQL databases?
- Can NoSQL databases support transactions? If yes, how?
- What consistency models are available in NoSQL databases?
- How do you query data in a document-based database like MongoDB?
- Compare ACID and BASE in the context of database systems.
- What is eventual consistency and when is it acceptable?
- How does indexing work in NoSQL databases?
- How can you perform aggregations in MongoDB?
- What are collections and documents in MongoDB?
- What is MapReduce and how is it used in NoSQL systems?
- How are relationships handled in NoSQL databases?
- Is schema design important in NoSQL? Why or why not?
- How do you perform backups in NoSQL databases like Cassandra or MongoDB?
- What is denormalization and why is it common in NoSQL?
- Explain how to model a one-to-many relationship in a document store.
- What are the limitations of NoSQL databases?
- When should you avoid using NoSQL?
- What is the role of JSON in NoSQL databases?
- How does data versioning work in Couchbase or similar databases?
- Explain tunable consistency in Cassandra.
- What tools are available for monitoring NoSQL databases?
- How does Redis ensure high availability?
- What are secondary indexes and how are they used in NoSQL databases?
- What is a wide-column store and how does it work?
- How do you secure NoSQL databases against unauthorized access?
- How do you ensure data integrity in NoSQL databases?
- What is TTL (Time to Live) in NoSQL and where is it useful?
- Explain the concept of eventual consistency with a real-world example.
- What are the differences between MongoDB and Cassandra?
- How does Redis handle persistence?
- How do you handle schema migrations in NoSQL databases?
- How is concurrency control managed in NoSQL systems?
- What is the use of quorum in distributed NoSQL systems?
- What is Polyglot Persistence and how does it relate to NoSQL?
- How does Couchbase differ from MongoDB?
- What are buckets in Couchbase and how are they used?
- Explain how partitioning works in NoSQL databases.
- How do you monitor the performance of a NoSQL cluster?
- What is a conflict resolution strategy in distributed databases?
- How does Neo4j represent data relationships?
- How does a graph database scale with a growing dataset?
- What query language does Neo4j use?
- Can NoSQL databases be used for analytics? If so, how?
- What are the main security concerns in NoSQL databases?
- How do you migrate data from SQL to NoSQL?
- What is a surrogate key and does NoSQL use them?
- What are some common mistakes when designing NoSQL schemas?
- What is the role of Bloom filters in NoSQL databases?
- Can you enforce constraints in NoSQL databases?
- Describe the write and read path in Cassandra.
- How does write amplification affect performance in NoSQL?
- What are tombstones in Cassandra and why are they important?
- How do you handle large binary data in NoSQL databases?
- How do you handle large-scale writes in NoSQL?
- How does Cassandra handle node failures?
- What is the difference between consistency level ONE and QUORUM in Cassandra?
- How is a NoSQL database integrated with microservices?
- What is a materialized view in Cassandra?
- Explain multi-model databases and their benefits.
- What are change data capture (CDC) mechanisms in NoSQL?
- What is Oracle Database and what are its key features?
- What are the different types of Oracle database objects?
- What is the difference between a table and a view in Oracle?
- What is a synonym in Oracle and why is it used?
- Explain the concept of a tablespace in Oracle.
- What are the different types of tablespaces in Oracle?
- What is an Oracle instance and how does it differ from a database?
- What is the purpose of the Oracle Data Dictionary?
- What are the components of the Oracle SGA (System Global Area)?
- What is a redo log and what is its importance in Oracle?
- How does Oracle ensure data consistency and integrity?
- Explain the difference between COMMIT, ROLLBACK, and SAVEPOINT in Oracle.
- What is the purpose of the Oracle Listener?
- What is the difference between Oracle RAC and a single-instance Oracle database?
- What are Oracle background processes? Name a few critical ones.
- How do you check the version of your Oracle database?
- How are privileges granted and revoked in Oracle?
- What is the difference between a role and a privilege in Oracle?
- Explain the concept of a cursor in Oracle.
- What are the different types of cursors in Oracle?
- What is the use of the %TYPE and %ROWTYPE attributes in PL/SQL?
- What are triggers in Oracle and when would you use them?
- What is the difference between BEFORE and AFTER triggers in Oracle?
- What is a sequence in Oracle and why is it used?
- Explain the difference between implicit and explicit cursors in Oracle.
- How does Oracle handle locking and concurrency control?
- What is a deadlock in Oracle? How can you detect and resolve it?
- What are the different types of indexes in Oracle?
- When would you use a bitmap index over a B-tree index?
- What is the Oracle Optimizer and what are its types?
- What are bind variables and why are they important in Oracle SQL?
- What is Oracle Partitioning and when should it be used?
- Explain the difference between logical and physical backups in Oracle.
- What is RMAN in Oracle and what are its key features?
- What is a control file in Oracle and what information does it contain?
- What are Oracle Datafiles and how are they used?
- What are latches and locks in Oracle?
- How does Oracle handle transaction management?
- What is the difference between DELETE, TRUNCATE and DROP in Oracle?
- How do you tune SQL queries in Oracle?
- What is AWR and how is it used in Oracle performance tuning?
- Explain Oracle Flashback Technology and its use cases.
- What is a materialized view and how is it different from a regular view?
- How can you schedule jobs in Oracle?
- How does Oracle manage memory using PGA and SGA?
- What is a bitmap index in Oracle?
- How do you monitor Oracle database performance?
- Explain the difference between SGA and PGA in Oracle?
- What is the purpose of the Oracle listener?
- What is DBMS_STATS and why is it important?
- What is the use of the ANALYZE command in Oracle?
- Explain the different types of joins supported by Oracle.
- How do you find the current database name in Oracle?
- What are the Oracle RAC components?
- What is a deadlock? How do you prevent it in Oracle?
- Explain Oracle Flashback Technology.
- What are redo log files in Oracle and why are they needed?
- How do you drop a user from Oracle DB safely?
- Describe the use of the Oracle exp and imp utilities.
- How is Oracle RMAN different from traditional backup methods?
- What are the different types of Oracle partitions?
- How can you optimize an Oracle query?
- What is Oracle SQL Developer and how is it used?
- What is the difference between a user and a schema in Oracle?
- Describe the purpose of Oracle ASM (Automatic Storage Management).
- Explain how Oracle handles transaction isolation.
- What is Oracle SQL*Loader used for?
- How do you use sequences in Oracle to auto-generate values?
- What are synonyms in Oracle and when are they used?
- What is an Oracle tablespace and what types exist?
- How can you check for fragmentation in Oracle tables?
- Explain the use of Oracle’s recycle bin feature.
- What is the difference between VARCHAR and VARCHAR2 in Oracle?
- What are external tables in Oracle?
- How do you use bind variables in Oracle?
- What are Oracle collections and what types exist?
- Explain Oracle Edition-Based Redefinition (EBR).
- What is a materialized view log and how is it used?
- What are autonomous transactions in Oracle?
- Describe the difference between CLOB and BLOB data types.
- How does Oracle manage undo and redo information?
- What is the difference between global and local indexes in Oracle?
- What is PostgreSQL and how is it different from other relational databases?
- How do you create a new database in PostgreSQL?
- What are schemas in PostgreSQL and why are they used?
- Explain the difference between a table and a view in PostgreSQL.
- What are some key features of PostgreSQL?
- How do you perform a backup and restore in PostgreSQL?
- What is the use of the `psql` command-line tool?
- What data types are supported by PostgreSQL?
- How can you change the datatype of a column in PostgreSQL?
- What is a sequence in PostgreSQL and how is it used?
- How can you enforce uniqueness on a column in PostgreSQL?
- What are indexes in PostgreSQL? How do they work?
- What is a composite index?
- Explain the concept of a primary key and a foreign key in PostgreSQL.
- What are constraints in PostgreSQL?
- How can you create a stored procedure in PostgreSQL?
- What is the difference between a function and a procedure in PostgreSQL?
- How do you write a recursive query in PostgreSQL?
- What are common table expressions (CTEs)?
- Explain JSON and JSONB support in PostgreSQL.
- How do you query JSON fields in PostgreSQL?
- What are triggers in PostgreSQL? Give an example use case.
- What are the different types of joins in PostgreSQL?
- How do you optimize slow queries in PostgreSQL?
- What is the EXPLAIN and EXPLAIN ANALYZE command used for?
- What is VACUUM in PostgreSQL and why is it important?
- What is autovacuum and how does it work?
- Explain the transaction management in PostgreSQL.
- What are isolation levels supported in PostgreSQL?
- What is MVCC (Multi-Version Concurrency Control)?
- What are roles and privileges in PostgreSQL?
- How do you grant and revoke privileges?
- How can you prevent SQL injection in PostgreSQL applications?
- How can you import and export data in PostgreSQL?
- What is the difference between `COPY` and `INSERT`?
- What are materialized views and how are they used?
- How do you refresh a materialized view?
- What is the purpose of the `pg_stat_activity` view?
- How do you check for deadlocks in PostgreSQL?
- What are temporary tables? When should you use them?
- How do you create a custom aggregate function?
- Explain the use of array data types in PostgreSQL.
- How do you handle NULL values in PostgreSQL?
- What are window functions and how are they useful?
- How does PostgreSQL handle concurrent writes?
- What is a materialized view in PostgreSQL and how is it different from a regular view?
- How do you refresh a materialized view in PostgreSQL?
- Explain the use of the `WITH RECURSIVE` clause in PostgreSQL.
- What is the purpose of the `RETURNING` clause in PostgreSQL?
- How do you implement full-text search in PostgreSQL?
- What is `tsvector` and `tsquery` in PostgreSQL?
- Explain the concept of roles and how they differ from users in PostgreSQL.
- How do you grant and revoke privileges in PostgreSQL?
- What are PostgreSQL extensions and how do you use them?
- How does PostgreSQL handle NULLs in indexes and queries?
- Explain the differences between JSON and JSONB data types in PostgreSQL.
- What are some JSON functions and operators available in PostgreSQL?
- How do you optimize JSON queries in PostgreSQL?
- What is the `pg_stat_statements` extension used for?
- Explain how you monitor PostgreSQL performance and identify bottlenecks.
- How do you configure autovacuum in PostgreSQL?
- What is the purpose of the `TOAST` mechanism in PostgreSQL?
- How do you manage PostgreSQL logs for analysis?
- What is the difference between physical and logical replication in PostgreSQL?
- Describe how to set up streaming replication in PostgreSQL.
- What are hot standby and warm standby in PostgreSQL?
- Explain failover and high availability options for PostgreSQL.
- What is pg_basebackup and how is it used?
- What tools are available for PostgreSQL backup and recovery?
- How do you perform point-in-time recovery (PITR) in PostgreSQL?
- How are sequences handled in PostgreSQL and what are they used for?
- Explain the concept of advisory locks in PostgreSQL.
- What are some best practices for writing efficient queries in PostgreSQL?
- How can you avoid deadlocks in PostgreSQL?
- How is data partitioning done in PostgreSQL and what are its types?
- What are hash indexes in PostgreSQL and when should they be used?
- How does the planner choose indexes in PostgreSQL?
- What is the difference between `SET` and `ALTER SYSTEM` in PostgreSQL?
- Explain logical decoding in PostgreSQL.
- What is `pgbouncer` and how does it help in managing PostgreSQL connections?
- How do you handle timezone-sensitive data in PostgreSQL?
- How do you audit changes in PostgreSQL tables?
- What is row-level security (RLS) in PostgreSQL?
- Can you explain how PostgreSQL handles concurrent writes?
- What is the importance of schema in PostgreSQL?
