Fundamental Rights |  UNESCO Intengible Cultural Heritage From India |  Corruption |  Insectivorous Plants |  Causes of Revolt of 1857 in Points |  Ordinance Making Power of President and Governors |  Mangroves Cover in India |  Coral Reefs in India |  Seasons and Climate in India |  Constitutional and Statutory Bodies in India |  Rock Edicts of Ashoka |  Types of Motions in Parliamentary Procedure |  Types of Majorities in Parliament |  Pressure Groups in World and India |  Order of Precedence |  Types of Rocks |  Treaties in Indian History |  Types of Rocks |  Features of Indian Economy |  Geographical Indications |  Ancient History Terminology and Meanings |  Schedules of the Constitution |  Nuclear Power Plants in India List  |  Types of Clouds for SSC CGL | Nuclear Power Plants in India ListTypes of Ocean CurrentsStructure: Layers of EarthAPPSC Group 1 Answer KeySSC JE 2017 QUESTION PAPEROne Word Substitution for SSC and Bank ExamsMPSC Answer Key 2017 2017Layers of AtmosphereMPSC Answer Key 2017 2017BPSC Solved Question Paper 2017MPPSC Solved Question Paper 2017GST Bill IndiaDelhi SultanateLaw Commission of IndiaOscar Awards Winner 2017 ListDiseases in CropsCommon Drugs and UsesDifferent Types of Deserts in WorldUPSC Civil Services Exam-2016 Answer KeyUPSC CAPF Exam-2016 Answer Key | UPPSC UPPER Subordinate Exam-2016 Answer Key | Regulatory BodiesNational Parks in India | International Airports in India  | United Nation International Years National Highways | National Birds of Countries | 
Types of Speciation |  Unisexual and Bisexual Flowers |  DISANET |  National Child Labour Project Scheme |  Tropical Deciduous Forest |  Hoolock Gibbon: National Parks |  Sectors of Indian Economy |  How Legislative Council is Formed |  Insectivorous Plants |  Causes of Revolt of 1857 in Points |  Ordinance Making Power of President and Governors |  Mangroves Cover in India |  Coral Reefs in India |  Seasons and Climate in India |  Constitutional and Statutory Bodies in India |  Rock Edicts of Ashoka |  Types of Motions in Parliamentary Procedure |  Types of Majorities in Parliament |  Pressure Groups in World and India |  Order of Precedence |  Types of Rocks |  Treaties in Indian History |  Types of Rocks |  Features of Indian Economy |  Geographical Indications |  Ancient History Terminology and Meanings |  Schedules of the Constitution |  Nuclear Power Plants in India List  |  Types of Clouds for SSC CGL | Nuclear Power Plants in India ListTypes of Ocean CurrentsStructure: Layers of EarthAPPSC Group 1 Answer KeySSC JE 2017 QUESTION PAPEROne Word Substitution for SSC and Bank ExamsMPSC Answer Key 2017 2017Layers of AtmosphereMPSC Answer Key 2017 2017BPSC Solved Question Paper 2017MPPSC Solved Question Paper 2017GST Bill IndiaDelhi SultanateLaw Commission of IndiaOscar Awards Winner 2017 ListDiseases in CropsCommon Drugs and UsesDifferent Types of Deserts in WorldUPSC Civil Services Exam-2016 Answer KeyUPSC CAPF Exam-2016 Answer Key | UPPSC UPPER Subordinate Exam-2016 Answer Key | Regulatory BodiesNational Parks in India |
Animals and their Baby Names |  Veto Power of President & Types of Veto |  Ordinance Making Power of President and Governors |  Mangroves Cover in India |  Coral Reefs in India |  Seasons and Climate in India |  Constitutional and Statutory Bodies in India |  Rock Edicts of Ashoka |  Types of Motions in Parliamentary Procedure |  Types of Majorities in Parliament |  Pressure Groups in World and India |  Order of Precedence |  Types of Rocks |  Treaties in Indian History |  Types of Rocks |  Features of Indian Economy |  Geographical Indications |  Ancient History Terminology and Meanings |  Schedules of the Constitution |  Nuclear Power Plants in India List  |  Types of Clouds for SSC CGL | Nuclear Power Plants in India ListTypes of Ocean CurrentsStructure: Layers of EarthAPPSC Group 1 Answer KeySSC JE 2017 QUESTION PAPEROne Word Substitution for SSC and Bank ExamsMPSC Answer Key 2017 2017Layers of AtmosphereMPSC Answer Key 2017 2017BPSC Solved Question Paper 2017MPPSC Solved Question Paper 2017GST Bill IndiaDelhi SultanateLaw Commission of IndiaOscar Awards Winner 2017 ListDiseases in CropsCommon Drugs and UsesDifferent Types of Deserts in World

Monday, 10 December 2018

Which of the following is not characteristic of a relational database model?

  By GK Planet Team       Monday, 10 December 2018
Q. Which of the following is not characteristic of a relational database model?
  1. tables
  2. treelike structure
  3. complex logical relationships
  4. records
  5. None of the above
Answer: treelike structure

A relational database is a digital database based on the relational model of data, as proposed by E. F. Codd in 1970. A software system used to maintain relational databases is a relational database management system (RDBMS). Virtually all relational database systems use SQL (Structured Query Language) for querying and maintaining the database.

Below are some of the characteristics of relational databases and the relational model.

  • The use of keys
Each row of data in a table is identified by a unique "key", called the primary key
  • Avoiding data redundancy
  • Constraining the input
Using a relational database you can specify what sort of data a database column is allowed to contain. You can create fields that contain numbers, decimal numbers, small texts, large texts, dates, etc.
  • Maintaining data integrity
  • Rights
Most relational database systems offer a rights structure with which rights can be assigned to different users. Some of the operations that can be allowed or disallowed to a user are SELECT, INSERT, DELETE, ALTER, CREATE, etc. These rights correspond to the operations that can be performed using the Structured Query Language (SQL).
  • Structured Query Language (SQL)
  • Portability
The relational model is a standard. By adhering to the rules of the relational model you ensure that your data can be transferred between relational database systems relatively easily.
Q. Which of the following is a characteristic of a relational database system?
  1. All data within the system are shared by all users to facilitate integration.
  2. Database processing follows explicit links that are contained within the records.
  3. User views limit access to the database.
  4. Transaction processing and data warehousing systems share a common database
Answer: Database processing follows explicit links that are contained within the records.

The database should follow the links which are having the information in the form of records. Through records the data can be shared to users in the relational database systems.
logoblog

Thanks for reading Which of the following is not characteristic of a relational database model?

←Previous
« Prev Post
Next→
Next Post »

No comments:

Post a Comment

What you have to say about this?

Recent Posts ⌚

Video Lectures