Question
Please select the best possible Ans for the following questions? Thank you Question 8 (1 point) Which command can be used to show that an
Please select the best possible Ans for the following questions? Thank you
Question 8 (1 point) Which command can be used to show that an index has been removed on table fuinfo? 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 EXPLAIN fuinfo;
c SELECT * from fuinfo;
d SHOW fuinfo;
Question 9 (1 point) What are indexes in a database?
a Indexes are locations of tables within a database.
b Indexes are the quick references for fast data retrieval of data from a database.
c Indexes are the slow references for fast data retrieval of data from a database.
d Indexes are the quick references for fast data inserts of data.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started