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

DB Administration Interview Questions

Questions Answers Views Company eMail

how does an oracle clusterware manage crs resources?

Oracle,

1086

what are the performance views in an oracle rac environment?

Oracle,

1054

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

Oracle,

1073

how can you initialize log miner?

Oracle,

1144

What is a correlated sub-query? : sql server DBA

1085

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

1569

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

1103

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

1313

What is the importance of a recovery model? : sql server DBA

1026

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

1265

What purpose does the model database server? : sql server DBA

1185

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

1005

What are the recovery models for a database? : sql server DBA

1131

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

993

What the different types of replication and why are they used? : sql server DBA

1177

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

what are the types of connection load-balancing?

999

what are the performance views in an oracle rac environment?

1054

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2152

What would you do with an "in-doubt" distributed transaction?

1886

What is dcl? : sql server DBA

1268

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

1076

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

1198

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

2488

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

1161

What is replication? : sql server DBA

1174

what do you understand by flashback feature of oracle?

994

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

3761

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

2041

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1992

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.

1727

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