The normal form that is not necessarily dependency preserving is
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
DBMS helps achieve
______is a preferred method for enforcing data integrity
The language that requires a user to specify the data to be retrieved without specifying exactly how…
Which of the following is true for network structure?
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
The one guideline to be followed while designing the database is
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
In a relational schema, each tuple is divided into fields called
In E-R Diagram total participation is represented by
____ table store information about database or about the system.
Which of the following addressing modes permits relocation without any change over in the code?
The keyword to eliminate duplicate rows from the query result in SQL is
Which of the following relational algebraic operations is not from set theory?
In SQL, testing whether a subquery is empty is done using
Which one is true statement :
The graphical representation of a query is .
______contains information that defines valid values that are stored in a column or data type.
The rule that a value of a foreign key must appear as a value of some specific table is called a
Data items grouped together for storage purposes are called a
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
Which of the following is not a property of transactions?
Which of the following is not a consequence of concurrent operations?
Relations produced from an E-R model will always be
_____clause is an additional filter that is applied to the result.
The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
When an E-R diagram is mapped to tables, the representation is redundant for
The data models defined by ANSI/SPARC architecture are
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter