What do you mean by atomicity and aggregation in DBMS ? Best Tutorial for Competitive Technical Exams

 What do you mean by atomicity and aggregation in DBMS ?

1. Atomicity: Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete transactions. DBMS ensures this by undoing the actions of incomplete transactions.

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

Inage Courtesy www.blog.paessler.com

 What is a Phantom Deadlock?

In distributed deadlock detection, the delay in propagating local information might cause the deadlock detection algorithms to identify deadlocks that do not really exist. Such situations are called phantom deadlocks and they lead to unnecessary aborts.

 What is a checkpoint and When does it occur?

A Checkpoint is like a snapshot of the DBMS state. By taking checkpoints, the DBMS can reduce the amount of work to be done during restart in the event of subsequent crashes.

What are the different phases of transaction?

Different phases are

1.) Analysis phase,

2.) Redo Phase,

3.) Undo phase.

Admission Process for MBA course in Gauhati University

MBA Admission in Gauhati University

Admission Process for Master of Business Administration in GU:

   

   There shall be a Selection Committee consisting of Dean, Faculty of Management; Head, Department of Business Administration, another senior teacher of the Dept. selected by the Dept. and two external members appointed by the Vice-Chancellor on the recommendation of the Head of the Dept. The Selection Committee shall select candidates on the basis of selection criteria as per clause 3 above and shall recommended names for final approval to the Admission Committee for the University. While selecting candidate, the Selection Committee shall consider the following reservation of seats (Total Number-14). In all such reserved cases, the candidates must fulfill the minimum eligibility as per clause 2 above.

a.     Scheduled Caste 7%

b.     Scheduled Tribes (Plains) 10%

c.     Schedule Tribes (Hills) 5%

d.     OBC & MOBC 15 %.

e.     One seat for the son / daughter of University Employees.

f.         One seat for candidate having extra-curricular proficiency. One seat for 

Physically Handicapped candidate.

In case of non-availability of qualifying candidates in each of the above reservation categories, seats will be filled up from candidates in the general category on merit basis.

Three additional seats are reserved for foreign students. Foreign         students      studying in Indian Universities are required to appear in the admission test. In case of Foreign students who are not required to appear for the test preference will be given to those who furnish their latest GMA T and TOFEL scores.

If an admitted candidate fails to attend classes for 20 days after commencement of classes his/her name shall be deleted from the Register after due notification to the University authorities concerned and the vacant seats thus shall be filled up from the waiting list. A student of the Course shall not be permitted to prosecute any other course of study or to hold full time/part time job/ service simultaneously

Eligibility Criteria for MBA Course in Gauhati University

MBA : Gauhati University

Eligibility Criteria for MBA Course in Gauhati University: 

A Bachelor’s degree of 10+2+3 pattern with minimum of 50% marks in aggregate or in Honours/Major subject (if any) from Gauhati University or any other recognized University

Examinations Rules and Regulations for MBA course

Examination Rule & regulations for MBA Gauhati University

MBA course structure & Paper Details

Examinations Rules and Regulations for MBA course

MBA Exam Rules

Examinations Rules and Regulations for MBA course:

a.   There will be 4 (four) examinations, one at the end of each semester.

      Duration of the Semester Period will be as follows:

      First and Third semester: June to December,  Second and Fourth Semester: January to May

b.   A candidate for the examination shall be examined as per syllabi, where each written full paper shall be of3 (three) hours’ duration.

c.   A candidate shall not be sent up for a semester examination if he/she has not attended at least 75% of the classes held for each subject including lecture, seminars, tutorials and case analysis.

d.   Each paper shall carry 100 marks, out of which 30 marks shall be allocated to internal evaluation. The minimum marks required for passing the examination shall be 40 percent both in the internal evaluation and written examinations, in each paper separately.

      Non-credit papers will be evaluated internally and grade will be awarded in lieu of marks. However, grades of non-credit papers will not be counted for declaration of result.