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
No Answer is Posted For this Question
Be the First to Post Answer
what are the types of connection load-balancing?
Explain what partitioning is and what its benefit is.
What authentication modes does sql server support? : sql server DBA
how will you see when the database was started using sql prompt?
SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
what is ora 600?
What is blocking and how would you troubleshoot it?
What view would you use to look at the size of a data file?
What is the importance of a recovery model? : sql server DBA
1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????
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.
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?