MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which system view provides catalog information about existing credentials. Choose the correct answer.
A
The admin.credentials
B
The sys.credentials
C
The Gglobal.credentials
D
None of the above
Explanation: 

Detailed explanation-1: -The sys. objects catalog view returns rows for objects other than tables, such as stored procedures and views.

Detailed explanation-2: -Explanation: The INFORMATION SCHEMA views allow you to retrieve metadata about the objects within a database. These views can be found in the master database under Views / System Views and be called from any database in your SQL Server instance. 10.

Detailed explanation-3: -The password for a SQL Authenticated login is stored in the master database. Because the password is stored in a SQL database, it is more easily hacked. It can also be backed up and restored with a database backup which is why it is less secure than using Windows authentication.

Detailed explanation-4: -An SQL catalog is a collection of tables and views that describe tables, views, indexes, procedures, functions, sequences, triggers, variables, constraints, programs, packages, and XSR objects.

There is 1 question to complete.
Previous
Next