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
- 5474 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
What are some predefined exceptions in pl/sql?
How to know the last executed procedure?
Is sql considered coding?
Is it possible to update views?
What is the use of index in sql?
Write the command to remove all players named sachin from the players table.
What are local and global Indexes and where they are useful.
What is field delimiter?
How do you declare a user-defined exception?
display null value rows with out using null function?
Mention what does the hierarchical profiler does?
What is a sql schema used for?
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)
