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

how can you connect from 10g user to 11g user??

0 Answers   HP,

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

---

what is rebuild index??

2 Answers   IBM, Sapient,

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

what is incremental checkpoint?

1 Answers   CTS,

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

what is the differnce between process and thread ?

1 Answers   IBM,

---