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 |
Explain the different types of constraints in dbms?
What are the advantages of database software?
What is acid property in dbms?
What file is read by ODBC to load drivers ?
Mention the different languages present in dbms
Describe two phases of Two-phase commit ?
Explain the term generalization.
What do you understand by b-trees?
Which two can be implemented as a centrally located logical architecture?
Explain the difference between two and three-tier architectures.
What are the features of database language?
State some commands of ddl in dbms?
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)