To eliminate duplicate rows ……………… is used A) NODUPLICATE B) ELIMINATE C) DISTINCT D) None of these To eliminate duplicate rows ……………… is used A) NODUPLICATE B) ELIMINATE C) DISTINCT D) None of these

To eliminate duplicate rows ……………… is used
A) NODUPLICATE
B) ELIMINATE
C) DISTINCT
D) None of these
by

1 Answer

Answer :

C) DISTINCT
by

Related questions

…………….. is used to determine whether of a table contains duplicate rows. A) Unique predicate B) Like Predicate C) Null predicate D) In predicate

Description : …………….. is used to determine whether of a table contains duplicate rows. A) Unique predicate B) Like Predicate C) Null predicate D) In predicate

Last Answer : A) Unique predicate

Is there a free feature for removing duplicate columns/rows in Microsoft Excel?

Description : Is there a free feature for removing duplicate columns/rows in Microsoft Excel?

Last Answer : answer:you can do this without adding software. http://support.microsoft.com/kb/262277 I think this should work with all versions of Excel. if you're using a mac, the menus might be a little different, but ... tricky if you need to get rid of duplicate data in a specific column, but it can be done.

How to remove duplicate rows of a Numpy array -Web-Development

Description : How to remove duplicate rows of a Numpy array -Web-Development

Last Answer : answer:

How to find and remove duplicate rows from pandas dataframe -Web-Development

Description : How to find and remove duplicate rows from pandas dataframe -Web-Development

Last Answer : answer:

Deleting the Duplicate rows in the table

Description : Deleting the Duplicate rows in the table

Last Answer : We can delete the duplicate rows in the table by using the Rowid

Find (and eliminate) duplicate files, folders, and photos?

Description : Find (and eliminate) duplicate files, folders, and photos?

Last Answer : Just do a find folders. If you have windows just click on the start tab and go to ‘search.’ Plug in the file name and all of the files with that name will come up.

In a relational database model, NULL values can be used for all but which one of the following? (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL. (B) To avoid confusion with actual legitimate data values like 0 (zero) for integer columns and ‘’ (the empty string) for string columns. (C) To leave columns in a tuple marked as “unknown” when the actual value is unknown. (D) To fill a column in a tuple when that column does not really “exist” for that particular tuple.

Description : In a relational database model, NULL values can be used for all but which one of the following? (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL. (B) To ... D) To fill a column in a tuple when that column does not really exist for that particular tuple.

Last Answer : (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL.

The number of distinct binary images which can be generated from a given binary image of right M × N are (A) M + N (B) M × N (C) 2M + N (D) 2MN

Description : The number of distinct binary images which can be generated from a given binary image of right M × N are (A) M + N (B) M × N (C) 2M + N (D) 2MN

Last Answer : (D) 2MN

Consider the table Student(stuid, name, course, marks). Which one of the following two queries is correct to find the highest marks student in course 5? Q.1. Select S.stuid From student S Where not exists (select * from student e where e course='5' and e marks ≥ s marks) Q.2. Select S.stuid From student S Where s.marks > any (select distinct marks from student S where s.couse = 5) (A) Q.1 (B) Q.2 (C) Both Q.1 and Q.2 (D) Neither Q.1 nor Q.2

Description : Consider the table Student(stuid, name, course, marks). Which one of the following two queries is correct to find the highest marks student in course 5? Q.1. Select S.stuid From student S Where not exists (select * from student ... ) Q.1 (B) Q.2 (C) Both Q.1 and Q.2 (D) Neither Q.1 nor Q.2

Last Answer : (B) Q.2 Explanation: First query gives stuid of students whose marks are greater than all students taking course 5. Second query gives stuid of students whose marks are greater than any student taking ... comparison is between maximum of marks by any student in course 5. So the answer is option D.

How many distinct stages are there in DES algorithm, which is parameterized by a 56-bit key ? (A) 16 (B) 17 (C) 18 (D) 19

Description : How many distinct stages are there in DES algorithm, which is parameterized by a 56-bit key ? (A) 16 (B) 17 (C) 18 (D) 19

Last Answer : (D) 19

The ............ operator preserves unmatched rows of the relations being joined. A) Inner join B) Outer join C) Union D) Union join

Description : The ............ operator preserves unmatched rows of the relations being joined. A) Inner join B) Outer join C) Union D) Union join

Last Answer : B) Outer join

Which can be used to delete all the rows if a table? A) Delete * from table_name B) Delete from table_name C) Delete table_name D) all rows cannot be deleted at a time.

Description : Which can be used to delete all the rows if a table? A) Delete * from table_name B) Delete from table_name C) Delete table_name D) all rows cannot be deleted at a time.

Last Answer : A) Delete * from table_name

An instance of a relation is a time varying set of …………………. A) Tuples B) Rows C) Both of them D) None of them

Description : An instance of a relation is a time varying set of …………………. A) Tuples B) Rows C) Both of them D) None of them

Last Answer : C) Both of them

