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

What is the correct answer?

4

The keyword to eliminate duplicate rows from the query result in SQL is

A. DISTINCT

B. NO DUPLICATE

C. UNIQUE

D. None of the above

Related Questions

The one guideline to be followed while designing the database is An advantage of the database management approach is Precedence graphs help to find a ______is a preferred method for enforcing data integrity Isolation of the transactions is ensured by Checkpoints are a part of Relational Algebra does not have In a multi-user database, if two users wish to update the same record… ______defines the structure of a relation which consists of a fixed set… As per equivalence rules for query transformation, selection operation… An outstanding functionality of SQL is its support for automatic_____… In E-R Diagram total participation is represented by Tree structures are used to store data in The concept of mapping of ______ entity types is the concept in which… The graphical representation of a query is . Assume transaction A holds a shared lock R. If transaction B also requests… The collection of information stored in a database at a particular moment… Which of the following statement on the view concept in SQL is invalid? A ______ module is typically designed so that it will run on a user workstation… The full form of GUI is _________ Which of the following is not a characteristic of a relational database… In an ER diagram the ___shape specifies the Attibute and a ____ shape… Protection of data from unauthorized Disclosure results in loss of _______ ______contains information that defines valid values that are stored in… An advantage of views is In an ER model,_____ is described in the database by storing its data. The data models defined by ANSI/SPARC architecture are What are the desirable properties of a decomposition Grant and revoke are _____ statements. The _______ is a set of programs to use and / or modify this data.