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-00106: cannot startup/shutdown database when connected to a dispatcher

1 4448

ORA-00107: failed to connect to ORACLE listener process

1 4461

ORA-00108: failed to set up dispatcher to accept connection asynchronously

1 7844

ORA-00109: invalid value for attribute string: string

1 4116

ORA-00110: invalid value string for attribute string, must be between string and string

1 3710

ORA-00111: invalid attribute string

1 4452

ORA-00112: value of string is null

1 3716

ORA-00113: protocol name string is too long

1 4223

ORA-00114: missing value for system parameter SERVICE_NAMES

1 3398

ORA-00115: connection refused; dispatcher connection table is full

1 3886

ORA-00116: SERVICE_NAMES name is too long

1 3674

ORA-00117: PROTOCOL, ADDRESS or DESCRIPTION must be specified

1 3503

ORA-00118: Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified

1 3435

ORA-00119: invalid specification for system parameter string

1 3833

ORA-00122: cannot initialize network configuration

1 3758

Un-Answered Questions { Database Errors }

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

2300

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 ??

1736

ORA-16516: The current state is invalid for the attempted operation.

8883

ORA-16626: failed to enable specified object

2278

ORA-26084: direct path context already finished

2000

When do you get "getwmicomexception"?

2735

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

3916

NZE-28868: Peer certificate chain check failed.

2868

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2768

why we are using shift key in unix shell script

3238

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

2722

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

2502

ORA-26094: stream format error: input column overflow

2859

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

2523

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

6722

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