Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are
m+n and 0
m+n and |m-n|
mn and 0
mn and m+n
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
Which of the following ensures the atomicity of the transaction?
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
In b-tree the number of keys in each node is than the number of its children.
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
A list consists of last names, first names, addresses and pin codes. If all people in the list have…
Which two files are used during operation of the DBMS?
The drawback of shadow paging technique are
____specifies a search condition for a group or an aggregate.
The collection of information stored in a database at a particular moment is called as ......
Relations produced from an E-R model will always be
_____clause is an additional filter that is applied to the result.
It is an abstraction through which relationships are treated as higher level entities
______ keyword is used to find the number of values in a column.
Tree structures are used to store data in
_____ First proposed the process of normalization.
Which of the following constitutes a basic set of operations for manipulating relational data?
In SQL the word natural can be used with
What is data integrity?
E-R Modeling is achieved by using ____ diagrams
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…
_____ database is used to provide statistical information or summaries of values based on various criteria.
Which normal form is considered adequate for normal relational database design?
In an E-R diagram double lines indicate
For correct behaviour during recovery, undo and redo operation must be
If the closure of an attribute set is the entire relation then the attribute set is a
In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
Change Staff table by removing default of Assistant for position column
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter