How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
656Post New DB Administration Questions
how can you initialize log miner?
how can you create a user-defined lock?
What purpose does the model database server? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what is a user-defined lock?
What is transparent data encryption? : sql server DBA
internal architecture
What the different types of replication and why are they used? : sql server DBA
what is asm?
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.
Where would you look for errors from the database engine?
how can you connect from 10g user to 11g user??
how can you find out if a table can be redefined?
What is a correlated sub-query? : sql server DBA