4 years ago in Database Management System

what is the work of using joint operation in database??


Create your Digital Resume For FREE on your name's sub domain "yourname.wcard.io". Register Here!


Overall Stats

Attempted 0
Correct 0
Incorrect 0
Viewed 0

Answers

Guest
Guest
Prabhanjan Borkar - 4 years ago

You can join any common/Uncommon data from the database with the usage of 'join'. There are five types of joins : left,inner,full, right, self joins.

Prabhanjan Borkar - 4 years ago

A SQL join clause combines columns from one or more tables in a relational database. It creates a set that can be saved as a table or used as it is. A JOIN is a means for combining columns from one (self-table) or more tables by using values common to each.

Related Questions

The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?

  • [A] Overlapping rule
  • [B] Disjoint rule
  • [C] Total specialization rule
  • [D] Partial specialization rule

Which SQL-92 standard SQL command can be used to change a table name?

  • [A] RENAME TABLE
  • [B] CHANGE TABLE
  • [C] ALTER TABLE
  • [D] None of the above is correct.

Which of the following is a technique for hiding the internal implementation details of an object?

  • [A] Encapsulation
  • [B] Polymorphism
  • [C] Inheritance
  • [D] All of the above.

Related fields in a database are grouped to form ?

  • [A] Data Field
  • [B] Data Record
  • [C] Menu
  • [D] Bank