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-01541: system tablespace cannot be brought offline; shut down if necessary

1 8057

ORA-01542: tablespace 'string' is offline, cannot allocate space in it

1 9219

ORA-01543: tablespace 'string' already exists

1 17469

ORA-01544: cannot drop system rollback segment

1 4066

ORA-01545: rollback segment 'string' specified not available

1 4942

ORA-01546: tablespace contains active rollback segment 'string'

1 4500

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

1 10032

ORA-01548: active rollback segment 'string' found, terminate dropping tablespace

1 3925

ORA-01549: tablespace not empty, use INCLUDING CONTENTS option

1 10670

ORA-01550: cannot drop system tablespace

1 5395

ORA-01551: extended rollback segment, pinned blocks released

1 4879

ORA-01552: cannot use system rollback segment for non-system tablespace 'string'

1 3910

ORA-01553: MAXEXTENTS must be no smaller than the string extents currently allocated

1 3674

ORA-01554: out of transaction slots in transaction tables

1 8387

ORA-01555: snapshot too old: rollback segment number string with name "string" too small

1 3837

Un-Answered Questions { Database Errors }

NZE-28890: Entrust Login Failed

1932

why we are using shift key in unix shell script

3239

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

2868

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

How will you Handle Error in SQL SERVER 2008?

2446

ORA-26084: direct path context already finished

2001

ORA-26027: unique index string.string partition string initially in unusable state

6794

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

6723

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

2789

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

2761

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

2701

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

1990

ORA-26094: stream format error: input column overflow

2859

NZE-28868: Peer certificate chain check failed.

2868

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.

2584

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