ajexpert

 Profile Answers by ajexpert Questions by ajexpert

• Jul 29th, 2006

Clusters are optional method of storing table data.  A cluster is group of tables that share same data  blocks because they share common columns and often use together.

sri

• Aug 4th, 2005

Groups of tables physically stored together because they share common columns and are often used together is called clusters

Answer Question  Select Best Answer

 Multiple   instances   accessing  the  same  database  (Only  In  Multi-CPU environments) 

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 18th, 2007

Very true---Multiple instances uses by single database files is called parallel server. in this condition database files act as a server and connected with differenet instances.But each instances can use database files in same time.So the database file is called Parallel server.

Answer Question  Select Best Answer

 Group  of  tables  physically  stored  together  because  they share common columns and are often used together is called Cluster.

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Sep 28th, 2007

Yes that is true, For creating cluster we first create the cluster via index/hash, then we all the tables in the cluster.

Answer Question  Select Best Answer

 Two  processes wating to update the rows of a table which are locked by the other process then deadlock arises. In  a  database  environment  this will often happen because of not issuing proper  row  lock  commands. Poor design of front-end application may cause this situation and the performance of server will reduce drastically. These locks...

msabuu

 Profile Answers by msabuu Questions by msabuu

• Nov 6th, 2007

Oracle automatically detect deadlock , but not occar

Answer Question  Select Best Answer

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 23rd, 2012

Dear friend, it is not RAP but it is WRAP. Using this utility of Oracle, we can hide our PL/SQL code from user.

Answer Question  Select Best Answer

cmanne

 Profile Answers by cmanne Questions by cmanne

• Jul 29th, 2006

DBMS_METADATADBMS_STATSDBMS_SUPPORTDBMS_SESSION

akebono

• Aug 26th, 2005

 DBMS_OUTPUT.PUT_LINE('strings'); print out the strings  DBMS_UTILITY.get_time() get the current time  DBMS_ALERT e.g begin dbms_alert.register('myregister'); end  to register interst in a named alert   

Answer Question  Select Best Answer

Deepa Kale

• Apr 11th, 2007

If user authentication is managed by the database, security administrators should develop a password security policy to maintain database access security. For example, database users should be require...

Answer Question  Select Best Answer

Radha B S

• Mar 15th, 2006

Srinivas reddy Wrote: 1. Dynamic Memomry Management  2. Default tablespace at the db levele  3. temporary tablespace at the dba level 4. Undo tablespace managemnet (auto/manual)

srinivas reddy

• Mar 25th, 2005

1. Dynamic Memomry Management  2. Default tablespace at the db levele  3. temporary tablespace at the dba level 4. Undo tablespace managemnet (auto/manual)

Answer Question  Select Best Answer

Latches are low level serialization mechanisms used to protect shared data structures in the SGA. The implementation of latches is operating system dependent, particularly in regard to whether a process will wait for a latch and for how long.A latch is a type of a lock that can be very quickly acquired and freed. Latches are typically used to prevent more than one process from executing the same piece...

manoj seemar

• Nov 2nd, 2007

Latches are simple, low-level serialization mechanisms to protect shared data structures in the system global area (SGA). For example, latches protect the list of users currently accessing the databas...

Answer Question  Select Best Answer

Enqueues are another type of locking mechanism used in Oracle. An enqueue is a more sophisticated mechanism which permits several concurrent processes to have varying degree of sharing of "known" resources. Any object which can be concurrently used, can be protected with enqueues. A good example is of locks on tables. We allow varying levels of sharing on tables e.g. two processes can lock a table...

manoj seemar

• Nov 2nd, 2007

An enqueue is a sophisticated locking mechanism that permits several concurrent processes to share known resources to varying degrees. Any object that can be used concurrently can be protected with en...

Answer Question  Select Best Answer

innovative

 Profile Answers by innovative Questions by innovative

• Feb 20th, 2006

tablespaces are the logical constructs which are group of datafiles. a datafile belongs to one database. in laymans language we can say that tablespaces are like folders in windows environment. as we ...

Gurmeet Singh

• Feb 13th, 2006

Use of tableapce in oracle are:1) we can assign different quotas to the user of databasae2)we can take a part of database unavailable from the user3)we can create a object which have block size different from standard block size4) we can take backup of part of the database

Answer Question  Select Best Answer

rajendra singh chauhan

• Mar 20th, 2007

When a select statement is executed first of all the statements hash code is genrated then that hash code is matched in library cache if the hash code matched then statement is directly executed and if the hash code is not present then hard parsing is done and statement is executed

Santhosh Kumar

• Sep 4th, 2006

Processing Of Sql select statement: When any user executes any sql statement a user process generated and it the request sents to server process. First Server process checks for any privious ex...

Answer Question  Select Best Answer

ram

• Mar 8th, 2007

question is not clear  sturucture of database can be foud in dataflies redo log control files 

Answer Question  Select Best Answer

Ajwat Hasan

• Oct 10th, 2007

Often the word "lock" is synonymous to enqueue. In this document, "enqueue" will be used for the locking mechanism that you can find in V$LOCK. "locking" will be used whe...

Answer Question  Select Best Answer

senthilora

• Sep 24th, 2007

There are many ways to do that.? Following is the one of the ways I would prefer as I do it usually.You can achieve this by having a small Unix Scripting / Windows Shell Scripting?/ any other script...

Answer Question  Select Best Answer

imran44

 Profile Answers by imran44 Questions by imran44

• Dec 30th, 2008

The storage array should contain one or more spare disks (often called hot spares). When a physical disk starts to report errors to the monitoring infrastructure, or fails suddenly, the firmware should immediately restore fault tolerance by mirroring the contents of the failed disk onto a spare disk

Answer Question  Select Best Answer

ramanava1

 Profile Answers by ramanava1 Questions by ramanava1

• Feb 22nd, 2008

Export is one of taking backup.  In export backup you can specify many parameters in par file or at command line.  One of the parameter is statistics=y or n.  If you specify y it is going to export statistics generated in the database placed in dump file.  

Answer Question  Select Best Answer

kunal1017

 Profile Answers by kunal1017 Questions by kunal1017

• Jan 10th, 2008

HiBase tables are made when the database is created and these tables are stored in data dictionary. these base tables contains the information related to the database.? these tables are own by sys.th...

Answer Question  Select Best Answer

kailasTile

 Profile Answers by kailasTile Questions by kailasTile

• Dec 17th, 2007

It depends on your requirement, if you want no of users around 300 then you can still achieve that by keeping PGA parameters low. If you are looking for number of users 1000 or even more, you need to go for shared server mode. 

Answer Question  Select Best Answer

Hi, I've recently commissioned a hosted system from a developer who has recommended using J2EE and Oracle. Their J2EE system is quite slick and works very well in preproduction. It uses annotations to generate the Oracle tables on the fly during deployment. On examination of the table structures that it's generated though, it's defaulted all of the VARCHAR2 definitions to 255 characters. On asking...

kailasTile

 Profile Answers by kailasTile Questions by kailasTile

• Dec 18th, 2007

Changing VARCHAR2(255) to precise required width is good table design. Though it will not improve performance as such.

Answer Question  Select Best Answer