Explain categories of failures that occur in oracle database, Database Management System

Assignment Help:

Explain different categories of failures that occur in Oracle database?

Categories of Failures - In Oracle database subsequent types of failures can occurred:
Statement Failure
• Bad data type
• Insufficient space
Insufficient Privileges (e.g., object privileges to a role)
User Process Failure
• User performed an abnormal disconnect
• User's session was abnormally terminated
• User's program raised an address exception
User Error
• User drops a table
• User damages data by modification
Instance Failure
Media Failure
• User drops a table
• User damages data by modification
Alert Logs
• Records informational and error messages
• All Instance startups and shutdowns are recorded in the log


Related Discussions:- Explain categories of failures that occur in oracle database

What are the desirable properties of a decomposition, Define What are the d...

Define What are the desirable properties of a decomposition Ans: What are the desirable properties of decomposition - dependency preserving.  Because Lossless join and dependen

Data modelling and normalization methodology, MOSS VALE is a town with 1500...

MOSS VALE is a town with 15000 inhabitants. The fire department wishes to develop a system that automates the despatch of fire engines to attend fires. The ERD below describes the

Assignment, how does Btree differ from a B+ - tree?

how does Btree differ from a B+ - tree?

What is distributed system, What is Distributed system ? Distributed S...

What is Distributed system ? Distributed System - A distributed system consists of a number of processing parts in which are interconnected through a computer network and in

Define average latency time, Define average latency time. The average l...

Define average latency time. The average latency time of the disk is one-half the time for a full rotation of the disk.

Production management, create an er diagram for production management in fi...

create an er diagram for production management in film industry

Describe the most important classes of parallel machines, Question 1 Discu...

Question 1 Discuss the classification of DBMS based on location of database Question 2 Explain with examples different SQL commands used for creating and deleting relations.

What is middleware, Question: a) What is Client/Server and what benefit...

Question: a) What is Client/Server and what benefits can be expected from Client/Server systems? b) Explain what middleware is and what it does. Why would MIS managers be p

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd