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 |
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Explain CREATE DATABASE syntax?
Name a tablespace automatically created when you create a database.
What is the default fill factor value? : sql server DBA
I lost one datafile i dont have backup how can you recover that???
what is the diffrence between core dba and apps dba?
how can you implement fine-grained auditing?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What would you do with an "in-doubt" distributed transaction?
What questions might be they ask in managerial round in capgemini.
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?
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)