Data items grouped together for storage purposes are called a
record
string
title
list
- The default level of consistency in SQL is
- In b-tree the number of keys in each node is than the number of its children.
- Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
- The data in the database at a particular moment of time is called the _______
- What are the desirable properties of a decomposition
- Relationships among relationships can be represented in an-E-R model using
- The middleware databases in which the business rules act are applicable to _______ tier architectures
- A transaction is in state after the final statement has been executed.
- Which of the following relational algebra operations do not require the participating tables to be union-compatible?
- The set of all values that can be taken by the attribute is called as _______ of the attribute.
- Which of the following is true for network structure?
- In an ER model,_____ is described in the database by storing its data.
- When an E-R diagram is mapped to tables, the representation is redundant for
- The relational model is based on the concept that data is organized and stored in two-dimensional tables…
- A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
- If the closure of an attribute set is the entire relation then the attribute set is a
- Which of the following relational algebraic operations is not from set theory?
- Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
- The collection of information stored in a database at a particular moment is called as ......
- ______is a preferred method for enforcing data integrity
- A logical schema
- Wait-for graph is used for
- The statement that is executed automatically by the system as a side effect of the modification of the…
- Precedence graphs help to find a
- The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
- A table can have only one
- DFD stands for
- The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
- _____ database is used to provide statistical information or summaries of values based on various criteria.
- Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…