Home

What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows

A. 4,0

B. 0,0

C. 4,5

D. 8,5

You can do it
  1. DBMS is a collection of _____ that enables user to create and maintain a database.
  2. In an ER model,_____ is described in the database by storing its data.
  3. It is an abstraction through which relationships are treated as higher level entities
  4. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  5. The common column is eliminated in
  6. approach reduces time and effort required for design and lesser risk in database management.
  7. Protection of data from unauthorized Disclosure results in loss of _______
  8. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  9. A logical schema
  10. In 2NF
  11. Which one is correct statement?Logical data independence provides following without changing application…
  12. The cost of reading and writing temporary files while evaluating a query can be reduced by
  13. What is a disjoint less constraint?
  14. An outstanding functionality of SQL is its support for automatic_____ to the target data.
  15. Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
  16. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  17. The default level of consistency in SQL is
  18. SQL server stores index information in the _____system table
  19. Which of the following is not a consequence of concurrent operations?
  20. Which of the following constitutes a basic set of operations for manipulating relational data?
  21. As per equivalence rules for query transformation, selection operation distributes over
  22. A top-to-bottom relationship among the items in a database is established by a
  23. Relational Algebra does not have
  24. Change Staff table by removing default of Assistant for position column
  25. What are the desirable properties of a decomposition
  26. The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
  27. A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
  28. operator is used to compare a value to a list of literals values that have been specified.
  29. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  30. Relations produced from an E-R model will always be