Question: please help me with these SQL questions in oracle 12c 1. Create a sequence for populating the Customer# column of the CUSTOMERS table. When setting

please help me with these SQL questions in oracle 12c
please help me with these SQL questions in oracle 12c 1. Create
a sequence for populating the Customer\# column of the CUSTOMERS table. When

1. Create a sequence for populating the Customer\# column of the CUSTOMERS table. When setting the start and increment values, keep in mind that data already exists in this table. The options should be set to not cycle the values and not cache any values, and no minimum or maximum values should be declared 2. Add a new customer row by using the sequence created in Question 1. The only data currently available for the customer is as follows: last name = shoulders, first name = Frank, and zip = 23567 3. Create a sequence that generates integers starting with the value 5 . Each value should be three less than the previous value generated. The lowest possible value should be 0 , and the sequence shouldn't be allowed to cycle. Name the sequence MY_FIRST_SEQ 4. Change the setting of MY_FIRST_SEQ so that the minimum value be generated is -1000 Create an indek 5. Create a bitmap index on the customers table to speed up queries that search for customens bated on the state they ive in: 2. Add a new customer row by using the sequence created in Question 1. The only data currently available for the customer is as follows: last name = shoulders, first name = Frank, and zip = 23567 3. Create a sequence that generates integers starting with the value 5 . Each value should be three less than the previous value generated. The lowest possible value should be 0 , and the sequence shouldn't be allowed to cycle. Name the sequence MY_FIRST_SEQ. 4. Change the setting of MY_FIRST_SEQ so that the minimum value be generated is -1000 Create an index 5. Create a bitmap index on the customers table to speed up queries that search for customers based on the state they live in. 6. Write a query that will remove the index you created question 5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!