Register

UGC NET CSE | Junet 2015 | Part 2 | Question: 19

• edited by
4,678 views
1 votes
1 votes

Database application were directly built on top of file system to overcome the following drawbacks of using file-systems:

  1. Data redundancy and inconsistency
  2. Difficulty in accessing data
  3. Data isolation
  4. Integrity problems
  1. $\text{i}$
  2. $\text{i and iv}$
  3. $\text{i, ii, and iii}$
  4. $\text{i, ii, iii, and iv}$
• edited by
User Avatar

1 Answer

4 votes
4 votes
Ans is D

Traditional file system has all mentioned drawbacks . Database applications built by using tables are used to overcome them

e,g Normalization and integrity constraints reduces redundancy and inconsistency

     select * .... from Table provide easy access to data

    References , joins etc removes data isolation

   primary and foreign key along with check predicate solves integrity problems
User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

2 votes
2 votes
2 answers
2
go_editor asked Jul 30, 2016
15,630 views
UGC NET CSE | Junet 2015 | Part 2 | Question: 20
For a weak entity set to be meaningful, it must be associated with another entity set in combination with some of their attribute values, is called as: Neighbour Set Strong Entity Set Owner Entity Set Weak Set
For a weak entity set to be meaningful, it must be associated with another entity set in combination with some of their attribute values, is called as:Neighbour SetStrong...
User Avatar
1 votes
1 votes
1 answer
3
go_editor asked Jul 30, 2016
2,606 views
UGC NET CSE | Junet 2015 | Part 2 | Question: 18
Drop Table cannot be used to drop a Table referenced by _______ constraint Primary key Sub key Super key Foreign key a a, b and c d a and d
Drop Table cannot be used to drop a Table referenced by _______ constraintPrimary keySub keySuper keyForeign keyaa, b and cda and d
User Avatar
2 votes
2 votes
1 answer
4
go_editor asked Jul 30, 2016
3,002 views
UGC NET CSE | Junet 2015 | Part 2 | Question: 16
An Assertion is predicate expressing a condition we wish database to always satisfy. The correct syntax for Assertion is: CREATE ASSERTION 'ASSERTION Name' CHECK 'Predicate' CREATE ASSERTION 'ASSERTION Name' CREATE ASSERTION, CHECK 'Predicate' SELECT ASSERTION
An Assertion is predicate expressing a condition we wish database to always satisfy. The correct syntax for Assertion is:CREATE ASSERTION 'ASSERTION Name' CHECK 'Predicat...
User Avatar
Link Copied!