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

Post New Answer

More DB Administration Interview Questions

what are the types of connection load-balancing?

0 Answers   Oracle,


Explain what partitioning is and what its benefit is.

2 Answers  


What authentication modes does sql server support? : sql server DBA

0 Answers  


how will you see when the database was started using sql prompt?

2 Answers   IBM,


SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,






what is ora 600?

1 Answers  


What is blocking and how would you troubleshoot it?

1 Answers  


What view would you use to look at the size of a data file?

3 Answers  


What is the importance of a recovery model? : sql server DBA

0 Answers  


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?????

2 Answers   Genpact,


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.

0 Answers  


What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  


Categories