Your database is 5GB and contain satable named Sales History. Sales informationis frequently inserted and updated. You discover that excessive page splitting is occurring. You need to reduce the occurr enceof page splitting in the Sales History table. Which code segment should you use?()
You execute the following command to change the status of the SALES tablespace: SQL> ALTER TABLESPACE sales OFFLINE; Which statements describe the effect of the command()
Practice 6 ● A man is applying for the post of Sales Manager in Yorkshire.
● Write a memo to Kofi, who is responsible for this stuff, saying:
● Your boss wants the resume and track records of this man;
● You want Kofi to do it fast.
● Write about 30—40 words.
You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?()
Which three post-sales Smart Design documents are available to help you better serve your customers? ()
Practice 4 ● Look at the charts below. They show the income from sales and the income from advertisements in eight different newspapers over a three-month period in 2001.
● Which chart does each sentence (11-15) on the opposite page describe?
● For each sentence, mark one letter (A-H) on your Answer Sheet.
● Do not use any letter more than once.
11. While income from advertisements rose steadily throughout the period, income from sales increased in June but then fell to below the May level.
12. Income from advertisements fell slightly in June and by a larger amount in July, whereas income from sales remained steady in the final month.
13. Although income from sales overtook income from advertisements in June, it then dropped back again at the end of the period.
14. Income from sales reached a low point in June while income from advertisements leveled off at the end of the period.
15. Income from advertisements reached a peak in July and income from sales was at its lowest point in June.
We believe that sales will increase soon; (), production costs will be going up also.
There has been a great increase in retail sales , ()﹖
To promote sales, advertisers often exploit consumer ______.
Practice 7 ● You are a regional sales manager of an international company. You have been asked to go to a meeting at your company’s head office. You cannot go, so somebody else will go in your place.
● Write an e-mail to Erica Young, who is organising the meeting:
● apologising for not being able to go to the meeting
● explaining why you cannot go
● saying who will go.
● Write 40-50 words.