databases Online Quiz - 90
|Description: databases Online Quiz - 90|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Identity is a column that automatically generates numeric values.
For which of the following queries may a merge join be considered?
Choose the correct statements about the union clause in ASE (Choose 2)
Which of the following are true about triggers? (Choose 2)
Table t and trigger trig are created as follows: create table t (a int) go create trigger trig on t for insert, update, delete as begin if @@rowcount > 1 rollback trigger end go The following transaction is now executed: begin tran insert t values (1) insert t values (2) insert t select * from t insert t values (3) commit go After completing this transaction, how many rows will table t contain?
Which T-SQL elements can be used in a stored procedure? (Choose 2)
Which ASE table contains the source code of a stored procedure?
What is the maximum number of characters that can be passed to a stored procedure through a single char or varchar parameter without being truncated?
The following trigger exists: create trigger trig on t for insert, update, delete as begin print 'This is 'trig' ' end The following command is now executed: create trigger trig on t for insert as begin print 'This is 'trig' ' end After executing this command, for which DML actions on table 't' will a trigger be fired?
A call statement inside the trigger body enables you to call:
What part of a DB trigger determines the number of times a trigger body executes?