What is Acid Properties in Oracle?

ushaudayam

 Profile Answers by ushaudayam Questions by ushaudayam

• Mar 22nd, 2010

ACID Properties areAtomicity: A transaction is an atomic unit of execution, which may contain more than one database operation. The transaction should be done entirely or done nothing to keep data in ...

nasunilkumar

 Profile Answers by nasunilkumar Questions by nasunilkumar

• Mar 20th, 2010

ACID properties are1) Atomicity2) Consistency3) Isolation4) Durability

Answer Question  Select Best Answer

What are the different types of segments in Oracle?

hmounir

 Profile Answers by hmounir Questions by hmounir

• Apr 21st, 2010

Four types of segments are found in an Oracle database:1- Data segment every table in the database resides in a single data segment.2- Index segment each index is stored in its own index segment.3- Te...

narendra05

 Profile Answers by narendra05 Questions by narendra05

• Apr 16th, 2010

There are following types of segments in Oracle1. Data segments stores the data2. Index segment stores the index data3. Rollback segment : Stores undo data information for data consistency.

Answer Question  Select Best Answer

Outline the names and function of Oracle background processes

vidyajnath

 Profile Answers by vidyajnath Questions by vidyajnath

• Apr 23rd, 2010

The Oracle architecture has five mandatory background processes Mandatory background processes: DBWR (Database Writer) PMON (Process Monitor) CKPT (Check Point) LGWR (Log Writer) SMON (System Monitor)...

Answer Question  Select Best Answer

Explain about the Chained / Migrated Rows

vidyajnath

 Profile Answers by vidyajnath Questions by vidyajnath

• Apr 23rd, 2010

In two circumstances, the data for a row in a table may be too large to fit into a single data block. In the first case, called chaining, the row is too large to fit into an empty data block. In this ...

Answer Question  Select Best Answer

How can you prevent tablespace fragmentation? (rebuilding, moving)?

vidyajnath

 Profile Answers by vidyajnath Questions by vidyajnath

• Apr 23rd, 2010

As rows are added to tables, the table expands into unused space within the space. Conversely, when rows are deleted, a table may coalesce extents, releasing unused space back into the tablespace. As ...

Answer Question  Select Best Answer

What is Dynamic SGA?What is the advantage of Dynamic SGA?

hmounir

 Profile Answers by hmounir Questions by hmounir

• May 3rd, 2010

Dynamic SGA allows to change the size of the buffer cache, the large pool, the shared pool and the process private memory on the fly, that is without shutting down the instance.

doza_kasf

 Profile Answers by doza_kasf Questions by doza_kasf

• May 1st, 2010

Dynamic SGA allows to change the size of the buffer cache, that is without shutting down the instance.

Answer Question  Select Best Answer

How will you change the local management tablespaces into dictionary management tablespaces?

dharan415

 Profile Answers by dharan415 Questions by dharan415

• May 26th, 2010

To convert a LMT to DMT,SQL> exec dbms.space_admin.Tablespace_Migrate_From_local('Tablespace name');

hmounir

 Profile Answers by hmounir Questions by hmounir

• May 5th, 2010

By  creating all rollback segments in locally-managed tablespaces.

Answer Question  Select Best Answer

When do we will go for Sequence and when go for Indexes. What is the difference between Sequence and Indexes.

varunprasath

 Profile Answers by varunprasath Questions by varunprasath

• Jun 7th, 2010

Sequence - A sequence is used to generate a number sequence that can be used as a primary key.Indexes - An index is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed columns.

Answer Question  Select Best Answer

How to update base table (data dictionary) automatically in every 5 sec or 5 min?

monika_iims

 Profile Answers by monika_iims Questions by monika_iims

• Jun 18th, 2010

1.create a procedure with update statement2. create a job on that procedure and give the time interval

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Mar 4th, 2009

Provide clear scenerio what you want to achieve with example

Answer Question  Select Best Answer

sunnybhattacharjee

 Profile Answers by sunnybhattacharjee Questions by sunnybhattacharjee

• Jul 7th, 2010

You can store a jpeg file or a bitmap file in Oracle using the BLOB data type.It stores the jpeg image as a stream of bytes.In order to retrieve the data.You cant simply perform a select query over it...

sudheer

• Oct 6th, 2006

To store larger object in database use 'blob'

Answer Question  Select Best Answer

How to show the cursor is busy when any process is going on in Oracle Forms 6i?

budzboy

 Profile Answers by budzboy Questions by budzboy

• Jul 14th, 2010

Set_application_property(cursor_style, busy);

Answer Question  Select Best Answer

How to debug stored procedure in Oracle?

budzboy

 Profile Answers by budzboy Questions by budzboy

