Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 10)
10.
Which of the following is valid SQL for an Index?
Discussion:
10 comments Page 1 of 1.
Mohammed kemal said:
6 years ago
I think the corecte anwsere is A.
Mohammed kemal said:
6 years ago
Create index id is correct.
Arti said:
9 years ago
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.
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.
(2)
Shanu said:
9 years ago
Create index id is correct because first, you have to create id then change, drop, remove.
Mitali said:
9 years ago
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?
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?
Narendra said:
1 decade ago
Option A is correct.
Why first you create a table after insert, add, delete, remove, change?
Why first you create a table after insert, add, delete, remove, change?
Kondareddy said:
1 decade ago
Create index id is valid.
Ex: Create index id emp ename;
Ex: Create index id emp ename;
Sahil said:
1 decade ago
Create index id is right because first we have to create index then we use ADD or REMOVE commands.
DIPTY said:
1 decade ago
CREATE INDEX ID<TABLE_NAME><COLUMN_NAME>
Ankur said:
1 decade ago
create index id on <table_name>(<column_name>);
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers