Discussion :: Introduction to SQL - General Questions (Q.No.10)
| Ankur said: (Nov 26, 2010) | |
| create index id on <table_name>(<column_name>); | |
| Dipty said: (Mar 11, 2011) | |
| CREATE INDEX ID<TABLE_NAME><COLUMN_NAME> | |
| Sahil said: (Oct 27, 2014) | |
| Create index id is right because first we have to create index then we use ADD or REMOVE commands. | |
| Kondareddy said: (Dec 24, 2014) | |
| Create index id is valid. Ex: Create index id emp ename; |
|
| Narendra said: (Aug 29, 2015) | |
| Option A is correct. Why first you create a table after insert, add, delete, remove, change? |
|
| Mitali said: (Mar 17, 2016) | |
| Is add Index and Remove Index correct syntax? According to my knowledge we can only create Index to find data more quickly and efficiently. If we can add/Remove Index can anyone provide the syntax of the same? |
|
| Shanu said: (Oct 25, 2016) | |
| Create index id is correct because first, you have to create id then change, drop, remove. | |
| Arti said: (Nov 15, 2016) | |
| The syntax for adding an index to an existing table is, ALTER TABLE "table_name" ADD INDEX "index_name" (column_name); And to remove index we use drop index. Syntax: DROP INDEX index_name ON table_name. |
|
| Mohammed Kemal said: (Jun 15, 2019) | |
| Create index id is correct. | |
| Mohammed Kemal said: (Jun 15, 2019) | |
| I think the corecte anwsere is A. | |
Post your comments here:
Name *:
Email : (optional)
» Your comments will be displayed only after manual approval.