Describe what redo logs are.
Answer / gogune suresh kumar
All data changes to the database are stored in redo-log
buffers.
| Is This Answer Correct ? | 4 Yes | 0 No |
Name three advisory statistics you can collect.
Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
what is meant by gateway
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?
What command would you use to encrypt a PL/SQL application?
What the different types of replication and why are they used? : sql server DBA
How do you open a cluster administrator? : sql server DBA
How can we see the database version in os level
How would you extract DDL of a table without using a GUI tool?
Give two examples of referential integrity constraints.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Oracle (3253)
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)