• Jul 14th, 2010

You may use dbms_output.put_line([string]) between lines you think causes the error.

Answer Question  Select Best Answer

How to convert Oracle Report into text or doc file?

bondneoo

 Profile Answers by bondneoo Questions by bondneoo

• Aug 18th, 2010

Goto Tools->Preferencesthen Runtime Values->Set mode to character.

Answer Question  Select Best Answer

Which command is used for locking a user from performing DML Operation?

ashdba

 Profile Answers by ashdba Questions by ashdba

• Sep 5th, 2010

Revoke insert,update,delete privileges from the user

karthikasathya

 Profile Answers by karthikasathya Questions by karthikasathya

• Oct 1st, 2009

LOCK TABLE  tablename IN EXCLUSIVE MODE;EX:LOCK TABLE emp IN EXCLUSIVE MODE;

Answer Question  Select Best Answer

SQL>DECLARE 2 dayofweek VARCHAR2(200); 3 BEGIN 4 SELECT TO_CHAR(sysdate,'Day') INTO dayofweek FROM DUAL ; 5 6 IF dayofweek = 'Tuesday' 7 THEN 8 DBMS_OUTPUT.PUT_LINE('Aloha!!! Today Is Tuesday'); 9 ELSE 10 DBMS_OUTPUT.PUT_LINE('Today is '||to_char(sysdate,'Day')); 11 END IF; 12 END; 13 /Today is TuesdayPL/SQL procedure successfully completed.SQL>What's...

kperumal75

 Profile Answers by kperumal75 Questions by kperumal75

• May 2nd, 2011

It should be (sysdate,'day')

shri_b

 Profile Answers by shri_b Questions by shri_b

• Mar 12th, 2010

Use trim(dayofweek) in IF Condition

Answer Question  Select Best Answer

How does Oracle guarantee data integrity?

kperumal75

 Profile Answers by kperumal75 Questions by kperumal75

• May 4th, 2011

Data Integrity is maintained by Triggers and various other constraints in Oracle.

kperumal75

 Profile Answers by kperumal75 Questions by kperumal75

• May 4th, 2011

Oracle Database enables you to define and enforce each type of data integrity rule defined in the previous section. Most of these rules are easily defined using either integrity constraints or datab...

Answer Question  Select Best Answer

How do you send the output of your SQL* Plus session to a text operating system file

prateek2612

 Profile Answers by prateek2612 Questions by prateek2612

• May 15th, 2011

See spool command

lanka_satya

 Profile Answers by lanka_satya Questions by lanka_satya

• Jul 4th, 2008

well you want to see the output ina  text file............this can be done by spooling the data;for example..you want to see the output of the details of all employees:do the following steps:spoo...

Answer Question  Select Best Answer

hii i have a emp table .empno stores all the numeric valuesand accidentally i have added some values with combination of alphabets and special charactersnow i need a query which will return all the records which is having alphabets and characters in their value.assume tht table has records in lakhs.Please answer this questionthankx in advancesreekanth

damodharyadav

 Profile Answers by damodharyadav Questions by damodharyadav

• May 23rd, 2011

Select non_num_col from sample_tablewhere length(non_num_col) -length(replace(translate(non_num_col,'qwertyuiopasdfghjklzxcvbnm',' '),' ','')) 0 

neha.awasthi1

 Profile Answers by neha.awasthi1 Questions by neha.awasthi1

• May 19th, 2011

Select order_status from orders where TRANSLATE (order_status, CHR (1) || '1234567890', CHR (1)) is not null

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

ACE_GEEK  

 Profile Answers by ACE_GEEK Questions by ACE_GEEK

• Member Since Jul-2008 | Jul 22nd, 2008

---

"C" ofcourse!!!

sirih1

 Profile Answers by sirih1 Questions by sirih1

• May 24th, 2011

Oracle is developed using C and C++

matabrez

 Profile Answers by matabrez Questions by matabrez

• Nov 6th, 2010

Till 9i it was developed in using "C" and Java langauge. But from 10g it is fully developed in Java.

Improve Answer

No. Only the DDL(Data Definition Language )statements like create,alter,drop,truncate are auto commit.But the DML statements are should be saved by giving the commit statement after execute the query

Hema

• Nov 1st, 2007

DDL is Data Definition Language. DDL commands work on the table directly or on the table structure. By default it has auto commit.DML is Data Manipulation language that affects the data present in the table. Any addition or modification of data has to be saved by the Commit command.

Arindam Ghsoh

• Aug 20th, 2007

DDL and DML are different.DDL is data definition language and it has autocommitBut in DML there is no auto commit.

Answer Question  Select Best Answer