Home

DBMS helps achieve

A. Centralized control of data

B. Data independence

C. Both A and B

D. Neither A nor B

You can do it
  1. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  2. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  3. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  4. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  5. Relations produced from an E-R model will always be
  6. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  7. SQL server stores index information in the _____system table
  8. Data items grouped together for storage purposes are called a
  9. The ______ indexes are forced to store only record IDs in the data structure and require at least one…
  10. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  11. _____clause is an additional filter that is applied to the result.
  12. Relational Algebra does not have
  13. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
  14. The part of a database management system which ensures that the data remains in a consistent state is
  15. What is data integrity?
  16. The clause alter table in SQL can be used to
  17. A ______ module is typically designed so that it will run on a user workstation or personal computer.
  18. ______contains information that defines valid values that are stored in a column or data type.
  19. A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
  20. Which of the following is true for network structure?
  21. Change Staff table by removing default of Assistant for position column
  22. Which of the following constitutes a basic set of operations for manipulating relational data?
  23. The one guideline to be followed while designing the database is
  24. An advantage of the database management approach is
  25. For correct behaviour during recovery, undo and redo operation must be
  26. Tree structures are used to store data in
  27. _____is a full form of SQL.
  28. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  29. If an entity can belong to only one lower level entity then the constraint is
  30. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…