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-16614: object has an ancestor that is disabled

1 4091

ORA-16617: unknown object identifier specified in request

1 4480

ORA-16618: response document of size "string" bytes is too large

1 2879

ORA-16619: Health Check timed out

1 4078

ORA-16620: one or more databases could not be contacted for a delete operation

1 3721

ORA-16621: Database name for ADD DATABASE must be unique.

1 3540

ORA-16622: Two or more broker database objects resolve to one physical database.

1 2780

ORA-16623: stale DRC UID sequence number detected

1 4477

ORA-16624: broker protocol version mismatch detected

1 7502

ORA-16625: cannot reach the primary

1 11033

ORA-16626: failed to enable specified object

2218

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

Oracle,

3991

ORA-16628: The broker protection mode is inconsistent with the database setting.

1 4956

ORA-16629: Database reports a different protection level from the protection mode.

2 22348

ORA-16630: That database property was deprecated.

1 2872

Un-Answered Questions { Database Errors }

What is the use of NOLOCK locking hint?

1784

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

2432

ORA-16626: failed to enable specified object

2218

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1677

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

3156

What severity level errors are managed in TRY-CATCH block?

2223

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

2155

ORA-26028: index string.string initially in unusable state

3862

ORA-26095: unprocessed stream data exists

3563

How to view the error log for any specific instance?

2486

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2212

what is the instrument that used in Mechanical Energy??

2680

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2799

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

1941

what is new g/l functionality

2611

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