MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Important messages, particularly those considered as severe error messages, are logged to which Windows subsystem. Choose two
A
Windows application event log
B
SQL server application event log
C
SQL Server error log
D
Windows Server error log
Explanation: 

Detailed explanation-1: -The ErrorLog event class indicates that messages have been logged in the SQL Server error log.

Detailed explanation-2: -There are two types of errors in SQL Server: system errors and custom errors. System errors can be viewed in the sys. messages system view and are defined by SQL server. Therefore, when a system error occurs, SQL Server will log a system error and may take actions to fix the error.

Detailed explanation-3: -When called in a CATCH block, ERROR MESSAGE returns the complete text of the error message that caused the CATCH block to run. The text includes the values supplied for any substitutable parameters-for example, lengths, object names, or times. ERROR MESSAGE returns NULL when called outside the scope of a CATCH block.

Detailed explanation-4: -SQL Administrator does not provide permission to Allow remote connection. It is also possible that SQL Server Management Studio using the incorrect port number. That is why user will get the MS SQL Server Error 2. The SQL Server Browser service is not enabled under the SQL Server Configuration Manager.

There is 1 question to complete.
Previous
Next