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

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

Explain the use of table functions.

1 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

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

0 Answers   Oracle,

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

How do you add a data file to a tablespace?

3 Answers  

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---

What is transparent data encryption? : sql server DBA

0 Answers  

---

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

---