contestada

6. create the following indexes: a. create an index named owner index1 on the state column in the owner table. b. create an index named owner index2 on the last name column in the - - owner table. c. create an index named owner index3 on the state and city columns in the owner table. list the states in descending order

Respuesta :

(a) Create an index trip index1 on trip name in the trip table.

Create index trip index1

On trip (trip name)

(b) Create index Trip index2 on type of trip table.

Create index trip index2

On trip (TYPE)

(c) Create index Trip index3 for last name, first name of table customer.

Create index trip index2

on customer

The syntax for creating indexes varies by database. Check the syntax for creating indexes in your database. Indexes can be created or dropped without affecting the data. Creating an index involves the Create index statement. This allows you to name the index specify the table and column to index and specify whether to arrange the index in ascending or descending order.

Learn more about An index here:-https://brainly.com/question/22930696

#SPJ4