MySql Day-5

Which privilege allows a MySQL user to create and manage databases?

• SELECT

• CREATE

• INSERT

• DROP

To grant a user full access to all databases in MySQL, which command would you use?

• GRANT ALL PRIVILEGES ON * . * TO 'username'

• GRANT SELECT ALL ON * . *TO 'username'

• GRANT ALL PRIVILEGES ON dbname TO 'username'

• GRANT FULL ACCESS ON * TO 'username'

Which privilege is required to allow a user to execute stored procedures and functions in MySQL?

• EXECUTE

• ALTER

• CREATE ROUTINE

• SUPER

What is the default root password for a fresh MySQL installation?

• password

• root

• No password

• admin

Which of the following commands displays the current user privileges in MySQL?

• SHOW GRANTS

• SHOW USERS

• LIST PRIVILEGES

• SHOW ACCESS

Which MySQL function can be used to encrypt passwords?

• AES_ENCRYPT()

• PASSWORD()

• ENCRYPT()

• SHA2()

In MySQL, a user can be granted ______ privilege to be able to read from a database.

Which MySQL table contains user privilege information?

• mysql.user

• mysql.tables

• information_schema.user_privileges

• performance_schema.users

Which command is used to perform a point-in-time recovery in MySQL?

• mysqlbinlog

• mysqlpointrestore

• recover_mysql

• backup_restore

In MySQL, which command is used to display the status of binary logs?

• SHOW BINARY LOGS

• SHOW STATUS

• SHOW VARIABLES

• SHOW LOGS