Home / Programming MCQs / MySQL MCQs / Question
N
Q. A FULLTEXT index can be created for multiple columns.
In MySQL, a full-text search is based on the FULLTEXT indexes. A FULLTEXT index can be created both for a single column and for multiple columns. Searching is possible across columns.
You must be Logged in to update hint/solution
In MySQL, which command is used to modify the table values
What’s the difference between the DESCRIBE and SHOW FIELDS FROM commands?
The clause that is used to display information that matches a given pattern is
Which of the following is not a DML command?
Which of these commands will delete a table called XXX if you have appropriate authority:
Foreign keys cannot handle deletes and updates.
Which keyword is used to specify the foreign key after the table is created?
There cannot be more than one column per table with the AUTO_INCREMENT attribute.
What will be returned by the given query? SELECT round(153.669, 2);
Constructors are functions that return a new object as its value.
Discusssion
Login to discuss.