Q. Triggers can be enabled or disabled with the ________ statement.

View solution

Q. _____________ is special type of trigger based on CLR environment.

View solution

Q. Point out the correct statement.

View solution

Q. DDL triggers can be applied to __________ statement.

View solution

Q. INSTEAD of clause cannot be used for ____________ trigger.

View solution

Q. Point out the wrong statement.

View solution

Q. Purpose of DDL Trigger is to _____________

View solution

Q. DDL triggers can only fire after the ______ statement has occurred.

View solution

Q. How many types of DDL Trigger is present in SQL Server?

View solution

Q. ____________ triggers do not create the special inserted and deleted tables.

View solution

Q. Scope of DDL triggers in SQL Server can be _____________

View solution

Q. Which of the following is a way to build dynamic sql statements?

View solution

Q. Point out the correct statement.

View solution

Q. Dynamic SQL Statements in SQL Server can be easily built using ________________

View solution

Q. Which of the following is a calling syntax for sp_executesql?

View solution

Q. Point out the wrong statement.

View solution

Q. The Dynamic SQL Queries in a variable are __________ until they are executed.

View solution

Q. The basic syntax for using EXECUTE command is ___________

View solution

Q. Which of the following is a disadvantage of dynamic SQL?

View solution

Q. Which of the stored procedure used for dynamic SQL is prone to attacks?

View solution