What are triggers? How many triggers you can have on a
table?
Answers were Sorted based on User's Feedback
Answer / shanky
Triggers are PL/SQL blocks which are executed implicitly
based
on database events.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / guest
Triggers are PL/SQL blocks which are executed implicitly based
on database events.
| Is This Answer Correct ? | 4 Yes | 3 No |
What are the disadvantages of cursors? How can you avoid cursors?
Explain about normal forms?
Can an extended stored procedure be called from inside a user-defined function?
Explain about post-relational databases?
Who are naive users?
What is data modeling with example?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
What is a self join? Explain it with an example?
What is the physical representation for a many-to-many relationship?
What are the 18 schemas?
How can you log an error to the server event log from a stored procedure?
what is difference between primary key and unique key ?
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)