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-00642: local collection types not allowed in SQL statements

1 10479

PLS-00643: booleans, index tables, records and cursors not allowed in SQL statements

1 2759

PLS-00644: character set mismatch found at 'string' among result expressions in a CASE expression

1 2872

PLS-00645: character set mismatch found at 'string' among operands in a COALESCE expression

1 2851

PLS-00646: MAP or ORDER method must be defined in the root of the subtype hierarchy

1 4181

PLS-00647: attribute by name "string" conflicts with method by same name

1 2673

PLS-00648: type of supertype attribute "string" can not be a subtype or reference to a subtype in this release

1 3123

PLS-00649: method "string" can be overridden only once per object type

1 3381

PLS-00650: invalid type for PARTITION/CLUSTER/ORDER BY clause

1 3299

PLS-00651: implementation type in Aggregate/Table function should be a valid type

1 2885

PLS-00652: aggregate functions should have exactly one argument

1 5576

PLS-00653: aggregate/table functions are not allowed in PL/SQL scope

1 18073

PLS-00654: PARTITION/ORDER/CLUSTER BY are allowed for only with PARALLEL_ENABLE

1 3205

PLS-00655: only functions can be declared as PIPELINED

1 2924

PLS-00656: field 'string' not available in input argument

1 6289

Un-Answered Questions { Database Errors }

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3155

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

write a database figure to implement the master detained relationship.

2934

What is live lock, deadlock and what is Lock escalation?

2432

How to view the error log for any specific instance?

2486

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2723

How will you Handle Error in SQL SERVER 2008?

2401

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

2800

what is the instrument that used in Mechanical Energy??

2680

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2212

What is Mutex error in Triggers?

3064

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

3989

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3384

what is new g/l functionality

2611

why we are using shift key in unix shell script

3165

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