If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
left outer join
right outer join
full outer join
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
A logical schema
By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
Maximum height of a B+ tree of order m with n key values is
A ______ module is typically designed so that it will run on a user workstation or personal computer.
A _____ is a logical unit of database processing that includes one or more data access operations that…
A data type or format is specified for each _________
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
Relational Algebra does not have
The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
A top-to-bottom relationship among the items in a database is established by a
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
Which of the following is a reason to model data?
For correct behaviour during recovery, undo and redo operation must be
_____ First proposed the process of normalization.
Cascading rollback is avoided in all protocol except
DROP is a statement in SQL.
Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
____ table store information about database or about the system.
In an ER model,_____ is described in the database by storing its data.
The language that requires a user to specify the data to be retrieved without specifying exactly how…
HSAM stands for .
In E-R Diagram total participation is represented by
Which of the following is not a consequence of non-normalized database?
Which of the following is not comparison operator?
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
Tree structures are used to store data in
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
The metadata is created by the
SQL server stores index information in the _____system table
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter