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
- 5469 Views
- I also Faced
- E-Mail Answers
IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF
SELECT * FROM EMP,DEPT;..
Answer / shailesh
Cartetian product i.e. 8 rows will be returned.
| Is This Answer Correct ? | 26 Yes | 0 No |
More SQL PLSQL Interview Questions
State few characteristics of pl/sql?
Can a table contain multiple foreign key’s?
Are sql connections encrypted?
What is the difference between between and in condition operators?
What are the different types of triggers?
What is pls_integer in pl sql?
what is query cache in mysql? : Sql dba
What schema means?
How many levels can subqueries be nested in a FROM clause?
how to create a test table in your mysql server? : Sql dba
Which is better cte or subquery?
What is the difference between the implicit and explicit cursors?
Categories
-
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)
