Which of the following is not a characteristic of a relational database model?
Tree like structure
Complex logical relationship
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
Maximum height of a B+ tree of order m with n key values is
For using a specific database command is used.
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
Relational Algebra does not have
In multiple granularity of locks SIX lock is compatible with
The statement that is executed automatically by the system as a side effect of the modification of the…
Precedence graphs help to find a
Wait-for graph is used for
The normal form that is not necessarily dependency preserving is
DBMS helps achieve
The language that requires a user to specify the data to be retrieved without specifying exactly how…
Which of the following concurrency control schemes is not based on the serializability property?
In a relational schema, each tuple is divided into fields called
It is an abstraction through which relationships are treated as higher level entities
Union operator is a :
Which of the following relational algebraic operations is not from set theory?
The size of a data item is called its _______, which can be a field of some record or may be a larger…
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
Tree structures are used to store data in
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
Data items grouped together for storage purposes are called a
In SQL the word natural can be used with
What are the desirable properties of a decomposition
If the closure of an attribute set is the entire relation then the attribute set is a
A _____ is a logical unit of database processing that includes one or more data access operations that…
DROP is a statement in SQL.
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
_____ First proposed the process of normalization.
Which of the following is a reason to model data?
An advantage of views is
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter