What is the difference between cross join and Full outer
join?
Answer / soma shaw
A cross join is a Cartesian join. for sets of A and B rows, you'll get a result of A * B rows. A full join will match all possible rows, meaning it will return AT MOST A + B rows.
| Is This Answer Correct ? | 18 Yes | 0 No |
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is a trace frag? Where do we use it?
What do you understand by a view?
How to find tables without indexes?
How do I view a procedure in sql server?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Explain important index characteristics?
Tell me what is the order in which the sql query is executed?
difference between function and procedure
3 Answers Cognizant, HCL, TCS, Theorem,
Why do we use stored procedures in sql server?
How to create a ddl trigger using "create trigger" statements?
How to execute a sql statement using odbc_exec()?
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)