Home

DBMS is a collection of _____ that enables user to create and maintain a database.

A. Keys

B. Program

C. Translators

D. Language Activity

You can do it
  1. Manager salary details are hidden from the employee .This is
  2. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  3. A data type or format is specified for each _________
  4. A _____ is used to define overall design of the database
  5. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  6. For correct behaviour during recovery, undo and redo operation must be
  7. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  8. Data items grouped together for storage purposes are called a
  9. A top-to-bottom relationship among the items in a database is established by a
  10. When an E-R diagram is mapped to tables, the representation is redundant for
  11. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  12. _____ database is used to provide statistical information or summaries of values based on various criteria.
  13. ______ keyword is used to find the number of values in a column.
  14. Which of the following is a reason to model data?
  15. The statement that is executed automatically by the system as a side effect of the modification of the…
  16. The clause alter table in SQL can be used to
  17. Which of the following is not comparison operator?
  18. approach reduces time and effort required for design and lesser risk in database management.
  19. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  20. A logical schema
  21. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  22. Data independence means
  23. In E-R Diagram total participation is represented by
  24. Change Staff table by removing default of Assistant for position column
  25. E-R Modeling is achieved by using ____ diagrams
  26. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  27. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  28. Cascading rollback is avoided in all protocol except
  29. In SQL, testing whether a subquery is empty is done using
  30. SQL server stores index information in the _____system table