Can triggers stop a dml statement from executing on a table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00

3 Answers  


mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

0 Answers  


How do you take the union of two tables in sql?

0 Answers  


How to return multiple records from procedure?

2 Answers  


How to order siblings in oracle hierarchy queries?

0 Answers  






What is mutating error?

0 Answers  


Explain mutating table error.

0 Answers  


how to check myisam tables for errors? : Sql dba

0 Answers  


what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  


How many subqueries can be nested in a statement?

0 Answers  


SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers  


Is left join inner or outer?

0 Answers  


Categories