Database - Introduction to SQL - Discussion

Discussion :: Introduction to SQL - General Questions (Q.No.10)

10. 

Which of the following is valid SQL for an Index?

[A]. CREATE INDEX ID;
[B]. CHANGE INDEX ID;
[C]. ADD INDEX ID;
[D]. REMOVE INDEX ID;

Answer: Option A

Explanation:

No answer description available for this question.

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.