Please answer the following questions. Three In total. QUESTION 31 Access to a v
ID: 3706063 • Letter: P
Question
Please answer the following questions. Three In total.
QUESTION 31 Access to a very large database table is generating performance issues and the table space it belongs to is full. The Database Admin will configure the table to extend to another table space to address this issue and provide more space for the table. True False QUESTION 32 The database Administrator has identified a performance issue when users begin their day and log on to applications because the backing up to tape of a very large table is taking 18 hours to complete, which extends into the time when users are starting to work in the morning. The Administrator decides to partition to solve this problem. Which partitioning scheme would make sense for this scenario & what strategy will the admin use to reduce the backup time using this partition scheme? (Note: You need to identify the partitioning scheme and explain how it will be used to solve this problem) Path: p Words:0Explanation / Answer
Question 31;
Answer is false instead of extending table space we can use table partition.
Question 32:
According to question Hash Partition would work well here beacuse it totally based on key . Hashing partition based on hashing algorithm which is very efficient in searching the data on the behalf of key,it is work well with large scale data.java programming is also using hashing technique for internal data structure.
Question 33.
Dividing the data using districts,he advantage of list partitioning is that you can group and organize unordered and unrelated sets of data in a natural way.
SQLQuery to do list partition:
According to above scenario the list based partition is best suited.
create table Employee (employeeID number(5),Name varchar2(30),Dist varchar2(15),HireDate Date)
Partition by list (Dist),
Partition North values (‘NorthAtlantic’,'North Cenral','North Pacific'),
Partition south values (’SouthEast’,'South Central'),
Partition Southeast values (‘Southpacific');