Home

A logical schema

A. is the entire database

B. Describes how data is actually stored on disk.

C. is a standard way of organizing information into accessible parts.

D. All of the above

You can do it
  1. Union operator is a :
  2. DBMS is a collection of _____ that enables user to create and maintain a database.
  3. The size of a data item is called its _______, which can be a field of some record or may be a larger…
  4. A _____ is a logical unit of database processing that includes one or more data access operations that…
  5. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  6. Which one is true statement :
  7. In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
  8. In multiple granularity of locks SIX lock is compatible with
  9. Which of the following is not a logical database structure?
  10. Which of the following relational algebraic operations is not from set theory?
  11. Which of the following is a reason to model data?
  12. An advantage of the database management approach is
  13. The data models defined by ANSI/SPARC architecture are
  14. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  15. The clause alter table in SQL can be used to
  16. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  17. SQL server stores index information in the _____system table
  18. Which of the following aggregate functions does not ignore nulls in its results?.
  19. For using a specific database …………… command is used.
  20. Which is the best file organization when data is frequently added or deleted from a file?
  21. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  22. Relational Algebra is
  23. Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
  24. Grant and revoke are _____ statements.
  25. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  26. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  27. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  28. ………………… approach reduces time and effort required for design…
  29. The full form of GUI is _________
  30. A top-to-bottom relationship among the items in a database is established by a