A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.
Sub
Parent
Candidate
Super
Also checkout these categories
Phylum - Annelida MCQ Current Affairs June 2017 MCQ Time and Work MCQ Clause Analysis MCQ Inequalities MCQ Botany MCQ Alkyl and Aryl Halides MCQ Phylum - Echinodermata MCQ Compounds with Functional Groups Containing MCQ Angiosperms (Inflorescence, Flower and Fruit) MCQ Numbers MCQ Clock MCQ
- Wait-for graph is used for
- The collection of information stored in a database at a particular moment is called as ......
- operator is used to compare a value to a list of literals values that have been specified.
- In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
- The set of all values that can be taken by the attribute is called as _______ of the attribute.
- The values of the attribute describes a particular
- The _______ is a set of programs to use and / or modify this data.
- The one guideline to be followed while designing the database is
- Grant and revoke are _____ statements.
- The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
- The fact that all employees of a particular organization should not have salaries more than $10000 is…
- Shadow paging has
- _____ command can be used to modify a column in a table
- ______ keyword is used to find the number of values in a column.
- Which of the following relational algebraic operations is not from set theory?
- Immediate database modification technique uses
- In SQL, testing whether a subquery is empty is done using
- The language that requires a user to specify the data to be retrieved without specifying exactly how…
- Which two files are used during operation of the DBMS?
- What is a disjoint less constraint?
- Precedence graphs help to find a
- Key to represent relationship between tables is called
- Tree structures are used to store data in
- The clause alter table in SQL can be used to
- ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
- What are the desirable properties of a decomposition
- Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
- _____clause is an additional filter that is applied to the result.
- Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
- ____ table store information about database or about the system.