Database Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Errors Interview Questions

Questions Answers Views Company eMail

ORA-37121: AW Spreadsheet invalidated

1 3035

ORA-37122: AW Session cache disabled

1 3315

ORA-37126: (XSCCOMP01) The COMPRESSED COMPOSITE workspace object can only be used as a base of a single variable.

1 2951

ORA-37127: (XSCCOMP02) The COMPRESSED COMPOSITE workspace object must be last in the dimension list.

1 2800

ORA-37128: (XSCCOMP03) It is not possible to PARTITION over a base of a COMPRESSED COMPOSITE.

1 2855

ORA-37129: (XSCCOMP04) The AGGMAP workspace object cannot be used to aggregate the VARIABLE workspace object. All static MODEL statements must precede all RELATION statments over the bases of the COMPRESSED COMPOSITE.

1 2863

ORA-37130: (XSCCOMP05) Cannot aggregate VARIABLE workspace object using AGGMAP workspace object because there is a PRECOMPUTE clause on a RELATION over the base of a COMPRESSED COMPOSITE.

1 2651

ORA-37131: (XSCCOMP06) Cannot aggregate VARIABLE workspace object using AGGMAP workspace object because the OPERATOR string is not supported for bases of a COMPRESSED COMPOSITE.

1 3257

ORA-37132: (XSCCOMP07) Incremental aggregation over the dense DIMENSION workspace object is not supported when aggregating a VARIABLE dimensioned by a COMPRESSED COMPOSITE.

1 3037

ORA-37133: (XSCCOMP08) Cannot write into an aggregated VARIABLE dimensioned by a COMPRESSED COMPOSITE. Use the CLEAR AGGREGATES command to reenable write access.

1 2821

ORA-37134: (XSCCOMP09) You cannot add new values to workspace object because it includes positions for precomputed aggregate values.

1 2629

PCB-00001: %s

1 2655

PCB-00002: Command line processor severe error

1 2891

PCB-00003: Value of DBMS option invalid with given value of MODE option

1 2881

PCB-00004: UNSAFE_NULL=YES must be used with DBMS=V7 or V8 and MODE=ORACLE

1 3017

Un-Answered Questions { Database Errors }

RMAN-05017: no copy of datafile number found to recover

2410

IMP-00064: Definition of LOB was truncated by export

6415

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1656

ORA-26094: stream format error: input column overflow

2808

ORA-26079: file "string" is not part of table string.string

1958

why we are using shift key in unix shell script

3167

ORA-16516: The current state is invalid for the attempted operation.

8820

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2733

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3385

ORA-26084: direct path context already finished

1949

ORA-26076: cannot set or reset value after direct path structure is allocated

1970

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2705

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1620

What is live lock, deadlock and what is Lock escalation?

2434

What is SCD (Slowly Changing Dimensions)? What are its types?

2666

For More Un-Answered { Database Errors } Questions Click Here