Mysql Questions Set 10:
Hexadecimal numbers cannot be used in scientific notation.
Solution:
Which Keyword is used to remove duplicate rows in result set?
Solution:
In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at _____________
Solution:
Which storage engine enables to access tables from a MySQL server managed by another server?
Solution:
What is xyz in the following statement?
SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');
Solution:
In which mode of search is the search string parsed into words and the search looks for rows?
Solution:
What is ghi in the following statement?
CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;
Solution:
Which option is used in mysqldump to make all tables in the destination databases to use a different storage engine?
Solution:
What will be the output of the following query?
SELECT * FROM employee WHERE lname LIKE ‘F%’ OR lname LIKE ‘%T’;
Solution:
What will be the output of the query given below?
SELECT * FROM employee WHERE (title=’HEAD TELLER’) AND (start_date=2013-01-24);
Solution:
Related Question Sets:
Related Topics:
Scroll to Top
