What are the steps you will take, if you are tasked with
securing an SQL Server?
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
Is This Answer Correct ? | 3 Yes | 1 No |
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
how do see how much space is used and free in a tablespace
Name a tablespace automatically created when you create a database.
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?
What command would you use to encrypt a PL/SQL application?
how can you connect from 10g user to 11g user??
what is the purpose of catlaog in oracle rman?
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
If we issue alter database begin backup. What happens to database?
What are the steps you will take, if you are tasked with securing an SQL Server?