Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?5 12971
What are two virtual tables available during database trigger execution ?2 9789
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?1 4027
Write the order of precedence for validation of a column in a table ?2 6531
What is an Exception ? What are types of Exception ?2 5130
What is Pragma EXECPTION_INIT ? Explain the usage ?2 7743
What is Raise_application_error ?1 6019
Where the Pre_defined_exceptions are stored ?2 6775
What is a stored procedure ?5 6338
What are the modes of parameters that can be passed to a procedure ?3 7865
Give the structure of the procedure ?1 4152
How can you tell the difference between an index and a view?
What is nvarchar max in sql?
What is rownum in sql?
What are different types of triggers?
Explain the uses of database trigger.
What is sql integrity?
Does sqlite need a server?
What is the difference between jpql and sql?
Explain two virtual tables available at the time of database trigger execution.
What is difference between table and view?
What are tables and fields in the database?
What is the difference between cluster and non-cluster index?
What is sqlca in powerbuilder?
Can we join tables without foreign key?
Is left join inner or outer by default?