1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category
DB Administration Interview Questions
Questions Answers Views Company eMail

how does an oracle clusterware manage crs resources?

Oracle,

561

what are the performance views in an oracle rac environment?

Oracle,

549

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

Oracle,

553

how can you initialize log miner?

Oracle,

568

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

 577

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

 832

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

 556

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

 719

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

 544

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

 644

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

 615

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

 550

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

 580

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

 505

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

 548

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

591

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

615

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1547

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

1537

How would you go about verifying the network name that the local_listener is currently using?

2748




what functionality does oracle provide to secure sensitive information?

543

What are statistics, under what circumstances they go out of date, how do you update them?

1799

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

531

Why does Oracle not permit the use of PCTUSED with indexes?

2314

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2051

What is transparent data encryption? : sql server DBA

557

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

553

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

3931

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

591

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

593

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