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

Database Errors Interview Questions

Questions Answers Views Company eMail

EXP-00075: rounding FILESIZE down, new value is string

1 3703

EXP-00076: multiple devices specified for tape output

1 3011

EXP-00077: multiple output files specified for unbounded export file

1 3505

EXP-00078: Error exporting metadata for index string. Index creation will be skipped

1 3917

EXP-00079: Data in table "string" is protected. Conventional path may only be exporting partial table.

1 5697

EXP-00080: Data in table "string" is protected. Using conventional mode.

1 2762

EXP-00081: Exporting access control for table/view "string" as non-DBA.

1 3356

EXP-00082: Invalid function name passed to procedural object support: string

1 2845

EXP-00083: The previous problem occurred when calling string.string.string

1 5292

EXP-00084: Unexpected DbmsJava error number at step number

1 3539

EXP-00085: The previous problem occurred when calling string.string.string for object number

1 4858

EXP-00086: Primary key REFs in table "string"may not be valid on import

1 2930

EXP-00087: Problem with internal hash table of schema/table names

1 3043

EXP-00089: invalid FILE_FORMAT specification

1 3108

EXP-00090: cannot pin type "string"."string"

1 4732

Un-Answered Questions { Database Errors }

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2701

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

1679

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

8820

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

2107

How will you Handle Error in SQL SERVER 2008?

2403

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

2662

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

1968

why we are using shift key in unix shell script

3165

How to view the error log for any specific instance?

2486

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

2733

ORA-26082: load of overlapping segments on table string.string is not allowed

1768

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

2802

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1618

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2870

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

2802

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