The data in the database at a particular moment of time is called the _______
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
Tree structures are used to store data in
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
A top-to-bottom relationship among the items in a database is established by a
The data models defined by ANSI/SPARC architecture are
The collection of information stored in a database at a particular moment is called as ......
Relational Algebra does not have
Which of the following ensures the atomicity of the transaction?
Relations produced from an E-R model will always be
SQL server stores index information in the _____system table
A data type or format is specified for each _________
_____ database is used to provide statistical information or summaries of values based on various criteria.
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
DBMS helps achieve
In SQL the word natural can be used with
Which of the following constitutes a basic set of operations for manipulating relational data?
Cascading rollback is avoided in all protocol except
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
A relational database developer refers to a record as
If an entity can belong to only one lower level entity then the constraint is
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
The values of the attribute describes a particular
As per equivalence rules for query transformation, selection operation distributes over
Dependency preservation is not guaranteed in
Immediate database modification technique uses
Isolation of the transactions is ensured by
Change Staff table by removing default of Assistant for position column
The default level of consistency in SQL is
_____ First proposed the process of normalization.