Home

Which of the following is not a recovery technique?

A. Deferred update

B. Immediate update

C. Two-phase commit

D. Shadow paging

You can do it
  1. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  2. SQL server stores index information in the _____system table
  3. A relational database developer refers to a record as
  4. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  5. In an E-R diagram double lines indicate
  6. A data type or format is specified for each _________
  7. The one guideline to be followed while designing the database is
  8. Which of the following is true for network structure?
  9. According to the levels of abstraction, the schema at the intermediate level is called
  10. In a relational schema, each tuple is divided into fields called
  11. The transactions like adding an employee, enrolling a student in a course are examples of _______
  12. A table can have only one
  13. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  14. DBMS helps achieve
  15. ______is a preferred method for enforcing data integrity
  16. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  17. Grant and revoke are _____ statements.
  18. In SQL the word natural can be used with
  19. The common column is eliminated in
  20. The drawback of shadow paging technique are
  21. If the closure of an attribute set is the entire relation then the attribute set is a
  22. The part of a database management system which ensures that the data remains in a consistent state is
  23. The _______ is a set of programs to use and / or modify this data.
  24. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  25. What is data integrity?
  26. _____is a full form of SQL.
  27. Wait-for graph is used for
  28. _____ First proposed the process of normalization.
  29. _______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
  30. Which normal form is considered adequate for normal relational database design?