1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

Describe what redo logs are.

Question Posted / guest


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

Post New Answer

More DB Administration Interview Questions

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

How can you gather statistics on a table?

3 Answers  

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

Explain the use of table functions.

1 Answers  




what is ora 600?

1 Answers  

Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core 6.When i have run the following script for ORACLE _HOME environment variable setting . script is ". /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" variable is set but it is working only in current session. If i restart the system again i should run that script. So haw to set permanently ? even i have try with export command for that environment set it also does not work. Q. When i run sqlplus in shell prompt It is working but when i give user name and password the following error come out i.e # sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2 19:45:40 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory I have also proper partition of disk means swap memory are available. # fdisk -l Disk /dev/sda: 40.0 GB, 40060403712 bytes 255 heads, 63 sectors/track, 4870 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1275 10241406 7 HPFS/NTFS /dev/sda2 1276 4870 28876837+ f W95 Ext'd (LBA) /dev/sda5 1276 3187 15358108+ 7 HPFS/NTFS /dev/sda6 3188 4672 11928231 83 Linux /dev/sda7 4673 4863 1534176 82 Linux swap / Solaris

1 Answers  

how to restore files with rman?

0 Answers  

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

Explain the concept of the DUAL table.

3 Answers  

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

How would you go about generating an EXPLAIN plan?

2 Answers  

For more DB Administration Interview Questions Click Here
Categories