Explain the concept of two phase locking protocol with an example?
Latest Answer: Not sure of the particular terminology but 2 phase locking I believe would be similar to 2 phase commit where you must first make sure that everybody involved is ready, able, and willing (phase 1) then the next phase is when it actually ...
Turn three of your Scarlett Talent Agency entities into relations.
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
Latest Answer: Take backup of redologfiles only when you are doing cold backup not when you are taking hot backup in that case take backup of datafiles and controlfiles (thru backup trace command) and archivelogs. ...
Can you take online backup of a Control file if yes, how? Explain about Logical Backup?
Latest Answer: During database online you perform logical online backup for control file. ALTER DATABASE CONTROLFILE TO TRACE Through this command you perform control file trace backup which is logical. ...
Latest Answer: In addition to the previously stated reason that if there is a disk problem, not having them on that disk is a good idea, another issue might be contention. Putting them on the same disk would keep them togethere for disk backup purposes but I would go ...
.
Latest Answer: In Oracle 10G we do not have Bitmap Index . Bitmap index is available only in Oracle9i Enterprise Edition ...
How will you check the database status from os level in a unix env ?consider that some of the instances are in mount state; hence checking the pmon os process will be vain..? Need a unix os command to
HI I installed RHEL4 on my home pc.and I created 2 databases of oracle 10g (same vesrion)The problem is while iam establishing connectivity between these 2 databases iam getting error like TNS-03505:
Latest Answer: Just check your port number if two database are in one PC the port number is changed. ...
what are the necessary steps to be take when server gets down? How can we increase size of a database?
Latest Answer: 1.Bring up the server. 2.Run the profile of the database 3.Bring up the database. 4.In server prompt, check ps- ef | grep pmon - This is used to check whether the database is up or not. 5.Bring up the listener. 6.Check whether the tablespace ...
View page << Previous 1 [2] 3 4 5 6 7 Next >>
Go Top
