Interested to Buy Any Domain ? << Click Here >> for more details...
IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF
SELECT * FROM EMP,DEPT;
- 1 Answers
- 5436 Views
- I also Faced
- E-Mail Answers
Answer / shailesh
Cartetian product i.e. 8 rows will be returned.
| Is This Answer Correct ? | 26 Yes | 0 No |
What is primary key in db?
What is parameter substitution in sql?
how is exception handling handled in mysql? : Sql dba
Types of joins?
1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?
How do I find sql profiler?
In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.
What are triggers, and when would you use them?
Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?
Explain how exception handling is done in advance pl/sql?
a procedure one in two out parameters i am waiting it in a sql query can i get the output
Why do we use sql constraints?
-
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)
