MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
True or false? You can query the sys.missing ____ sids table to identify orphaned users in a database.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Detect Orphaned Users SELECT dp. type desc, dp. sid, dp.name AS user name FROM sys. database principals AS dp LEFT JOIN sys.

Detailed explanation-2: -If you find any orphaned users, then create login by using orphaned user SID. UPDATE ONE can be used to change user’s SID with Logins SID. It can be used to map even if Login name and User name are different (or) same. Now we can create new login.

Detailed explanation-3: -A database user for which the corresponding SQL Server login is undefined or is incorrectly defined on a server instance cannot log in to the instance and is referred to as orphaned and should be removed. Orphan users should be removed to avoid potential misuse of those broken users in any way.

There is 1 question to complete.
Previous
Next