Interested to Buy Any Domain ? << Click Here >> for more details...
What are the steps you will take, if you are tasked with
securing an SQL Server?
- 1 Answers
- 7787 Views
- HCL, I also Faced
- E-Mail Answers
Answer / swapna
Preferring NT authentication, using server, databse and
application roles to control access to the data, securing
the physical database files using NTFS permissions, using
an unguessable SA password, restricting physical access to
the SQL Server, renaming the Administrator account on the
SQL Server computer, disabling the Guest account, enabling
auditing, using multiprotocol encryption, setting up SSL,
setting up firewalls, isolating SQL Server from the web
server etc.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is the impact on other user sessions when creating indexes?
what are the advanced features in sql 2008?
Explain the storage models of OLAP?
What happens if null values are involved in bitwise operations?
What are the different types of queries?
What is the difference between delete and truncate statements?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
Can we check locks in database? If so, how can we do this lock check?
how to avoid cursors? : Sql server database administration
What is page in sql server?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