The number of tuples in a relation is called its …………. While the number of attributes in a relation is called it’s ……………….. A) Degree, Cardinality B) Cardinality, Degree C) Rows, Columns

Description : The number of tuples in a relation is called its …………. While the number of attributes in a relation is called it’s ……………….. A) Degree, Cardinality B) Cardinality, Degree C) Rows, Columns

Last Answer : B) Cardinality, Degree

In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows.

Description : In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows.

Last Answer : (C) Tables

The “PROJECT” operator of a relational algebra creates a new table that has always (A) More columns than columns in original table (B) More rows than original table (C) Same number of rows as the original table (D) Same number of columns as the original table

Description : The “PROJECT” operator of a relational algebra creates a new table that has always (A) More columns than columns in original table (B) More rows than original table (C) Same number of rows as the original table (D) Same number of columns as the original table

Last Answer : (C) Same number of rows as the original table

In the Hungarian method for solving assignment problem, an optimal assignment requires that the maximum number of lines that can be drawn through squares with zero opportunity cost be equal to the number of: (A) rows or columns (B) rows+columns (C) rows+columns-1 (D) rows+columns+1

Description : In the Hungarian method for solving assignment problem, an optimal assignment requires that the maximum number of lines that can be drawn through squares with zero opportunity cost be equal to the number of: (A) rows or columns (B) rows+columns (C) rows+columns-1 (D) rows+columns+1

Last Answer : (A) rows or columns

Consider the following three SQL queries (Assume the data in the people table) : (a) Select Name from people where Age>21; (b) Select Name from people where Height>180; (c) Select Name from people where (Age>21) or (Height>180); If the SQL queries (a) and (b) above, return 10 rows and 7 rows in the result set respectively, then what is one possible number of rows returned by the SQL query (c) ? (A) 3 (B) 7 (C) 10 (D) 21

