Can a particular event in SQL Server 2005, such as the CREATE USER command, have more than one DDL t - Yes An event can have multiple triggers assigned to it. - SQL Server Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATABASE

SQL SERVER

DETAILS

Question: Can a particular event in SQL Server 2005, such as the CREATE USER command, have more than one DDL trigger assigned to it?

Answer: Yes
An event can have multiple triggers assigned to it.

Category	SQL Server Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 7678 users
Added on	9/14/2014
Views	72030
Rate it!

Question: Can a particular event in SQL Server 2005, such as the CREATE USER command, have more than one DDL trigger assigned to it?

Answer:

Yes
An event can have multiple triggers assigned to it. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	Out of the box Report Builder supports two report level fields that can be shown on a report. Which option below has those two options?	View Answer
	After you've completed a backup for your Sales server to disk, you want to be sure that this backup is intact and able to be used for restores before writing it to tape. What command will help you here?	View Answer
	Which utility is used to administer SQL Server 2005 Notification Services instances?	View Answer
	You have noticed in both your SQL Server 2000 and 2005 instances that when a database grows in SQL Server, there is a delay in the database response. Why is that?	View Answer
	Using Reporting Services 2005, it is true or false that subreports execute a query against the datasource once for every detail row in the report?	View Answer
	You have created a database snapshot on SQL Server 2005 for the sales database to capture the end-of-month activity. The next day your server fails and you need to recover to a standby server using the previous night's backups. How do you recover the snapshot?	View Answer
	On which platforms can you use Instant File Initialization to improve database growth performance in SQL Server 2005?	View Answer
	You have a large table that you wish to partition to improve performance. The table contains many columns of data about customers and you decide that basic information about each customer will remain in the current table. Extended information, such as shipping instructions, secretaries' names, etc. will be moved to a new table along with the PK. What type of partitioning is this?	View Answer
	Which RAID levels store parity information?	View Answer
	True or false, Report Builder supports using the LIKE function inside filters?	View Answer
	Using Report Builder, which of the following statements is correct about formatting numbers?	View Answer
	Which of the following choices show the three report formats supported by Report Builder ?	View Answer
	Clicking File, Save in Report Builder does which of the following?	View Answer
	What is the easiest way to capture the SQL statement for a Report Builder report you're troubleshooting?	View Answer
	Using Report Builder, which of the following is the best statement about the formatting options for Boolean columns?	View Answer
	When discussing image support in Report Builder, which of the following is the most accurate statement?	View Answer
	True or false, Report Builder offers direct export to a Microsoft Access database as one of its supported export options?	View Answer
	If you absolutely need a report to look the same regardless of what OS or viewing software is being used, which of the following file formats would be the best choice?	View Answer
	Using Report Builder that is bundled with Reporting Services 2005, which of the following would work as a way to add a derived field to a report?	View Answer
	True or false, Report Builder supports user defined run time parameters?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All SQL Server Interview Questions & Answers - Exam Mode / Learning Mode