Home

Which of the following relational algebraic operations is not from set theory?

A. Union

B. Intersection

C. Cartesian Product

D. Select

You can do it
  1. The graphical representation of a query is .
  2. A _____ is a logical unit of database processing that includes one or more data access operations that…
  3. The data models defined by ANSI/SPARC architecture are
  4. DBMS is a collection of _____ that enables user to create and maintain a database.
  5. In SQL the statement select * from R, S is equivalent to
  6. The rule that a value of a foreign key must appear as a value of some specific table is called a
  7. Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
  8. Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
  9. In multiple granularity of locks SIX lock is compatible with
  10. Tree structures are used to store data in
  11. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  12. A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
  13. Grant and revoke are _____ statements.
  14. Which of the following relational algebra operations do not require the participating tables to be union-compatible?
  15. Which of the following statement on the view concept in SQL is invalid?
  16. The drawback of shadow paging technique are
  17. operator is used to compare a value to a list of literals values that have been specified.
  18. Relationships among relationships can be represented in an-E-R model using
  19. An advantage of views is
  20. Relations produced from an E-R model will always be
  21. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  22. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  23. In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
  24. ____specifies a search condition for a group or an aggregate.
  25. _______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
  26. If a transaction T has obtained an exclusive lock on item Q, then T can
  27. ____ table store information about database or about the system.
  28. Which normal form is considered adequate for normal relational database design?
  29. The keyword to eliminate duplicate rows from the query result in SQL is
  30. _____is a full form of SQL.