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
Explain the Weak Entity Set An Entity set which does not have sufficient attribute to make a primay key is known as weak entity set. For instance, dependents of an employee in
Types Of Indexes One of the words used during the file organisation is the term index. In this part, let us describe this term in more detail. We find the index of keywords
What is trigger? Triggers are statements that are executed automatically by the system as the side effect of a modification to the database.
Describe the types of attributes? Types of attributes: An attribute's category determines the type of values that are permitted in the attribute. For instance, the value vers
If the deletion violates referential integrity constraint, then three alternatives are available: Default option: - refuse the deletion. It is the job of the DBMS to describ
Q. Explain the terms key constraints participation constraints and mapping caradinalities in ER model. Participation Constraints : The participation of an entity set E i
complete er diagram of textile industry management
An object-oriented design process 1. Define the context and modes 2. Designs the system architecture 3. Identifies the principal system objects 4. Identifies concurrency in
If one requires to access data using Logical Database , the use of events is unavoidable. Yes, if someone wants to access data using Logical database then the use of events
Do NOT use the timestamp type. Use separate date and time data types only. Figure out how to define an SQL insert statement that uses built-in SQL (or MySQL) functions to define
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