Home

A transaction is in state after the final statement has been executed.

A. partially committed

B. active

C. committed

D. none of the above

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

You can do it
  1. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  2. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  3. The metadata is created by the
  4. In SQL, testing whether a subquery is empty is done using
  5. In SQL the word natural can be used with
  6. operator is used to compare a value to a list of literals values that have been specified.
  7. Which of the following is not a consequence of non-normalized database?
  8. In a relational schema, each tuple is divided into fields called
  9. A top-to-bottom relationship among the items in a database is established by a
  10. Relational Algebra does not have
  11. Which of the following ensures the atomicity of the transaction?
  12. Which one is true statement :
  13. The common column is eliminated in
  14. The _____ category includes storage media that can be operated on directly by the computers central…
  15. Shadow paging has
  16. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  17. DFD stands for
  18. In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
  19. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  20. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  21. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  22. In multiple granularity of locks SIX lock is compatible with
  23. ______is a preferred method for enforcing data integrity
  24. ____specifies a search condition for a group or an aggregate.
  25. In 2NF
  26. In an ER model,_____ is described in the database by storing its data.
  27. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
  28. Data independence means
  29. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  30. Change Staff table by removing default of Assistant for position column