Home

______is a preferred method for enforcing data integrity

A. Constraints

B. Triggers

C. Stored procedure

D. Cursors

Please do not use chat terms. Example: avoid using "grt" instead of "great".

You can do it
  1. In an ER model,_____ is described in the database by storing its data.
  2. The full form of GUI is _________
  3. Which of the following relational algebraic operations is not from set theory?
  4. operator is used to compare a value to a list of literals values that have been specified.
  5. Which of the following is not a consequence of non-normalized database?
  6. ______contains information that defines valid values that are stored in a column or data type.
  7. Union operator is a :
  8. Isolation of the transactions is ensured by
  9. ____ table store information about database or about the system.
  10. Checkpoints are a part of
  11. Which of the following is not a recovery technique?
  12. The part of a database management system which ensures that the data remains in a consistent state is
  13. The collection of information stored in a database at a particular moment is called as ......
  14. Which of the following is not a property of transactions?
  15. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  16. DBMS helps achieve
  17. For using a specific database …………… command is used.
  18. Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
  19. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  20. The _______ is a set of programs to use and / or modify this data.
  21. Data independence means
  22. The clause alter table in SQL can be used to
  23. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  24. A _____ is used to define overall design of the database
  25. Which of the following ensures the atomicity of the transaction?
  26. If the closure of an attribute set is the entire relation then the attribute set is a
  27. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
  28. The size of a data item is called its _______, which can be a field of some record or may be a larger…
  29. In SQL, testing whether a subquery is empty is done using
  30. Precedence graphs help to find a