Correct Answer: CREATE INDEX index_name ON table_name (column_name)
Explanation:
Note: This Question is unanswered, help us to find answer for this one
SQL Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More SQL MCQ Questions
What is the Difference between Varchar and Char Datatypes in SQL?
What's the difference between "_" and "%" in sql wildcard
How do you select the first record of a table?
What is function for adding all the records of a column?
SELECT Customers.* FROM Customers LEFT OUTER JOIN Sales ON Customers.CustNo = Sales.CustNo What columns does this query return?
How many types of indexes?
TRUE/FALSE. All of the SQL language, syntax, and commands are universal across all major database platforms (Oracle, MySQL, and MS-SQL).
How to Extract characters from a text field?
SELECT dg.* FROM dgpricing dg LEFT OUTER JOIN icitem ic ON dg.Partno = ic.Item What columns does this query return?