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-14066: illegal option for a non-partitioned index-organized table

1 4863

ORA-14067: duplicate TABLESPACE_NUMBER specification

1 3022

ORA-14068: TABLESPACE and TABLESPACE_NUMBER may not be both specified

1 3154

ORA-14069: invalid TABLESPACE_NUMBER value

1 2788

ORA-14070: option may be specified only for partitioned indices or with REBUILD

1 3004

ORA-14071: invalid option for an index used to enforce a constraint

1 5583

ORA-14072: fixed table may not be truncated

1 3162

ORA-14073: bootstrap table or cluster may not be truncated

1 3264

ORA-14074: partition bound must collate higher than that of the last partition

1 5961

ORA-14075: partition maintenance operations may only be performed on partitioned indices

1 6298

ORA-14076: submitted alter index partition/subpartition operation is not valid for local partitioned index

2 7015

ORA-14078: you may not drop the highest partition of a GLOBAL index

1 2941

ORA-14079: illegal option for a partition marked Index Unusable

1 3233

ORA-14080: partition cannot be split along the specified high bound

1 5391

ORA-14081: new partition name must differ from the old partition name

1 2952

Un-Answered Questions { Database Errors }

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

2807

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

2670

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.

2810

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

2229

[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

2733

What is the use of NOLOCK locking hint?

1788

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?

2723

ORA-26032: index string.string loading aborted after string keys

2112

What is Mutex error in Triggers?

3076

what is new g/l functionality

2622

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

3993

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2459

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.

2540

How to view the error log for any specific instance?

2490

IMP-00064: Definition of LOB was truncated by export

6420

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