DB Administration Interview Questions
Questions Answers Views Company eMail

How do you open a cluster administrator? : sql server DBA

788

Which autogrowth database setting is good? : sql server DBA

761

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

908

Where do you find the default index fill factor and how to change it? : sql server DBA

807

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

900

What are the different types of indexes available in sql server? : sql server DBA

816


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What are the operating modes in which database mirroring runs? : sql server DBA

857


How to start SQL Server in minimal configuration mode?

7329


what are the types of connection load-balancing?

750


What are the different types of indexes available in sql server? : sql server DBA

816


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

1144


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3492


what is logical system in sap basis

1364


which background process invoke at the time of upgradation tell me???

2464


What is the default fill factor value? : sql server DBA

806


. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2182


how can you schedule a job in database?

814


What are the commands you'd issue to show the explain plan for "select * from dual"?

1979


what is the diffrence between core dba and apps dba?

2313


Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

1918


what is the last version,the release date of that version and fix pack of ibm db2 udb?

1705