In a relational schema, each tuple is divided into fields called
All of the above
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
A ______ module is typically designed so that it will run on a user workstation or personal computer.
For correct behaviour during recovery, undo and redo operation must be
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 SQL the word natural can be used with
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
In E-R Diagram total participation is represented by
HSAM stands for .
The language that requires a user to specify the data to be retrieved without specifying exactly how…
An advantage of the database management approach is
What are the desirable properties of a decomposition
DROP is a statement in SQL.
The middleware databases in which the business rules act are applicable to _______ tier architectures
The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
The rule that a value of a foreign key must appear as a value of some specific table is called a
When an E-R diagram is mapped to tables, the representation is redundant for
The normal form that is not necessarily dependency preserving is
The set of all values that can be taken by the attribute is called as _______ of the attribute.
If an entity can belong to only one lower level entity then the constraint is
A list consists of last names, first names, addresses and pin codes. If all people in the list have…
What is a disjoint less constraint?
DBMS helps achieve
Which of the following constitutes a basic set of operations for manipulating relational data?
Which of the following statement on the view concept in SQL is invalid?
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
In an ER model,_____ is described in the database by storing its data.
Relations produced from an E-R model will always be
Which of the following is not a recovery technique?
Which of the following ensures the atomicity of the transaction?
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter