MP Online Search...

MPOnline नौकरी चाहिए लॉगिन करें MP Job News MP Online
  • Home
  • Blog
  • New Notifications
  • State wise jobs
  • Admit Card
  • Results
  • Privacy Policy
  • about us
  • contact us
  • bank vacancy
  • Home
  • Blog
  • New Notifications
  • State wise jobs
  • Admit Card
  • Results
  • Privacy Policy
  • about us
  • contact us
  • bank vacancy

41. What are different types of relational constraints?
Ans: Friends
1. Domain constraints
2. Key constraints
3. Entity integrity constraints
4. Referential integrity constraints
Domain constraints specify that the value of each attribute must be an atomic value from the domain of the attributes.
Key constraints tell that no two tuples can have the same combination of values for all their attributes.
Entity integrity constraint states that no primary key value can be null.
Referential integrity constraints states that a tuple in one relation that refers to another relation must refer to an existing tuple in that relation it is specified between two relations and is used to maintain the consistency among tuples of the two relations.

42. What do you mean by difference between a super key, a key, a candidate key and a primary key?
Ans: Friends a super key specifies a uniqueness constrain that no two distinct tuples in a state
can have the same value for the super key. Every relation has at least one default super key.
A key is a minimal super key or the subset of the super key which is obtained after
removing redundancy. A relation schema may have more than one key .In this case
each key is called a candidate key. One of the candidate key with minimum number
of attributes is chosen as primary key.

43. What do you mean by a foreign key?
Ans: Friends A key of a relation schema is called as a foreign key if it is the primary key of
some other relation to which it is related to.

44. What do you mean by a transaction?
Ans: Friends A transaction is a logical unit of database processing that includes one or more
database access operations.

45. What are the properties of transaction?
Ans: Friends
1. Atomicity
2. Consistency preservation
3. Isolation
4. Durability (permanence)

46. What are the basic data base operations?
Ans: Friends
1. Write_item(x)
2. Read_item(x)

47. What are the disadvantages of not controlling concurrency?
Ans: Friends
1. Lost update problem
2. Temporary update (Dirty read) problem
3. Incorrect summary problem

48. What are serial, non-serial?
Ans: Friends A schedule S is serial if, for every transaction T participating in the schedule, all the operations of T is executed consecutively in the schedule, otherwise, the schedule is called non-serial schedule.

49. What are conflict serializable schedules?
Ans: Friends A schedule S of n transactions is serializable if it is equivalent to some serial schedule of the same n transactions.

50. What do you mean by result equivalent?
Ans: Friends Two schedules are called result equivalent if they produce the same final state of the data base.
मित्रों, जिन्होंने ने भी हमारे यूट्यूब चैनल को सब्सक्राइब कर लिया है उन्हें नए जॉब की जानकारियां ई-मेल के माध्यम से भेजी जायेगी | इसलिए तुरंत हमारे यूट्यूब चैनल पर जाकर सब्सक्राइब का बटन दबाएँ और हमारे चैनल को सब्सक्राइब कर लें
# Please Subscribe
MPOnline youtube channel
  • »  CATEGORIES
  • UPSC यूपीएससी जॉब्स
  • SSC एस एस सी जॉब्स
  • Teaching टीचिंग जॉब्स
  • Bank बैंक/ इंश्योरेंस सेक्टर जॉब्स
  • Railway रेलवे जॉब्स
  • Engineering इंजीनियरिंग जॉब्स
  • ITI Jobs आई. टी. आई. जॉब्स
  • MCA PGDCA DCA Jobs
  • Law Jobs
  • Army-Jobs आर्मी/डिफेन्स
  • State-Police-Jobs स्टेट पुलिस जॉब्स
  • Anganwadi-Jobs आंगनबाड़ी जॉब्स
  • 10 वी /12 वीं जॉब्स
  • Graduate Jobs
  • Medical/Hospital मेडिकल/हॉस्पिटल
  • IT Jobs आई. टी. जॉब्स
  • एमबीए (MBA) / IIM Jobs
  • चार्टर्ड अकाउंटेंट (CA) / ICWA Jobs
  • PSU नवरत्न कम्पनी जॉब्स
  • Agriculture Jobs कृषि जॉब्स
  • Admit Card
  • Results
  • State Jobs - अपना राज्य चुनें
  • MP Jobs - मध्य प्रदेश जॉब्स
  • अपना जिला चुनें
  • »  अपना राज्य चुनें
  • Andhra Pradesh
  • Arunachal Pradesh
  • Sikkim
  • Rajasthan
  • Assam
  • Bihar
  • West Bengal
  • Delhi
  • Chandigarh
  • Chhattisgarh
  • Dadra and Nagar Haveli
  • Daman and Diu
  • Goa
  • Gujarat
  • Uttar Pradesh
  • Haryana
  • Himachal Pradesh
  • Jammu and Kashmir
  • Puducherry
  • Karnataka
  • Kerala
  • Ladakh
  • Lakshadweep
  • Madhya Pradesh
  • Maharashtra
  • Manipur
  • Meghalaya
  • Andaman and Nicobar Islands
  • Mizoram
  • Jharkhand
  • Nagaland
  • Odisha
  • Punjab
  • Tamil Nadu
  • Telangana
  • Tripura
  • Uttarakhand
  • »  STUDY MATERIAL
  • Personality Development
  • How to Prepare For Civil Service
  • Sample/Test Papers (for all exams)
  • Interview Questions with Answers
  • IT Questions
  • Syllabus with Exam Pattern
  • School/College Projects
  • General Knowledge
  • Resume
  • Resume Writing Tips
  • Career Options After 12th
  • Career Options For Graduates
  • Interview Tips
  • Moral Stories
  • Indian Cuisine
  • »  SAMPLE PAPERS
  • M.P.Board - Xth XIIth Sample Papers
  • CBSE - Xth XIIth Sample Papers & Books
  • MPPSC - SAMPLE PAPERS
  • Civil Service Pre. GS 2011
  • Bihar Psc Pre GS 2011
  • Bihar Gramin Bank Officers Exam
  • Gurgaon Gramin Bank
  • Indian Bank PO
  • Union Bank PO

MPOnline Job

नए Jobs की जानकारियां MP की विश्वसनीय Job वेबसाइट MP Online Job News हिंदी में

Online MP Job

देश भर के विभिन्न Recruitment Board, MP online व सरकारी-गैर सरकारी विभाग प्रतिदिन नयी Job निकालते हैं जैसे की UPSC Job, SSC Job, MPPSC Job, Railway Job, Bank Job, VYAPAM Job, NRHM Job, MPPKVVCL Job,निजी क्षेत्र, Indian Army Job, Teacher Job, Anganbadi Job MPOnline के रोजगार समाचार हिंदी में पढ़े

MPOnline Job MP रोजगार समाचार

और बहुत कुछ | अब अपनी भाषा हिंदी में पायें सही व प्रामाणिक

Job MPOnline रोजगार समाचार हिंदी एम.पी ऑनलाइन

की जानकारियां, जो आपको अन्यत्र कहीं नहीं मिलेंगी |
Online MP Job & Employment News रोजगार समाचार हिंदी
आपको सदैव उपलब्ध कराता है देश व प्रदेश के रोजगार समाचार

Powered by Create your own unique website with customizable templates.