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

Database Errors Interview Questions

Questions Answers Views Company eMail

ORA-01922: CASCADE must be specified to drop 'string'

1 10711

ORA-01923: CASCADE aborted, objects locked by another user

1 3181

ORA-01924: role 'string' not granted or does not exist

1 8609

ORA-01925: maximum of string enabled roles exceeded

2 4171

ORA-01926: cannot GRANT to a role WITH GRANT OPTION

1 7732

ORA-01927: cannot REVOKE privileges you did not grant

1 7641

ORA-01928: GRANT option not granted for all privileges

1 3770

ORA-01929: no privileges to GRANT

1 11042

ORA-01930: auditing the object is not supported

1 3443

ORA-01931: cannot grant string to a role

1 6197

ORA-01932: ADMIN option not granted for role 'string'

1 13496

ORA-01933: cannot create a stored object using privileges from a role

1 3926

ORA-01934: circular role grant detected

1 7575

ORA-01935: missing user or role name

2 16104

ORA-01936: cannot specify owner when creating users or roles

1 10524

Un-Answered Questions { Database Errors }

How to view the error log for any specific instance?

2546

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

3229

IMG-02003: 2FF03 - incorrect color histogram feature specification

1769

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

3440

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.

2581

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

2787

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

2269

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

2588

[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

2779

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.

2856

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2866

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

3916

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1708

why we are using shift key in unix shell script

3237

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

2721

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