The maximum number of elements allowed in SET() is ___________ 

What is generally used as a synonym for CHARACTER SET? 

If the storage engine InnoDB is not used, a foreign key cannot be used. 

Which SQL function is used to count the number of rows in a table?

What will be returned length value?

SELECT CHARACTER_LENGTH("Abekus . com") AS LengthOfString;

Which function returns a reference to a hash of row values?

 The system variable in MySQL server that enables to configure the SQL mode is __________ 

What is x in the following statement?

DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;

Write the query to get the employee's first name and last name of the employee table.

In the following query, what does “person_id” stands for?

 CREATE TABLE person    (person_ id SMALLINT UNSIGNED,    fname VARCHAR(20),    lname VARCHAR(20) ,    CONSTRAINT pk_person PRIMARY KEY (person_id));