What is a system database and what is a user database? : sql server DBA
No Answer is Posted For this Question
Be the First to Post Answer
Explain the concept of the DUAL table.
Describe what redo logs are.
What is the importance of a recovery model? : sql server DBA
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 control the amount of free space in your index pages? : sql server DBA
Compare and contrast TRUNCATE and DELETE for a table.
Name two files used for network connection to a database.
how will u see whether the dabase is in archive log mode or not?
Where in the Oracle directory tree structure are audit traces placed?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
Where do you find the default index fill factor and how to change it? : sql server DBA