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 ways you can create databases in sql server? : sql server DBA

1088

What is dcl? : sql server DBA

1197

What is the difference between clustered and non-clustered index? : sql server DBA

1035

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

943

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

1071

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

1147

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1162

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

1007

Explain about your sql server dba experience? : sql server DBA

1035

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1034

What is dbcc? : sql server DBA

1228

Why would you use sql agent? : sql server DBA

1028

What is replication? : sql server DBA

1108

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

1228

Why would you call update statistics? : sql server DBA

951

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1927

What is fill factor? : sql server DBA

1187

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2043

what is the role of dip user in our database?

2369

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

1204

how can you find out if a table can be redefined?

966

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2751

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1030

what is the diffrence between core dba and apps dba?

2517

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2625

what is asm?

1005

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2587

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

1095

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2458

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

1020

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