How can you control the amount of free space in your index pages? : sql server DBA


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

why Datapump is faster than traditional export and import

4 Answers   Mphasis,


What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,


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

0 Answers  


How do you resize a data file?

2 Answers  


I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  






mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  


In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  


You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  


Give two examples of how you might determine the structure of the table DEPT.

2 Answers  


How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  


Categories