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
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what is rebuild index??
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
how do see how much space is used and free in a tablespace
how can you communicate with operating system files from oracle?
What are the different ways of moving data or databases between servers and databases in SQL Server?
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
What types of replication are supported in sql server? : sql server DBA
Which environment variables are absolutely critical in order to run the OUI?
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)