If both the functional dependencies : Xï®Y and Yï®X hold for two attributes X and Y then the relationship between X and Y is
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of DBMS MCQ
comments powered by Disqus.
The default level of consistency in SQL is
Which of the following constitutes a basic set of operations for manipulating relational data?
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
A table can have only one
In an E-R diagram double lines indicate
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
The clause alter table in SQL can be used to
Wait-for graph is used for
The collection of information stored in a database at a particular moment is called as ......
The fact that all employees of a particular organization should not have salaries more than $10000 is…
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
Cascading rollback is avoided in all protocol except
DROP is a statement in SQL.
DBMS is a collection of _____ that enables user to create and maintain a database.
An advantage of the database management approach is
_____ database is used to provide statistical information or summaries of values based on various criteria.
The data models defined by ANSI/SPARC architecture are
______ keyword is used to find the number of values in a column.
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…
Relational Algebra is
The data in the database at a particular moment of time is called the _______
The language that requires a user to specify the data to be retrieved without specifying exactly how…
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
If both the functional dependencies : Xï®Y and Yï®X hold for two attributes X and Y then the relationship…
Which of the following is not a logical database structure?
Which of the following is not a property of transactions?
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter