Answer / 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

If CPU is very slow What can u do to speed up?

1 Answers  

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

How to make a replica of existing oracle server to another server?

3 Answers  

---

What is the default fill factor value? : sql server DBA

0 Answers  

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

how can you create a user-defined lock?

0 Answers   Oracle,

---

How can you gather statistics on a table?

3 Answers  

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---