Home

Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C

A. (i) and (ii)

B. (iv) only

C. (i) and (iv)

D. (ii) and (iii)

You can do it
  1. The clause alter table in SQL can be used to
  2. The metadata is created by the
  3. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
  4. Immediate database modification technique uses
  5. DFD stands for
  6. If an entity can belong to only one lower level entity then the constraint is
  7. DBMS helps achieve
  8. Isolation of the transactions is ensured by
  9. In E-R Diagram total participation is represented by
  10. The values of the attribute describes a particular
  11. As per equivalence rules for query transformation, selection operation distributes over
  12. In a relational schema, each tuple is divided into fields called
  13. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  14. The middleware databases in which the business rules act are applicable to _______ tier architectures
  15. An advantage of views is
  16. A data type or format is specified for each _________
  17. Which of the following is not a consequence of non-normalized database?
  18. An advantage of the database management approach is
  19. In b-tree the number of keys in each node is than the number of its children.
  20. Grant and revoke are _____ statements.
  21. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  22. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  23. The ______ indexes are forced to store only record IDs in the data structure and require at least one…
  24. In an E-R diagram double lines indicate
  25. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  26. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  27. _____ First proposed the process of normalization.
  28. The keyword to eliminate duplicate rows from the query result in SQL is
  29. A table can have only one
  30. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…