How do you get the field names and associated type of a MySQL table?

Correct syntax to switch to a new database in MySQL?

Which is correct about CHAR_LENGTH and LENGTH?

Which is valid for % and _ in the LIKE clause in a mysql query?

How do you return fifty events starting from 40th? Assume table name is events and you need to select only the column event_title.

Which is NOT a valid Aggregation Function?

MySQL supports 5 different int types. Which one takes 3 bytes?

How will you change 'Hansen' into 'Nilsen' in the LastName column in the Persons Table?

Which is not a valid Logical operator?

Correct SQL syntax for returning all the columns from a table named 'Persons' sorted REVERSE alphabetically by 'FirstName'?

Examine the query:- select (2/2/4) from tab1; where tab1 is a table with one row. This would give a result of: