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 transacti011_?____Hou-' it begins and ends in RDBMS Functionalities 0f 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 usedl in databases? Why do we need a backup? Vi'hat are the main resources needs to be tuned for databases to perform well? What are the recovery options are available to restore when database damaged or lost due to system failure? 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. "Phat 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

Please answer all the questions

pur-new-sol

Related Questions