What is fill factor? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
How many packages we have in db
How would you best determine why your MVIEW couldn't FAST REFRESH?
How would you go about increasing the buffer cache hit ratio?
What types of replication are supported in sql server? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
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
How can you gather statistics on a table?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
what are the benefits of flashback feature?