Hi Guest

MobileUser

1 HomePage 1 Jobs 1 WalkIn 1Articles  

Cat Exam

 :) Latest Topic
AJAX
VB.NET
SQL Query
UDDI
CLASS
JavaScript Questions
SharePoint Interview
SilverLight
WCF
general knowledge
 ASP.NET
 :) Hot Jobs
 
 :) Latest Articles


  

 


What is true about index in SQL?
Question Posted on 14 Jul 2022

Home >> DataBase >> SQL Quiz >> What is true about index in SQL?




What is true about index in SQL?
Choose the correct option from below list
(1)Indexes are special lookup tables that the database search engine can use to speed up data retrieval.
(2)Indexes are special lookup tables that the database search engine can use to speed up data deletion.
(3)Indexes can be created or dropped with an effect on the data.
(4)An index helps to speed up insert statement.

Answer:-(1)Indexes are special lookup tables that the database search engine can use to speed up data retrieval.
0
0



 
 Input Your Comments Or suggestions(If Any)
 Name
 Email(optional)
 Comments


Other Important Questions
We can create Views for?
Name the exception which is raised when a null object is automatically assigned a value?
Which option in view is to ensure that all UPDATE and INSERTs satisfy the condition(s) in the view definition?
How many types of exception are there in sql?
Which of the following specifies when the trigger will be executed?






 
Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions
PHP | Biztalk | Testing | SAP | HR |