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-00612: Number of attributes do not match in SET clause

1 2911

PLS-00613: only one item is allowed, when using variables of record type

1 2801

PLS-00614: creating a FINAL NOT INSTANTIABLE type

1 3750

PLS-00615: type mismatch found at 'string' between CASE operand and WHEN operands

1 6763

PLS-00616: type mismatch found at 'string' among result expressions in a CASE expression

1 4088

PLS-00617: at least one result in the CASE expression must not be NULL

1 3643

PLS-00618: type mismatch found at 'string' between operands in a NULLIF expression

1 3296

PLS-00619: the first operand in the NULLIF expression must not be NULL

1 3282

PLS-00620: type mismatch found at 'string' among operands in a COALESCE expression

1 3240

PLS-00621: at least one operand in the COALESCE expression must not be NULL

1 3428

PLS-00622: range constraints must be between -2147483647 and 2147483647

1 3263

PLS-00623: FLOAT precision constraint must be between 1 and 126

1 3308

PLS-00624: USING clause must be used with either aggregate or pipelined functions

1 2964

PLS-00625: PARTITION/CLUSTER/ORDER-BY clause can only be used with IN parameters

1 3210

PLS-00626: partitioned/clustered/ordered parameter must be a function argument

1 3259

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

6722

What is the use of NOLOCK locking hint?

1837

IMP-00064: Definition of LOB was truncated by export

6473

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.

2582

NZE-28868: Peer certificate chain check failed.

2868

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

2722

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

2716

what is new g/l functionality

2681

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

ORA-26076: cannot set or reset value after direct path structure is allocated

2035

hp asking for replication floppy to do reinstall 25254 server assistant

2968

What is Mutex error in Triggers?

3130

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

2471

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

3916

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

1990

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