A.The json_extract() function requires a length value that matches the field length in the schema.

B.The virtual values in the name column must be accessed using functions.

C.Table statistics must be updated to generate values for the name column.

D.The select requires json_unquoteo in the where clause.

E.The JSON datatype cannot be used in virtual columns.

A.A server restart always resets the AUTO_INCREMENT value to largest value in the AUTO_INCREMENT column plus 1.

B.The decimal data type supports AUTO_INCREMENT.

C.AUTO_INCREMENT values allocated to a transaction that is rolled back are not reused.

D.An AUTO_INCREMENT column must be indexed.

E.A table can have multiple AUTO_INCREMENT columns.

A.It displays similar diagnostics results as get diagnostics.

B.It displays errors messages only, since the start time of the current session.

C.It displays the total number of errors, warnings, and notes since the server last restarted.

D.It cannot display information for more than max_errot_count server system variable setting.

E.It displays errors messages only, since the server last restarted.

F.It displays the total number of errors, warnings, and notes since the beginning of the current session.

A.The inserted row is not returned because the transaction still active in s2.

B.The inserted row is returned because the transaction is auto committed in S2.

C.The inserted row is not returned because the isolation level is READ COMMITTED in S2.

D.The inserted row is returned because the isolation level is RPEATABLE READ in S1.

A.db . country, select ( [ ' Name LIKE "united%" ' , ' Population>^0 ' ] ) - limit (5)

B.db. country-select(['Name','Population']) .where('Name LIKE :param') -bind ('param' , 'United*') -limit(5)

C.db . country. fields ( [ ' Name ' , 'Population']) . select (' limit=5 ' ) .where('Name LIKE "United%" ' )

D.db.country. fields ( [ 'Name ' , 'Population* ] ) .where ( 'Name LIKE "United%',,) -select ()-limit(5)

E.db . country. Select ([Name' , 'Population.'] ) -limit (5) .where('Name LIKE "United%"')