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

547

What is transparent data encryption? : sql server DBA

567

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

559

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

619

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

604

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

565

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

587

What is fill factor? : sql server DBA

648

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

565

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

582

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

569

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

581

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

617

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

602

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

How would you extract DDL of a table without using a GUI tool?

2051

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

569

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1552

What the different topologies in which replication can be configured? : sql server DBA

666

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2235

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

605

what is asm?

615

Query processing is slow(eg select query)how will u solve that

6528

how can you schedule a job in database?

603

what are the performance views in an oracle rac environment?

563

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

1755

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

566

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

1952

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

581

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1239

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