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-26721: enqueue of the LCR not allowed

1 2826

ORA-26723: user "string" requires the role "string"

1 3341

ORA-26724: only SYS is allowed to set the Capture or Apply user to SYS.

1 2679

ORA-26725: cannot downgrade apply handlers

1 2943

ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer

1 9360

ORA-27001: unsupported device type

1 6433

ORA-27002: function called with invalid device structure

1 4095

ORA-27003: cannot open file on device allocated with NOIO option

1 3162

ORA-27004: invalid blocksize specified

1 3125

ORA-27005: cannot open file for async I/O on device not supporting async

1 2792

ORA-27006: sbtremove returned error

1 3376

ORA-27007: failed to open file

1 3381

ORA-27008: function called with invalid file structure

1 3124

ORA-27009: skgfwrt: cannot write to file opened for read

1 4310

ORA-27010: skgfwrt: write to file failed

1 4208

Un-Answered Questions { Database Errors }

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

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

1994

NZE-28890: Entrust Login Failed

1944

why we are using shift key in unix shell script

3243

RMAN-05017: no copy of datafile number found to recover

2476

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

2196

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

3924

What is the meaning of lock escalation and why/how to stop this?

2718

ORA-26094: stream format error: input column overflow

2859

When do you get "getwmicomexception"?

2737

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

2726

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

1740

write a database figure to implement the master detained relationship.

3026

what is the instrument that used in Mechanical Energy??

2755

ORA-26095: unprocessed stream data exists

3651

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