What is the cache hit ratio, what impact does it have on
performance of an Oracle database and what is involved in
tuning it?
No Answer is Posted For this Question
Be the First to Post Answer
Explain CREATE DATABASE syntax?
What is the difference between dropping a database and taking a database offline? : sql server DBA
How to make a replica of existing oracle server to another server?
What is blocking and how would you troubleshoot it?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How do you resize a data file?
Give two examples of referential integrity constraints.
What are the different types of indexes available in sql server? : sql server DBA
what are the benefits of flashback feature?
how can you record information about current session?
Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
11 Answers FA, GE, Wipro,
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)