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-24002: QUEUE_TABLE string does not exist

1 8504

ORA-24003: Queue table index string inconsistent with queue table string

1 7039

ORA-24004: invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY

1 4101

ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables

1 7017

ORA-24006: cannot create QUEUE, string already exists

1 5082

ORA-24007: invalid value string, MAX_RETRIES should be non-negative integer

1 3414

ORA-24008: queue table string.string must be dropped first

1 4988

ORA-24009: invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE

1 3101

ORA-24010: QUEUE string does not exist

1 14257

ORA-24011: cannot drop QUEUE, string should be stopped first

1 3806

ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped

1 5555

ORA-24013: invalid value string, RETRY_DELAY should be non-negative

1 3388

ORA-24014: invalid value string, RETENTION_TIME should be FOREVER or non-negative

1 3471

ORA-24015: cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist

1 6456

ORA-24016: cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_TYPE string.string

1 4255

Un-Answered Questions { Database Errors }

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2807

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

2733

hp asking for replication floppy to do reinstall 25254 server assistant

2886

ORA-26094: stream format error: input column overflow

2808

ORA-26082: load of overlapping segments on table string.string is not allowed

1768

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

2155

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2522

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

2434

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2233

What is the use of NOLOCK locking hint?

1788

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

6653

what is the instrument that used in Mechanical Energy??

2683

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

1620

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

2107

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

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