b SELECT FROM tutorial WHERE MATCHtitle description AGAINST left right IN

B select from tutorial where matchtitle description

This preview shows page 14 - 16 out of 20 pages.

b. SELECT * FROM tutorial WHERE MATCH(title, description) AGAINST ('left right' IN NATURAL LANGUAGE MODE);c. SELECT * FROM tutorial WHERE MATCH(description) AGAINST ('left right' IN NATURAL LANGUAGE MODE);d. SELECT * FROM tutorial WHERE MATCH(title, description) AGAINST ('left' IN NATURAL LANGUAGE MODE);Try again. See Module 7, Page III.0/1Question 10The difference between a primary key and a unique key isa. Both Primary and Unique Key is implemented for Uniqueness of the column. Primary Key creates a unclustered index of column and Unique creates an unclustered index of column. Moreover, Primary Key doesn’t allow NULL value, however Unique Key does allow one NULL value.b. Both Primary and Unique Key is implemented for Uniqueness of the column. Primary Key creates a clustered index of column where as an Unique creates unclustered index of column. Moreover, Primary Key doesn’t allow NULL value, however Unique Key does allows one NULL value.Selected:c. Both Primary and Unique Key is implemented for Uniqueness of the column. Primary Key creates a clustered index of column and Unique creates clustered index of column. Moreover, Primary Key doesn’t allow NULL value, however Unique Key does allow one NULL value.This answer is incorrect.d. Both Primary and Unique Key is implemented for Uniqueness of the column. Primary Key creates a clustered index of column where as an Unique creates unclustered index of column. Moreover, Primary Key allows one NULL value just like a Unique Key.Try again. See Chapter 15 inBeginning MySQL,Optimizing Performance.Question 1You need to do a full-text search on the productLine field in the products table. Which commands will allow you to do this?Questions 4 - 6 are based on the following table definition.
Background image
a. ALTER TABLE products ADD KEY(productline);Selected:b. ALTER TABLE productlinesADD FULLTEXT(productline);This answer is incorrect.c. ALTER TABLE products ADD FULLTEXT(productline);d. ALTER TABLE products INSERT FULLTEXT(productline);Try again. See the technical note referenced at-language-search.aspx1/1Question 2When table fuinfo is initially loaded with 10 million records, the email addresses were not included. Youwere recently supplied those email addresses and now you need to update those records. What should you do before updating those records?Questions 12 - 14 are based on the following table definition:CREATE TABLE fuinfo(fid int(10) unsigned NOT NULL,name varchar(40) NOT NULL,email varchar(128) NOT NULL,UNIQUE KEY email (email),UNIQUE KEY fid (fid)) ENGINE=MyISAM DEFAULT CHARSET=utf8a. alter table fuinfo drop index email;b. drop index email on fuinfo;Selected:c. Both a and bThis answer is correct.d. Neither a nor bCorrect!
Background image
Image of page 16

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture