What are the types of backups used in MySQL? Know about MySQL utilities used for taking backup Why we have to use CHECK TABLE statement in mySQL? Commands used to repair the tables in MySQL. What are ACID properties in a relational database, and how it helps? What is transaction? How it begins and ends in RDBMS Functionalities of Commit, Rollback and Save Point Examples of commit and rollback What is concurrency in the database? How is concurrency managed? What are the locks in the database and why are we using them? What are the locking levels used in MySQL? Know about two types of locks What are the responsibilities of a database administrator? What is open-source database? Advantages and disadvantages of open-source databases What authentication methods are used in databases? Why do we need a backup? What are the main resources needs to be tuned for databases to perform well? How to change system variable? remember few variables and how to change them. What is SDLC? What are the phases of SDLC and functions of each phase? What is DBLC? What are the phases of DBLC and functions of each phase? Choice available for database design strategy. What are the recovery options are available to restore when database damaged or lost due to system failure? What is big data? What are the characteristics of big data? What is Hadoop? What are the tools used in the Hadoop eco system? What are the drawbacks of RDBMS and why it cannot satisfy big data needs? Scalability of resources What is NoSQL, and how it helps big data? Advantages of NoSQL dbs What are the types of NoSQL databases? How each type of NoSQL database helps? What is BASE properties? CAP theorem and why it is needed? Examples of NoSQL databases currently used in industry