Interested to Buy Any Domain ? << Click Here >> for more details...
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
- 0 Answers
- 1068 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is a database development?
Who are naive users?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What is the system function to get the current user's user id?
What is an extended stored procedure?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
How you can make a parameterized view?
How to generate OIDS
How to use online Backups?
Given an employee table, how would you find out the second highest salary?
Explain about the database management systems.
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
1 Answers Flextronics, Hexaware, SQL Star,
-
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)
