Data items grouped together for storage purposes are called a
record
string
title
list
- A _____ is used to define overall design of the database
- Which of the following is not a recovery technique?
- In b-tree the number of keys in each node is than the number of its children.
- Which of the following ensures the atomicity of the transaction?
- The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
- A transaction is in state after the final statement has been executed.
- The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
- The fact that all employees of a particular organization should not have salaries more than $10000 is…
- A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
- In an ER model,_____ is described in the database by storing its data.
- What is a disjoint less constraint?
- Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
- ______contains information that defines valid values that are stored in a column or data type.
- As per equivalence rules for query transformation, selection operation distributes over
- The graphical representation of a query is .
- operator is used to compare a value to a list of literals values that have been specified.
- According to the levels of abstraction, the schema at the intermediate level is called
- A top-to-bottom relationship among the items in a database is established by a
- Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
- What are the desirable properties of a decomposition
- DBMS is a collection of _____ that enables user to create and maintain a database.
- Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
- If a transaction T has obtained an exclusive lock on item Q, then T can
- The part of a database management system which ensures that the data remains in a consistent state is
- _____ database is used to provide statistical information or summaries of values based on various criteria.
- The data in the database at a particular moment of time is called the _______
- Drop Table cannot be used to drop a table referenced by a ______ constraint.
- Union operator is a :
- Relationships among relationships can be represented in an-E-R model using
- A table can have only one