Which of the following are true concerning indexes?

Assume, you have a table inventory(id int, description text, price int). How can you change the type of price from int to decimal(10,2)?

In a WAMP environment, what is the correct way to permanently change the largest possible packet that can be transmitted to or from a MySQL server?

Given two tables, t1 and t2, the join condition 't1.t2_id = t2.id' how do you get rows from t1 that have NO counterparts in t2?

How would you remove all rows from a table 'STAFF'

The user-created stored function 'test' takes a varchar(5) and an integer and returns a varchar. Which of the following correctly calls the function?

Which operators are supported by boolean full-text search?

Invalid year data type values are converted to which of the following?

In MySQL 5.6.5. how many bytes are required to store the DATETIME data type?

Result of this query? SELECT lNSERT()

Which holds correct while optimizing the query? 1) Use ((a AND D) AND c OR (((a AND D) AND (c AND d)))) instead of (a AND D AND c) on (3 AND b AND c AND d) 2)Use b>5 AND b=c AND 825 instead of (a 3}Use (8>=5 AND 8:5) OR (8:6 AND 5:5) 0R (8:7 AND 5:6) instead of B=5 OR 8=6