Infosys Certified MySQL Administrator

In a MYSQL Server to revoke all privileges assigned to user Tester, which of the following SQL queries is executed?

Which of the following queries can be executed to view all the databases present in a MySQL Server?

(i)SHOW DATABASES;

(ii) SHOW SCHEMAS;

(iii) SELECT * FROM information_schema.schemata;

In a MySQL Server you are required grant SELECT, INSERT & DELETE as a database privilege to user Tester on Engineering database. Which of the following SQL queries is to be executed to accomplish this task?

In a MySQL Server, you are required to provide UPDATE privilege on Status and Result columns of Process table in Testing database to user Tester. Which of the following SQL query is executed to accomplish this task?

Which of the following SQL queries must be executed to display privileges associated with the Credit@localhost role for Accountant user?

Which of the following programs is used to export table definitions and contents?

In which log file is the data changes received from a replication master server written to?

A DBA of MySQL wants to add primary key on column ‘Order_No’ of table ‘Orders’. Which of the following solution(s) is/are valid for the above requirement?

(i). mysql> ALTER TABLE Orders DROP PRIMARY KEY;

mysql> ALTER TABLE Orders MODIFY Order_No INT NOT NULL;

mysql> ALTER TABLE Orders ADD PRIMARY KEY ( Order_No);

(ii). mysql> ALTER TABLE Orders DROP PRIMARY KEY;

mysql> ALTER TABLE Orders MODIFY Order_No INT PRIMARY KEY;

(iii). mysql> ALTER TABLE Orders DROP PRIMARY KEY;

mysql> ALTER TABLE Orders MODIFY Order_No INT NOT NULL PRIMARY KEY;

Which of the following databases can be accessed by a user Accountant in a MySQL Server?

In a MySQL Server, as a DBA you are required grant all privileges as a global privilege to user Accountant. Which of the following SQL queries is to be executed to accomplish this task?