Q151.You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?
A)Use the AES_ ENCRYPT () MySQL function on the option file.
B)Use mysql_ secure_ installation to encrypt stored login credentials.
C)Use a text editor to create a new defaults file and encrypt it from Linux prompt.
D)Use mysql_ config_ editor to create an encrypted file.
Answer:D
Q152.You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)
A)ibbackup files
B)*.CSM files
C)*.sdi files
D)*. ibd files
E)ib_ logfile* files
1.3.2 Files Backed up for InnoDB Data
The InnoDB-related data files that are backed up include the ibdata* files (which represent the system tablespace and possibly the data for some user tables), any .ibd files(which contains data from user tables created with the file-per-table setting enabled), and the data extracted from the ib _logfile* files (the redo log information representing changes that occur while the backup is running), which is stored in a new backup file ibbackup_ logfile.
Answer:DE
Q153.Examine this statement and output:
myaql> SELECT ROMI NCMBER() OVER() A5 gai,
query, exeo_ ,count, avg latency»