| Other SQL PLSQL Interview Questions |
|| Asked @
|What is the Diff b/w Constraints and Trigeer
|What is the difference between the Primary and Foreign key?
|What is an Integrity Constraint?
|SELECT category, type, AVG(price)
FROM products GROUP BY category, type ORDER BY 1, 2
If there are three distinct categories in the "products"
table, and each one has five different types, how many rows
are returned by the query above?
1. 1 row
2. 3 rows
3. 5 rows
4. 8 rows
5. 15 rows
|How can u find column name from a table which have max value
in a row.( not max value)
|What is nvl function?
|When the mutating error will comes? and how it will be
|what is difference between "Primary key" and "Unique key"?
|define a variable representing the expression used to
calculate on emps total annual remuneration.use the
variable in a statement which finds all emps who can earn
30000 a year or more.
|If an unique key constraint on DATE column is created, will
it validate the rows that are inserted with SYSDATE?
|What are all the difference between Like and Contains ?
sql gurus, here is my question 4 u.
i wanna use triggers for sending reminder mail to all users
who are registered to the site. if any one knws the code plz
send me ans here : email@example.com
|For more SQL PLSQL Interview Questions Click Here |