adspace


What are basics of policy management?

Answer Posted / Bhupendra Singh

"Policy management in SQL Server involves creating, modifying, and enforcing rules to govern database objects and user behavior. The basics include setting up roles and permissions, data encryption, auditing, and compliance with industry regulations such as GDPR or HIPAA. Policies can be managed using SQL Server Management Studio (SSMS) or Transact-SQL (T-SQL) commands.".

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert character strings into numeric values?

1192


How raid can influence database performance?

1118


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1215


Can we do dml on views?

1039


What is a scheduled job or what is a scheduled task?

1040


do you know how to configure db2 side of the application? : Sql server database administration

1125


Why should you use or avoid select * statements?

1111


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1134


Equi join and non equi join is possible with sql server?

1134


What is normalization and what are the advantages of it?

1057


What kind of problems occurs if we do not implement proper locking strategy?

1500


What is the primary use of the model database?

1151


What is an indexed view?

1023


Explain “row_number()” in sql server with an example?

1080


What is temporary table in sql server? Why we use temp table?

1023