A.It undoes the insert command.

B.It returns an error because there is no active transaction.

C.It has no effect.

D.It undoes both insert and update commands.

E.It undoes the update command.

A.Execution performance can be improved by adding an index on column description.

B.Execution performance can be improved by, using a composite index with column description as the leftmost prefix column description.

C.No index will improve statement performance.

D.Execution performance can be improved by using like instead of RLIKE.

E.The statement takes advantage of index description_idx.

A.The statement will wait for the transaction in Session 1 to finish.

B.The row will be updated immediately.

C.The transaction in Session 1 will be rolled back automatically.

D.A deadlock will occur.

A.Replace line 2 with Slink = mysql.connect {"localhost: 3306n, "username", "pas "schema") ;

B.Enable the mysqli extension in the php.ini file.

C.Install the PHP executable in the path used by the MySQL installation.

D.Replace line 2 With: Slink = mysql_xdevapi\getSession
("mysqlx://username:password@localhost:3306","schema");

A.SELECT Name, Gender, Sport, RPAD ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

B.SELECT Name, Gender, Sport, CONCAT ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

C.SELECT Name, Gender, Sport, CHAR_LENGTH ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

D.SELECT Name, Gender, Sport, LENGTH (GPA*10, '# ') AS GPA_Graph FROM players ORDER BY GPA DESC;

E.SELECT Name, Gender, Sport, REPEAT('# 'Y GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;