Home

Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation.

A. 1:1

B. 1: Many

C. Many: One

D. Many : Many

Correct Answer : A.


Download Objective type questions of DBMS PDF

Visit our PDF store

Get all objective type questions of DBMS MCQ

You can do it
  1. Which of the following is not a consequence of non-normalized database?
  2. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  3. As per equivalence rules for query transformation, selection operation distributes over
  4. The rule that a value of a foreign key must appear as a value of some specific table is called a
  5. A top-to-bottom relationship among the items in a database is established by a
  6. _____ command can be used to modify a column in a table
  7. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  8. Relationships among relationships can be represented in an-E-R model using
  9. Checkpoints are a part of
  10. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  11. The collection of information stored in a database at a particular moment is called as ......
  12. A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
  13. Which normal form is considered adequate for normal relational database design?
  14. In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
  15. The normalization was first proposed by .
  16. DFD stands for
  17. operator is used to compare a value to a list of literals values that have been specified.
  18. What are the desirable properties of a decomposition
  19. Which of the following is true for network structure?
  20. Relational Algebra is
  21. A _____ is a logical unit of database processing that includes one or more data access operations that…
  22. Which of the following is a reason to model data?
  23. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  24. In SQL the word natural can be used with
  25. The statement that is executed automatically by the system as a side effect of the modification of the…
  26. According to the levels of abstraction, the schema at the intermediate level is called
  27. The fact that all employees of a particular organization should not have salaries more than $10000 is…
  28. A logical schema
  29. If both the functional dependencies : Xï®Y and Yï®X hold for two attributes X and Y then the relationship…
  30. SQL server stores index information in the _____system table