Description : Consider the following three SQL queries (Assume the data in the people table) : (a) Select Name from people where Age>21; (b) Select Name from people where Height>180; (c) Select Name from people where (Age>21) or (Height ... number of rows returned by the SQL query (c) ? (A) 3 (B) 7 (C) 10 (D) 21

Last Answer : (C) 10

Semi-join strategies are techniques for query processing in distributed database system. Which of the following is a semi-join technique? (A) Only the joining attributes are sent from one site to another and then all of the rows are returned. (B) All of the attributes are sent from one site to another and then only the required rows are returned. (C) Only the joining attributes are sent from one site to another and then only the required rows are returned. (D) All of the attributes are sent from one site to another and then only the required rows are returned.

Description : Semi-join strategies are techniques for query processing in distributed database system. Which of the following is a semi-join technique? (A) Only the joining attributes are sent from one site to ... the attributes are sent from one site to another and then only the required rows are returned.

Last Answer : (C) Only the joining attributes are sent from one site to another and then only the required rows are returned.

Quora refugees. Quora has driven me away. How best can I duplicate the Quora experience for serious topics? I can do without questions about how tall teenagers will be.

Description : Quora refugees. Quora has driven me away. How best can I duplicate the Quora experience for serious topics? I can do without questions about how tall teenagers will be.

Last Answer : Welcome to Fluther. We’re a small group. I think you could start by asking questions. We have a very different interface here. It’s old, and it won’t be updated. We’re a good bunch with some quirks. Dive in! Enjoy the water.

Have you had any duplicate service providers?

Description : Have you had any duplicate service providers?

Last Answer : There aren’t “two worlds” when it comes to ISPs. There is only a difference in connection speeds, but content is not partitioned. Most places there is only one cable choice, not competing cable feeds. And if there is, the best content is available on either.

Have you asked a duplicate question by accident?

Description : Have you asked a duplicate question by accident?

Last Answer : I think I have. Like you said. Time goes by and you just forget…

How to find and delete duplicate files on a PC running Windows 7?

Description : How to find and delete duplicate files on a PC running Windows 7?

Last Answer : answer:Go to www.filehippo.com All free software. Type ‘duplicate’ in the search box. You will see several free programs. Read the description, download.

What is the quickest way to get rid of duplicate music files on my hard drive?

Description : What is the quickest way to get rid of duplicate music files on my hard drive?

Last Answer : If you put them all into itunes then it has a remove duplicates option, there is also plenty of software available just by googling “remove duplicate music files”, it’s up to you to find one you like though, some only let you remove so many for free, others do all.

How do I make a duplicate of Mac Mt. Lion before I install it?

Description : How do I make a duplicate of Mac Mt. Lion before I install it?

Last Answer : answer:I'm a bit foggy on why you want to do what you want to do. It seems a bit unnecessary. In the event that things go tits-up you will not be able to install from what the app store put in your ... you can do the microphone thing in iChat I can help you out. I will send you my username in a PM.

Duplicate question #1 gazillion: Who is currently your favorite author?

Description : Duplicate question #1 gazillion: Who is currently your favorite author?

Last Answer : Herman Hesse

My client's seeing something I can't duplicate, Can you check this Web site for me?

Description : My client's seeing something I can't duplicate, Can you check this Web site for me?

Last Answer : Both links worked the way there were supposed to for me. I’m using: Safari 5.0.6 Mac OS X 10.5.8

How do I stop my computer from making duplicate copies of files?

Description : How do I stop my computer from making duplicate copies of files?

Last Answer : Update your virus checker, then disconnect from the Internet and run a full scan.

Getting rid of duplicate tracks in your music library?

Description : Getting rid of duplicate tracks in your music library?

Last Answer : If you are using I Tunes, than likely no. Sorry.

Can/How do I duplicate a Typepad blog?

Description : Can/How do I duplicate a Typepad blog?

Last Answer : Here’s a link from the Typepad Knowledge Base. Blog Settings: Import/Export Hope that helps

Can anyone recommend a PC program that will look for duplicate files on a set of hard drives?

Description : Can anyone recommend a PC program that will look for duplicate files on a set of hard drives?

Last Answer : DeleteDuplicateFiles ….this freeware should do the trick !

Is there a way to have iCal automatically duplicate my entry for one calander into my google calander?

Description : Is there a way to have iCal automatically duplicate my entry for one calander into my google calander?

Last Answer : Yes! Download Calaboration, a Google utility. It will guide you through the setup process. It’s very easy.

Duplicate files?

Description : Duplicate files?

Last Answer : Hmmm not sure how to re-enable that old dialog. But you can have iTunes show you a listing of duplicate tracks. 1. Select the Music library. 2. File > Show duplicates. 3. Sort by name (if ... time waiting for the import of dupe tracks but it should be simpler/easier than what you're doing now.

Will ask-public forgive those of us who have posted duplicate responses?

Description : Will ask-public forgive those of us who have posted duplicate responses?

Last Answer : I have been going back and editing th first one with a “sorry”

Why does my taskbar notification area (Vista) sometimes show things in duplicate?

Description : Why does my taskbar notification area (Vista) sometimes show things in duplicate?

Last Answer : because Vista is lame

Is asking a duplicate question acceptable in some cases?

Description : Is asking a duplicate question acceptable in some cases?

Last Answer : Of course NOT. How can you even suggest such a thing? ask-public would NEVER allow that type of inapprorpriate behavior. I mean, apparently my question about The Obama Budget was too similar to my question about Too Much Regulation that ask-public had to remove it.

Why does iTunes create duplicate files when I drag and drop MP3's?

Description : Why does iTunes create duplicate files when I drag and drop MP3's?

Last Answer : Does this happen when you drag a song from your library into a new playlist or when you drag a song from outside iTunes and drop it in? If you have Copy files to iTunes music folder when ... the problem by dragging a song from my library into a new playlist with the current version of iTunes.

How to duplicate a blog including all articles and layouts in iWeb?

Description : How to duplicate a blog including all articles and layouts in iWeb?

Last Answer : Not sure what platform the first blog is, but I am sure you can duplicate the database or export everything as XML and parse those into your new blog…

Why on earth did the judge in florida let that 20 year old out after making threats to duplicate the virgina tech incident out?

Description : Why on earth did the judge in florida let that 20 year old out after making threats to duplicate the virgina tech incident out?

Last Answer : Do you have any links to this story? I missed it and am in disbelief of how this could even happen.

Why do divers hop right into the shower immediately after they dive (this question is a duplicate)?

Description : Why do divers hop right into the shower immediately after they dive (this question is a duplicate)?

Last Answer : Oh man. I should have searched first. Ug. I hate myself.

How can I duplicate a layer style in Illustrator CS3, like I can in Photoshop CS3?

Description : How can I duplicate a layer style in Illustrator CS3, like I can in Photoshop CS3?

Last Answer : Don’t you just select the layer you want to put the style on and use the dropper tool on the layer you have that you want to copy? Or am I missing something?

Charentais Melons-wish duplicate soil in S. France, where they're Famous.

Description : Charentais Melons-wish duplicate soil in S. France, where they're Famous.

Last Answer : Need Answer

How do duplicate articles and adulteration cause heavy loss to the consumers? -SST 10th

Description : How do duplicate articles and adulteration cause heavy loss to the consumers? -SST 10th

Last Answer : Duplicate articles and adulteration cause heavy loss to the consumers in the following ways : (i) Duplicate articles such as duplicate medicines may cause life risks for the consumers. (ii) Duplicate articles and adulterated goods cause financial loss to the consumers and leave them unsatisfied.

same as... duplicate results will sometimes be pre-identified for you. -General Knowledge

Description : same as... duplicate results will sometimes be pre-identified for you. -General Knowledge

Last Answer : Same as... duplicate results will sometimes be pre-identified for you. True.

Primary key field gives us permission to record duplicate entry. -Technology

Description : Primary key field gives us permission to record duplicate entry. -Technology

Last Answer : False A primary key is a key which identifies records uniquely in a table so it does not give us permission to record duplicate entry.

What is the opposite of duplicate ?

Description : What is the opposite of duplicate ?

Last Answer : Duplicate of the opposite সদ