Earn $100 Online Daily. Work From Home. Click Here

What is the correct answer?


Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are

A. distinct values

B. cannot have NULL

C. both (A) & (B)

D. same as primary key

Related Questions

A top-to-bottom relationship among the items in a database is established… Grant and revoke are _____ statements. When an E-R diagram is mapped to tables, the representation is redundant… _____ command can be used to modify a column in a table It is an abstraction through which relationships are treated as higher… Protection of data from unauthorized Disclosure results in loss of _______ Key to represent relationship between tables is called Which is the best file organization when data is frequently added or deleted… If two relations R and S are joined, then the non matching tuples of both… ______defines the structure of a relation which consists of a fixed set… The keyword to eliminate duplicate rows from the query result in SQL is The rule that a value of a foreign key must appear as a value of some… The part of a database management system which ensures that the data remains… A _____ is used to define overall design of the database Which two files are used during operation of the DBMS? The ______ key of a relation is the attribute (column) or collection of… Which of the following ensures the atomicity of the transaction? In an ER model,_____ is described in the database by storing its data. Which of the following is a reason to model data? Assume transaction A holds a shared lock R. If transaction B also requests… The common column is eliminated in The data in the database at a particular moment of time is called the… Shadow paging has If a transaction T has obtained an exclusive lock on item Q, then T can The size of a data item is called its _______, which can be a field of… In b-tree the number of keys in each node is than the number of its children. In 2NF Manager salary details are hidden from the employee .This is The _______ is a set of programs to use and / or modify this data. In a relational schema, each tuple is divided into fields called