Please select the best Ans for the following question? Thank you Question 6 (1 p

Question

Please select the best Ans for the following question? Thank you

Question 6 (1 point) After you have updated the email addresses, what should you do? 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=utf8

a DESCRIBE fuinfo;

b CREATE UNIQUE INDEX email ON fuinfo(email);

c TRUNCATE fuinfo;

d SELECT * from fuinfo;

Question 7 (1 point) You 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. The figure shows the table schemas and table relationship of the productLines and products tables from the classicmodelcars database. The productLines table has four fields: productLine, textDescription, htmlDescription, and image. The primary key is productLine. The products table has nine fields: productCode, productName, productLine, productScale, productVendor, productDescription, quantityInStock, buyPrice, and MSRP. The primary key of the products table is productCode. productLine is a foreign key that corresponds to productLine in the productLines table. The table relationship is zero or more products make up a product line.

a ALTER TABLE products ADD KEY(productline);

b ALTER TABLE productlines ADD FULLTEXT(productline);

c ALTER TABLE products ADD FULLTEXT(productline);

d ALTER TABLE products INSERT FULLTEXT(productline);

Explanation / Answer

6. After you have updated the email address then you should create an INDEX so as to speed the data retrieval by using queries.

a DESCRIBE fuinfo: it will simply describe the structure of the table.

b CREATE UNIQUE INDEX email ON fuinfo(email): it will create index on the column email that will enhance the retrieval process of the data.

c TRUNCATE fuinfo: It will delete all the rows from fuinfo.

d SELECT * from fuinfo : It will display all the data(rows) of funinfo.

depending on the need you can use these queries.

7.You need to do a full-text search on the productLine field in the products table.

=> Data of a column must be full text indexed in order to perform a full text search in MYSQL Therefore option c( ALTER TABLE products ADD FULLTEXT(productline) should be the best answer.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.