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-14163: subpartition number string: INITRANS value must be less than MAXTRANS value

1 2989

ORA-14164: subpartition "string": INITRANS value must be less than MAXTRANS value

1 2949

ORA-14165: MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations

1 4031

ORA-14166: missing INTO keyword

1 3184

ORA-14167: only one subpartition may be moved

1 3404

ORA-14168: only one subpartition may be modified

1 2854

ORA-14169: invalid ALTER TABLE MODIFY SUBPARTITION option

1 5636

ORA-14170: cannot specify clause in CREATE TABLE|INDEX

1 3985

ORA-14171: cannot specify clause in CREATE|ALTER TABLE

1 3452

ORA-14172: invalid ALTER TABLE EXCHANGE SUBPARTITION option

1 4118

ORA-14173: illegal subpartition-extended table name syntax

1 4416

ORA-14174: only a may follow COALESCE PARTITION|SUBPARTITION

1 3982

ORA-14175: a subpartition maintenance operation may not be combined with other operations

1 4823

ORA-14176: this attribute may not be specified for a hash partition

1 4808

ORA-14177: STORE-IN (Tablespace list) can only be specified for a LOCAL index on a Hash or Composite Range Hash table

1 3523

Un-Answered Questions { Database Errors }

NZE-28868: Peer certificate chain check failed.

2807

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

3180

How to view the error log for any specific instance?

2490

How will you Handle Error in SQL SERVER 2008?

2408

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.

1660

ORA-16626: failed to enable specified object

2225

what is new g/l functionality

2622

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

1973

IMP-00070: Lob definitions in dump file are inconsistent with database.

1752

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

2523

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

2412

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1687

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

2229

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

2810

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

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