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 |
What you know in mapping of erd to dfd?
What are foreign keys in database?
What is buffer manager?
What is domain in dbms?
IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?
Can we save file in database?
What is a distributed database system?
what is s/w lifecycle?
What is rank in database?
Explain the term specialization.
What are the parts of a table?
What is a checkpoint in dbms and when does it occur?
Oracle (3253)
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)