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!
Redo Logs:Any database must have minimum two redo logs. These are the rules for the database; the redo logs record all modifies to the system objects or user objects. If any type of failure happens, modifies recorded in the redo logs may be used to bring the database to a proper state without losing any committed operations. In the case of non-data loss failure, Oracle may accept the information in the redo logs automatically without intervention from the DBA. The redo log files are fixed in shape and size and never show dynamically from the size at which they were prepared.
What is a Database? To know what database is, we have to start from data, which is the basic building block of any DBMS. Data: Facts, figures, statistics etc. having no pa
Explain data independence ? Data independence is the capacity to modify the schema at one stage of a database system without having to change the schema at the further level.
Consider the subsequent relation Professor (Pfcode, dept, head, time) It is assumed that (i) A professor can work in much more than one
What is Alternate Key Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, the
Hardware failure : Hardware failures are the failures when some disk or hardware chip fails. This may result in loss of data. One such trouble can be that a disk gets damaged and
Explain the main advantages of DBMS over File Oriented System ?
What are stand-alone procedures? Procedures that are not part of a package are called as stand-alone because they independently defined. A good example of a stand-alone procedu
explain cascading rollback
sql is relationally complete-justify
task upload
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: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd