Answer Posted / sandeep

Again this is another open ended question. Here are some
things you could talk about: 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.
Read the white paper on SQL Server security from Microsoft
website. Also check out My SQL Server security best practices

how can you implement fine-grained auditing?

1082

---

Explain materialized views and how they are used.

2401

---

What are the different sql server versions you have worked on? : sql server DBA

972

---

What are the operating modes in which database mirroring runs? : sql server DBA

1124

---

What types of replication are supported in sql server? : sql server DBA

1231

---

what functionality does oracle provide to secure sensitive information?

956

---

what is the use of ocr?

977

---

Explain about your sql server dba experience? : sql server DBA

1037

---

Why would you use sql agent? : sql server DBA

1032

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2422

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1156

---

what is grd?

1056

---

how does an oracle clusterware manage crs resources?

1041

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4394

---

who owns the operating system files created by the utl_file package?

1027

---