Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started