SQL Server logs event messages in internal tables in the msdb database. You can configure how much information it logs by setting the logging level to one of the following:Choose three.

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

A	Normal
B	Limited
C	Extended
D	Extensive
E	Verbose

Explanation:

Detailed explanation-1: -In the Properties dialog box, select the Logging tab. In the Server Group Properties dialog box, select the server and then click Edit. In the Add/Edit Log Module dialog box, select the logging level from the Event Type drop-down list. Click OK.

Detailed explanation-2: -In Object Explorer, expand the instance of SQL Server, expand Management, right-click SQL Server Logs, and then click Configure. In the Configure SQL Server Error Logs dialog box, choose from the following options. Check to limit the number of error logs created before they are recycled.

Detailed explanation-3: -The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail. For example, SQL Server automatically maintains a complete online backup-and-restore history within tables in msdb.

Detailed explanation-4: -Logging in the Catalog The catalog has four built-in logging levels to choose from: Basic (the default), Performance, Verbose, and None.

There is 1 question to complete.

MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL