Data items grouped together for storage purposes are called a
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
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)…
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter