a) Why we prefer the undo tablespace instead of backup segment. Justify your answer with logical reasoning b) Suppose you want to modify the retention time to manage the long undo tablespace. This can help you to undo a large amount of data. As a DBA, what factor you need to know to modify or increase the undo Retention and how you can implement that factor in oracle 11 g. c) Suppose you want to move from one tablespace to another tablespace. How can you automatically switch from one tablespace to another tablespace? Please write the procedure and implement it in oracle 11g. d) Undo statistics are used to tune the undo tablespace. Who can you manage or view the statistics of the undo tablespace what kind of information a undo tale space have? You need to implement the steps in oracle 11g.

a) Why we prefer the undo tablespace instead of backup segment. Justify your answer with logical reasoning b) Suppose you want to modify the retention time to manage the long undo tablespace. This can help you to undo a large amount of data. As a DBA, what factor you need to know to modify or increase the undo Retention and how you can implement that factor in oracle 11 g. c) Suppose you want to move from one tablespace to another tablespace. How can you automatically switch from one tablespace to another tablespace? Please write the procedure and implement it in oracle 11g. d) Undo statistics are used to tune the undo tablespace. Who can you manage or view the statistics of the undo tablespace what kind of information a undo tale space have? You need to implement the steps in oracle 11g.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

What is the definition of database integrity? List all Oracle restrictions that are used to ensure database integrity.With the use of code samples, explain the difference between the IN and OR operators.
I need help answering a few HW questions..... a. Name the different types of recovery and discuss the factors that influence when each type of recovery should be performed? b. Name and describe the three types of database failures that may require recovery? c. What is meant by the term log archival, and why is it important to assure recoverability? So I wasnt able to answer them completely, but I was able to answer these partially (Can someone help fill in my answers)?........... Recovery to Current Point-in-Time (PiT) Recovery Transaction Recovery ==================================================================== Instance Failures: Application Failures: Media Failures: ==================================================================== Long Archival indicates.....
Suppose each of the following update operations is applied directly to the below database state.Discuss which integrity constraints were violated by each operation and how you can enforce theseconstraints to ensure no violation occurs. If an operation does not violate any constraints, brieflyexplain why. d) Update dno of John B Smith to 3 in Employee table.e) Delete the employee Franklin T Wong from the Employee table.f) Delete the third record from works_on tableg) update pnumber of productX to 20 in project table
The purpose of collecting and analyzing undo data is to enhance the effectiveness of the undo tablespace. Does reverting tablespaces provide any useful information? It is unclear who gets access to the undo tablespace statistics and why. Users must meet rigorous prerequisites to access Oracle 11g.
In MS Access, if you have two related tables and you check the box to enforce referential integrity, how does the software behave during the insertion of a new record into the many table? Options: 1) It prevents a row from being inserted into the many table if the data in the foreign key column does not match any of the values in the primary key column of the one table.2) It prevents any records from being deleted from the primary or secondary table.3) It creates a new primary key attribute that is automatically numbered as a sequence of numeric values.4) It prevents foreign key values from being duplicated in the many table.
For each of the following statements, circle T (True) or F (False) 1 A row of data has to be all the same data type T F 2 A column of data has to be all the same data type T F 3 A data warehouse is a repository of information gathered from one Relational database T F 4 A trigger can only be connected to one table, and only update one table T F 5 If none of the attributes in the WHERE clause have indexes, the DBMS engine will be forced to do full table scans T F 6 You can have multiple triggers on the same table, and a trigger can be assigned to multiple tables T F 7 You should put an index on any attribute found in a WHERE clause T F 8 Checkpoints help the Recovery Manger streamline the recovery procedure T F 9 Big Data applications strictly adhere to ACID properties T F 10 A data warehouse should be used for OLAP processing T F
Professor please do not reject it under complex . I want answer and if you have not the anser please let someone other help me. if this behaviour is repeated agan it will be reported to the administration.
Why is it necessary to use a foreign key to ensure the database's integrity? Could you give an example of why this is so importa
What does the foreign key do to ensure database integrity? Do you want to do this for a certain reason?
36-Create a SQL statement of a read-only view, name it as ViewE, that will contain Gender and the number of clients per gender in the CLIENTS table.