This topic contains a solution. Click here to go to the answer

Author Question: To create a MySQL index using SQL, the correct SQL statement is ________. A) ALTER TABLE ... (Read 53 times)

jjjetplane

  • Hero Member
  • *****
  • Posts: 556
To create a MySQL index using SQL, the correct SQL statement is ________.
 
  A) ALTER TABLE TableName ADD INDEX IndexName
  B) ALTER TABLE TableName INSERT INDEX IndexName
  C) CREATE INDEX IndexName ON TABLE TableName
  D) Both A and C are correct

Question 2

Which of the following is not true about document type declarations for XML documents?
 
  A) They are not required.
  B) They are required for type-valid documents.
  C) They cannot be contained inside the XML document.
  D) Storing the DTD externally allows many documents to be validated against the same DTD.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

livaneabi

  • Sr. Member
  • ****
  • Posts: 328
Answer to Question 1

A

Answer to Question 2

C




jjjetplane

  • Member
  • Posts: 556
Reply 2 on: Jul 7, 2018
Great answer, keep it coming :)


ricroger

  • Member
  • Posts: 352
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

In Eastern Europe and Russia, interferon is administered intranasally in varied doses for the common cold and influenza. It is claimed that this treatment can lower the risk of infection by as much as 60–70%.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Patients should never assume they are being given the appropriate drugs. They should make sure they know which drugs are being prescribed, and always double-check that the drugs received match the prescription.

Did you know?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

Did you know?

Earwax has antimicrobial properties that reduce the viability of bacteria and fungus in the human ear.

For a complete list of videos, visit our video library