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-00398: wrong number of columns in UNION, INTERSECT, or MINUS expression

1 3224

PLS-00399: different types of columns in UNION, INTERSECT, or MINUS expression

1 3547

PLS-00400: different number of columns between cursor SELECT statement and return value

1 4767

PLS-00401: different column types between cursor SELECT statement and return value found at 'string'

1 3146

PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names

2 23668

PLS-00403: expression 'string' cannot be used as an INTO-target of a SELECT/FETCH statement

1 9323

PLS-00404: cursor 'string' must be declared with FOR UPDATE to use with CURRENT OF

1 5865

PLS-00405: subquery not allowed in this context

1 5318

PLS-00406: length of SELECT list in subquery must match number of assignment targets

1 3159

PLS-00407: '*' not allowed here; a list of columns is required

1 2857

PLS-00408: duplicate column 'string' not permitted in INSERT or UPDATE

1 3534

PLS-00409: duplicate variable 'string' in INTO list is not permitted

1 2823

PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted

1 14104

PLS-00411: Number of values in aggregate and in subquery don't match

1 3148

PLS-00412: list of values not allowed as argument to this function or procedure

1 5199

Un-Answered Questions { Database Errors }

ORA-26095: unprocessed stream data exists

3642

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 is the instrument that used in Mechanical Energy??

2737

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

4042

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

2269

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?

2767

hp asking for replication floppy to do reinstall 25254 server assistant

2967

IMP-00064: Definition of LOB was truncated by export

6473

ORA-26082: load of overlapping segments on table string.string is not allowed

1823

NZE-28868: Peer certificate chain check failed.

2868

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

6794

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

2758

why we are using shift key in unix shell script

3237

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

2786

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

6721

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