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.
1:1
1: Many
Many: One
Many : Many
- A top-to-bottom relationship among the items in a database is established by a
- Union operator is a :
- If both the functional dependencies : Xï®Y and Yï®X hold for two attributes X and Y then the relationship…
- The common column is eliminated in
- What are the desirable properties of a decomposition
- If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
- The default level of consistency in SQL is
- The normal form that is not necessarily dependency preserving is
- A ______ module is typically designed so that it will run on a user workstation or personal computer.
- Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
- _____is a full form of SQL.
- In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
- Which of the following concurrency control schemes is not based on the serializability property?
- _____ is a utility to capture a continuous record of server activity and provide auditing capability.
- A _____ is used to define overall design of the database
- SQL server stores index information in the _____system table
- Which of the following is not a characteristic of a relational database model?
- In SQL, testing whether a subquery is empty is done using
- The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
- The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
- In SQL the statement select * from R, S is equivalent to
- A list consists of last names, first names, addresses and pin codes. If all people in the list have…
- The data in the database at a particular moment of time is called the _______
- Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
- Which of the following is true for network structure?
- The graphical representation of a query is .
- Precedence graphs help to find a
- Isolation of the transactions is ensured by
- It is an abstraction through which relationships are treated as higher level entities
- Which normal form is considered adequate for normal relational database design?