Database Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Errors Interview Questions

Questions Answers Views Company eMail

PLS-00212: could not obtain enough memory to compile CASE statement

1 2704

PLS-00213: package STANDARD not accessible

1 3638

PLS-00214: BEGIN...END block nesting is too deep

1 3362

PLS-00215: String length constraints must be in range (1 .. 32767)

2 8257

PLS-00216: NUMBER precision constraint must be in range (1 .. 38)

1 7031

PLS-00217: NUMBER scale constraint must be in range (-84 .. 127)

1 3304

PLS-00218: a variable declared NOT NULL must have an initialization assignment

1 5374

PLS-00219: label 'string' reference is out of scope

1 2960

PLS-00220: simple name required in this context

1 5954

PLS-00221: 'string' is not a procedure or is undefined

1 9367

PLS-00222: no function with name 'string' exists in this scope

QuinStreet,

1 15263

PLS-00223: paramaterless procedure 'string' used as function

1 3586

PLS-00224: object 'string' must be of type function or array to be used this way

1 10329

PLS-00225: subprogram or cursor 'string' reference is out of scope

1 5259

PLS-00226: package 'string' used as variable reference

1 3811

Un-Answered Questions { Database Errors }

write a database figure to implement the master detained relationship.

3016

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

6794

How will you Handle Error in SQL SERVER 2008?

2446

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

1990

What is the use of NOLOCK locking hint?

1837

mount: mount to NFS server failed: System Error: Connection timed out

3709

IMP-00064: Definition of LOB was truncated by export

6473

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

2867

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

2269

ORA-26079: file "string" is not part of table string.string

2004

NZE-28890: Entrust Login Failed

1932

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

2522

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

2757

why we are using shift key in unix shell script

3237

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

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