What is equi-join?
Answer / aryasen vaikom
An equijoin is a join with a join condition containing an
equality operator ( = ). An equijoin combines rows that have
equivalent values for the specified columns.
Eg: select * from emp,dept where emp.deptno=dept.deptno;
| Is This Answer Correct ? | 9 Yes | 1 No |
Define a relation schema and a relation.
What are the advantages of database?
why an information gap exists in most organizations.
What is big data database?
What is service based database?
Explain data independence?
How to prevent concurrent access to my data?
What is the use of drop command and what are the differences between drop, truncate and delete commands?
Where is the database stored?
Why is databases important in healthcare?
What is e-r model in the dbms?
Define truncate and delete commands?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)