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 2810

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

1 2723

PLS-00614: creating a FINAL NOT INSTANTIABLE type

1 3680

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

1 6648

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

1 3976

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

1 3533

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

1 3188

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

1 3204

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

1 3175

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

1 3348

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

1 3181

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

1 3186

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

1 2865

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

1 3124

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

1 3153

Un-Answered Questions { Database Errors }

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

3666

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

2410

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

2662

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.

2532

When do you get "getwmicomexception"?

2680

ORA-16626: failed to enable specified object

2218

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

2639

NZE-28890: Entrust Login Failed

1879

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2520

IMP-00064: Definition of LOB was truncated by export

6413

NZE-28868: Peer certificate chain check failed.

2799

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?

2721

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2799

ORA-16516: The current state is invalid for the attempted operation.

8818

hp asking for replication floppy to do reinstall 25254 server assistant

2880

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