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-14283: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION

1 4866

ORA-14284: one or more of table's subpartitions reside in a read-only tablespace

1 3172

ORA-14285: cannot COALESCE the only partition of this hash partitioned table or index

1 3339

ORA-14286: cannot COALESCE the only subpartition of this table partition

1 2843

ORA-14287: cannot REBUILD a partition of a Composite Range partitioned index

1 11217

ORA-14288: index is not partitioned by Composite Range method

1 5692

ORA-14289: cannot make local index partition of Composite Range partitioned table unusable

1 4629

ORA-14290: PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

1 2805

ORA-14291: cannot EXCHANGE a composite partition with a non-partitioned table

1 6581

ORA-14292: Partitioning type of table must match subpartitioning type of composite partition

1 3788

ORA-14293: Number of partitioning columns does not match number of subpartitioning columns

1 3336

ORA-14294: Number of partitions does not match number of subpartitions

1 5190

ORA-14295: column type or size mismatch between partitioning columns and subpartitioning columns

1 3424

ORA-14296: Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

1 3862

ORA-14297: Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

1 3905

Un-Answered Questions { Database Errors }

NZE-28868: Peer certificate chain check failed.

2803

ORA-16626: failed to enable specified object

2225

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

2670

What is the use of NOLOCK locking hint?

1788

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

1958

hp asking for replication floppy to do reinstall 25254 server assistant

2888

When do you get "getwmicomexception"?

2686

why we are using shift key in unix shell script

3175

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.

2539

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

6751

ORA-26084: direct path context already finished

1951

How to view the error log for any specific instance?

2488

IMP-00064: Definition of LOB was truncated by export

6418

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

2809

IMP-00070: Lob definitions in dump file are inconsistent with database.

1749

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