DROP is a statement in SQL.
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
In SQL, testing whether a subquery is empty is done using
______is a special type of integrity constraint that relates two relations & maintains consistency across…
Which of the following is not a logical database structure?
Relational Algebra is
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
The common column is eliminated in
Isolation of the transactions is ensured by
The default level of consistency in SQL is
If an entity can belong to only one lower level entity then the constraint is
Which of the following constitutes a basic set of operations for manipulating relational data?
Data independence means
In an E-R diagram double lines indicate
Which of the following is a reason to model data?
Precedence graphs help to find a
The graphical representation of a query is .
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
Key to represent relationship between tables is called
Which of the following addressing modes permits relocation without any change over in the code?
A list consists of last names, first names, addresses and pin codes. If all people in the list have…
Relationships among relationships can be represented in an-E-R model using
Checkpoints are a part of
A table can have only one
_____is a full form of SQL.
Which of the following relational algebra operations do not require the participating tables to be union-compatible?
Relational Algebra does not have
In SQL the word natural can be used with
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
In b-tree the number of keys in each node is than the number of its children.
Union operator is a :
The language that requires a user to specify the data to be retrieved without specifying exactly how…
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter