Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Fundamentals Of Fashion Management

Authors: Susan Dillon

2nd Edition

1474271219, 978-1474271219

More Books

Students also viewed these General Management questions

Question

13. List five techniques for closing a bad-news message.

Answered: 1 week ago

Question

Draw the most likely product of the following reaction: OH H3PO4

Answered: 1 week ago