how to write test cases for testing databases,especially
for testing and writing test cases for stored
procedures.any real time database testers.please answer me.
There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
How retrieve field names from the table in SQL through JAVA
code?
93
Any one plz send me SQL Server Developer/DBA resume for 4
years experience
318
when u import an excel file into sql if suppose one column
has got a date field with system time attached to it what
data type u will use in sql to import it in a table?
Note: a condition is the excel file has no primary key
defined to a column...also u r importing bulk data into sql
159
Define Check points and End Points?
28
1. Tell me your daily activities
2. If sql server installation fails at time
installation what will do
3. Where does the sql server installation log details
are stored
4. After the installation what will you do for memory
configuration
5. What is the difference between SQL max maximum
memory and AWE memory
6. How will you configure AWE memory
7. How will setup an email alert for the backup job
8. After the SQL installation what are the jobs will
you configure
9. What does –g mean in the sql startup parameter
10. What is the difference between Bulked log and Full
recovery model
11. What is the difference between mirroring and log
shipping
12. What are the steps to be followed before in-place
up gradation
13. After installing the patch the sql server does not
start and application team tells to rollback the
changes .In this scenario what will you do
How do you Implement SSIS Packages in your Project?
66
i use few third party softwares. they r all having their
own databases .
but the data is repeated in all these databases - say a
person is in all the three databases, but his name is
stoared in diff format in all databases
i want to create a centralised database ,and i dont want to
re-enter the records .
using the exisating records how can i build a centralised
database?
105
How to restore performance issues and how to check?
28
how can you attach more than 20 ldf files in sql server
101
What is Data model and how to prepare a data model.?
Can you give me some DBCC command options?(Database
consistency check) - DBCC CHECKDB - Ensures that tables in
the db and the indexes are correctly linked.and DBCC
CHECKALLOC - To check that all pages in a db are correctly
allocated. DBCC SQLPERF - It gives report on current usage
of transaction log in percentage. DBCC CHECKFILEGROUP -
Checks all tables file group for any damage.
To Refer this Site to Your Friends 
Site Map
