DBMS helps achieve
Centralized control of data
Both A and B
Neither A nor B
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
Drop Table cannot be used to drop a table referenced by a ______ constraint.
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
Relations produced from an E-R model will always be
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
SQL server stores index information in the _____system table
Data items grouped together for storage purposes are called a
The ______ indexes are forced to store only record IDs in the data structure and require at least one…
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
_____clause is an additional filter that is applied to the result.
Relational Algebra does not have
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
The part of a database management system which ensures that the data remains in a consistent state is
What is data integrity?
The clause alter table in SQL can be used to
A ______ module is typically designed so that it will run on a user workstation or personal computer.
______contains information that defines valid values that are stored in a column or data type.
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
Which of the following is true for network structure?
Change Staff table by removing default of Assistant for position column
Which of the following constitutes a basic set of operations for manipulating relational data?
The one guideline to be followed while designing the database is
An advantage of the database management approach is
For correct behaviour during recovery, undo and redo operation must be
Tree structures are used to store data in
_____is a full form of SQL.
Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
If an entity can belong to only one lower level entity then the constraint is
The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter