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-03283: specified datafile string does not exist

1 2992

ORA-03284: datafile string is not a member of tablespace string

1 4644

ORA-03286: ALLOCATE EXTENT not valid for HASH CLUSTERS

1 3007

ORA-03287: invalid FREELIST GROUP specified

1 2967

ORA-03288: both FREELIST GROUP and INSTANCE parameters may not be specified

1 2817

ORA-03289: partition name and segment type do not match

1 3275

ORA-03290: Invalid truncate command - missing CLUSTER or TABLE keyword

1 15212

ORA-03291: Invalid truncate option - missing STORAGE keyword

1 22453

ORA-03292: Table to be truncated is part of a cluster

1 4662

ORA-03293: Cluster to be truncated is a HASH CLUSTER

1 3293

ORA-03296: cannot resize datafile - file string not found

1 3492

ORA-03297: file contains used data beyond requested RESIZE value

1 4817

ORA-03298: cannot shrink datafile - file string is under hot backup

1 4073

ORA-03299: cannot create dictionary table string

1 3124

ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100

1 4579

Un-Answered Questions { Database Errors }

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

2432

ORA-26032: index string.string loading aborted after string keys

2105

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

1965

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2532

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2870

IMG-02003: 2FF03 - incorrect color histogram feature specification

1706

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

2696

what is the instrument that used in Mechanical Energy??

2680

ORA-16627: No standby databases support the overall protection mode.

3987

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6650

ORA-26027: unique index string.string partition string initially in unusable state

6744

What is the meaning of lock escalation and why/how to stop this?

2650

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

1958

ORA-16626: failed to enable specified object

2217

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2801

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