Define atomicity and aggregation, Database Management System

 

Atomicity: Either all functions are laid out or none are. Users could not have to think about the effect of incomplete operations. DBMS ensures this by undoing the functions of incomplete operations.

 Aggregation: A concept which is needed to model a relationship between relationships and a collection of entities. It is used when we require express a relationship among relationships.

Name the three major groups of files on disk that devolve a database in Oracle There are three major groups of files on disk that devolve a database.

  • Database files
  • Control files
  • Redo logs

 The most important of these are the database folders where the actual data insides. The control files and the redo logs support the properties of the architecture itself. All three groups of files must be open, present, and available to Oracle for any data on the database to be utilized. Without these files, you cannot operate the database, and the database administrator has to answer some or the entire database needs a backup, if there is one.

 

Posted Date: 7/30/2012 2:30:22 AM | Location : United States







Related Discussions:- Define atomicity and aggregation, Assignment Help, Ask Question on Define atomicity and aggregation, Get Answer, Expert's Help, Define atomicity and aggregation Discussions

Write discussion on Define atomicity and aggregation
Your posts are moderated
Related Questions
Multi-Key File Organisation In this part, we will introduce two basic file Organisation schemes that permit records to be accessed by more than one key field, therefore, allowi

Give a sample of the Dynamic Model. The sample of dynamic model is given below:  Dynamic model for the car: Brake and Accelerator            Brake or Applies Accelerator

What are domain constraints?  A  domain is  a  set  of  values  that  might  be  assigned to an attribute  .all  values that appear in a  column of a relation must be taken fro

How external/conceptual mapping and conceptual /internal mapping is performed

lock and types of lock

Discuss the types of integrity constraints in which must be checked for the update operations - Insert and Delete. Give examples. Insert operation can violet any of the subse

Define the Third Normal Form: The third normal form (3NF) is a normal form employed in database normalization. 3NF was initially defined by E.F. Codd in 1971. Codd's definitio

Express the subsequent query in SQL assumes which the data is stored within EMPLOYEE table with relevant fields (i) Display name, job, salary, and hire date of employee who are

Explain what is Aggregation? Aggregation: Aggregation is an significant concept in database design whereas composite objects could be modelled during the design of database a

Explain retrieval in QBE? Retrieval in QBE : A "GUI" for expressing queries. Based on the Domain Relational Calculus (DRC) Actually invented before GUIs. Very co