Does user triggers have entry for trigger with compilation errors?
What is the purpose of the primary key?
What is the difference between distinct and unique in sql?
What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN
What is data type in sql?
Write a sql select query that only returns each name only once from a table?
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
When we give SELECT * FROM EMP; How does oracle respond?
24 Answers Accenture, HCL, Infosys,
Is there any restriction on the use of union in embedded sql?
When do we use triggers?
Can we use joins in subquery?
Mention what does plv msg allows you to do?
What are nested triggers ?
6 Answers Amazon, Appeal Soft, IBM, Infosys, TCS,