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

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.
The gathering and use of undo statistics is done with the goal of improving the efficiency of the undo tablespace. What, if anything, can be learned by undoing tablespaces? Who exactly has access to the statistics of the undo tablespace is not entirely obvious. Oracle 11g has stringent requirements for users.
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
In Oracle, if you have two tables related by connecting a primary key in table B and a foreign key in table A, how does the database behave during the insertion of a new record into table A? Question 45 options: 1) It creates a new primary key attribute that is automatically numbered as a sequence of numeric values. 2) It prevents foreign key values from being duplicated in table A. 3) It prevents any records from being deleted from either Table A or Table B. 4) It prevents a row from being inserted into table A if the data in the foreign key column of table A doesn't match any of the values in the primary key column of the table B.
Why is the foreign key important for the integrity of a database? Can you come up with a scenario to show why it is necessary?
How do you manage cascading actions in database triggers, and what precautions should be taken?
When would it be reasonable to make the assumption that two select statements taken from the same database are consistent with one another? What type of circumstances would warrant such an assumption?
1. What actions are being audited? Options: CHOOSE ONE OPTION A. SELECT B. DELETE C. UPDATE D. INSERT E. ALL OF THE ABOVE
What happens if someone tries to break a database's referential integrity? What types of errors are possible?
this is an ITSE 2356 COURSE ,we use Iggy fernandez and Bob Bryla as a reference : Case: As of late, there seems to be a perpetual problem with current database table size growth causing performance problems, -- in that you are at a point of daily tablesize management. Task: Develop and preapre a plan that will create a reporting process to monitor database growth.(as part of your submittal - write the suggested SQL queries). Again, this shoud be no less one typed word file. Also recommend the use of Spooling or some other Oracle print process for query submital.
Chapter 9 from book "DATABASE SECURITY AND AUDITING: Protecting Data Integrity and Accessibility" by Hassan A. Afyouni Hands On Project 9-2: Your security policy requires you to track every table creation statement to a table, but only when the creation is not successful. List all steps necessary to audit every unsuccessful instance of a user attempting to create table.
What does the term database integrity mean? Enumerate all Oracle limitations required to maintain database integrity.Explain the difference between the IN and OR operators using code examples.