Home

According to the levels of abstraction, the schema at the intermediate level is called

A. Logical schema.

B. Physical schema.

C. Subschema.

D. None of the above.

You can do it
  1. ______ keyword is used to find the number of values in a column.
  2. Union operator is a :
  3. In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
  4. The normal form that is not necessarily dependency preserving is
  5. Which of the following ensures the atomicity of the transaction?
  6. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  7. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  8. Maximum height of a B+ tree of order m with n key values is
  9. According to the levels of abstraction, the schema at the intermediate level is called
  10. If the closure of an attribute set is the entire relation then the attribute set is a
  11. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  12. Which one is true statement :
  13. When an E-R diagram is mapped to tables, the representation is redundant for
  14. _____is a full form of SQL.
  15. Which of the following relational algebra operations do not require the participating tables to be union-compatible?
  16. _____clause is an additional filter that is applied to the result.
  17. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  18. Which of the following is not a recovery technique?
  19. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
  20. _______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
  21. Which of the following statement on the view concept in SQL is invalid?
  22. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  23. Which of the following constitutes a basic set of operations for manipulating relational data?
  24. The middleware databases in which the business rules act are applicable to _______ tier architectures
  25. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  26. As per equivalence rules for query transformation, selection operation distributes over
  27. Which of the following relational algebraic operations is not from set theory?
  28. In an E-R diagram double lines indicate
  29. The data models defined by ANSI/SPARC architecture are
  30. DFD stands for