DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Administration Interview Questions

Questions Answers Views Company eMail

What are the different sql server versions you have worked on? : sql server DBA

543

What is transparent data encryption? : sql server DBA

562

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

553

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

610

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

593

What happens on checkpoint? : sql server DBA

564

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

558

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

580

What is fill factor? : sql server DBA

644

What is the default port no on which sql server listens? : sql server DBA

556

What is the difference between dropping a database and taking a database offline? : sql server DBA

578

How do you troubleshoot errors in a sql server agent job? : sql server DBA

564

What are the commands used in dcl? : sql server DBA

577

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

612

What is a system database and what is a user database? : sql server DBA

599

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1511

How would you best determine why your MVIEW couldn't FAST REFRESH?

1826

who owns the operating system files created by the utl_file package?

564

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

1637

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

581

What are the different types of database compression introduced in sql server 2008? : sql server DBA

564

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

548

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

574

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

1834

What is the default port no on which sql server listens? : sql server DBA

556

Where would you look for errors from the database engine?

2354

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

1979

What types of replication are supported in sql server? : sql server DBA

598

what is asm?

605

What the different components in replication and what is their use? : sql server DBA

536

For More Un-Answered { DB Administration } Questions Click Here