An employee cannot access the company database. You check the connection variables:
A look at the user privileges shows:
What is a valid explanation for why one of the users is unable to connect to the database?
You want to dump only data from the userdata table.
Which mysqldump command argument is required to accomplish this?
Why should you be selective when granting the PROCESS privilege to an account?
A. It allows a client to process scripts.
B. It allows the use of stored routines.
C. It allows a client to see another users queries with the SHOW PROCESSLIST command.
D. It allows a client to control running processes on a server.
Which statement describes how the relay log works?
You have forgotten the root user account password. You decide to reset the password and execute:
Which additional argument makes this operation safer?
Consider the ANALYZE TABLE command.
In which two situations should this command be used?
The MySQL user adam currently has USAGE permissions to the database.
The football database is transactional and has non-stop updates from application users. The adam
user needs to be able to take consistent backups of the football database by using the -single-
Which extra GRANT permissions are required for adam to take mysqldump backups?
You are receiving complaints from your application administrators that they are seeing periodic stalls
in database response (no queries to any table are returning results for several seconds or longer). You
monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.
Which 2 things should you investigate?
You are using GTIDS in replication. You need to skip a transaction with the GTID of aaa-bbb-ccc-ddd-
eee:3 on a slave.
Which procedure would you execute from a MySQL prompt?
You have created a backup of the sales database with the command:
Which two procedures can be used to restore the orders table from the backup?
A MySQL instance is running on a dedicated server. Developers access the server from the same
network subnet. Users access the database through an application that is running on a separate
server in a DMZ.
Which two will optimize the security of this setup? (Choose two.)
You need to dump the data from the master server and import it into a new slave server.
Which mysqldump option can be used when dumping data from the master server in order to
include the master servers binary log information?
While attempting to set up a new replication slave on host 192.168.0.25 with the user replication,
you encounter this error:
What should you do to resolve this error?
Which two capabilities are granted with the SUPER privilege?
Which statement best describes the meaning of the values in the ref columns?