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-12065: unknown refresh group identifier string

1 2999

ORA-12066: invalid CREATE MATERIALIZED VIEW command

1 2993

ORA-12067: empty refresh groups are not allowed

1 2980

ORA-12068: updatable mview log for mview "string"."string" does not exist

1 3232

ORA-12069: invalid object for offline instantiation

1 3004

ORA-12070: cannot offline instantiate materialized view "string"."string"

1 4319

ORA-12071: definition query of "string"."string" is invalid for offline instantiation

1 3562

ORA-12072: updatable materialized view log data for "string"."string" cannot be created

1 3117

ORA-12073: request cannot be processed

1 2968

ORA-12074: invalid memory address

1 3410

ORA-12075: invalid object or field

1 4918

ORA-12076: invalid threshold value

1 3362

ORA-12077: temporary updatable materialized view log does not exist

1 2961

ORA-12078: fast refresh of refresh group ID string failed

1 3006

ORA-12079: materialized view options require COMPATIBLE parameter to be string or greater

1 3246

Un-Answered Questions { Database Errors }

What is the use of NOLOCK locking hint?

1837

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

2764

ORA-26094: stream format error: input column overflow

2859

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

2792

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

2506

ORA-26029: index string.string partition string initially in unusable state

2246

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2703

ORA-26030: index string.string had string partitions made unusable due to:

1994

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

6725

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.

2949

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.

2589

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2524

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3234

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

2193

NZE-28890: Entrust Login Failed

1943

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