Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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
What is substitutability? Any method of a class-say A can equally well be adjured with any object belonging to any subclasses B of A. This characteristic leads to code reuse, a
What is a view? Make a view of EMP table named DEPT 20, to display the employees in department 20 and their annual salary. Ans: View is a virtual table that does not consist
random file orgnization
Is it mandatory to declare all the tables in Report by the key word tables for all the tables that exist in the structure of LDB, and are being explained in the Database part of LD
How to reduce data redundency
What is called query processing? Query processing refers to the range of activities included in extracting data from a database.
Question : (a) Explain with the help of appropriate examples the difference between ‘Data' and ‘Information'. (b) A digital image is an array of pixels, where each pixel h
a. Construct a query around any one of the functional divisions you made in 4a such that if executed in the distributed design of 4 would require reconstruction of at least two ho
WHAT IS SQL
What is DML (Data Manipulation Language)? This language that enable user to access or manipulate data as organised by appropriate data model. Procedural DML or Low level: DM
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!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd