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.

MBA 1st semester Paper : Quantitative Techniques in Management

Quantitative Techniques in Management

Unit 1: Differentiation, Law of Derivatives, Repeated Derivatives, Partial Differentiation, Maxima & Minima-single variable and multi variable functions.

Unit 2: Linear Dependence and Independence of Vector, Determinants, Matrices, inverse of matrix, system of linear equation and their solution- using matrix inverse method.

Unit 3: Measures of Central Tendency and Measures of Dispersion; Probability-types, addition and multiplication, Bayes’ Theorem; Discrete and Continuous Probability Distribution- Binomial, Poisson and Normal Distribution.

Unit 4: Concept of Sampling Distributions; Type I & Type II errors, Chi-square test, Hypothesis testing- Single and Two Population, Z test, t test.

Unit 5: Correlation and simple linear regression, Rank Correlation, Time series analysis.

Unit 6: Decision Theory; Decision under uncertainty and risk, Decision Criteria; Bayesian Analysis: Posterior Analysis; Decision Tree; Markov Chains.

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

Admission Criteria for MBA course in Gauhati University

Admission Criteria for MBA Course in Gauhati University:

   

MBA Programme in GU

Eligible applicant will have to appear in a written test, to be conducted by Gauhati University, meant to evaluate their quantitative aptitude, general awareness and proficiency in English. However candidates who have appear in anyone of the All India Common Entrance of the relevant session for admission to MBA programme, viz. CAT, MAT, ATMA, or XAT and scored marks not less than 75 percentile are exempted from appearing in the written test conducted by Gauhati University. Candidates qualifying in the written test conducted by Gauhati University or a candidate having scored marks not less than 75 percentile in the aforesaid All India Common Entrance may be permitted to appear in the Group Discussion and Personal Interview for selection. The final selection will be based on the applicant’s overall performance in the written test, group discussion and interview.

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.