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-00277: illegal option to the UNTIL recovery flag string

1 11603

ORA-00278: log file 'string' no longer needed for this recovery

1 4624

ORA-00279: change string generated at string needed for thread string

1 6269

ORA-00280: change string for thread string is in sequence #string

1 4500

ORA-00281: media recovery may not be performed using dispatcher

1 3548

ORA-00282: UPI string call not supported, use ALTER DATABASE RECOVER

1 3289

ORA-00283: recovery session canceled due to errors

1 10859

ORA-00284: recovery session still in progress

1 4094

ORA-00285: TIME not given as a string constant

1 4046

ORA-00286: no members available, or no member contains valid data

1 3206

ORA-00287: specified change number string not found in thread string

1 3556

ORA-00288: to continue recovery type ALTER DATABASE RECOVER CONTINUE

1 3715

ORA-00289: suggestion : string

1 4173

ORA-00290: operating system archival error occurred. See error below

1 3257

ORA-00291: numeric value required for PARALLEL option

1 3497

Un-Answered Questions { Database Errors }

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

hp asking for replication floppy to do reinstall 25254 server assistant

2969

[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

How to view the error log for any specific instance?

2546

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

1823

What is Mutex error in Triggers?

3132

ORA-26029: index string.string partition string initially in unusable state

2237

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

1736

write a database figure to implement the master detained relationship.

3020

ORA-26079: file "string" is not part of table string.string

2008

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

2723

ORA-26027: unique index string.string partition string initially in unusable state

6794

mount: mount to NFS server failed: System Error: Connection timed out

3716

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

2868

why we are using shift key in unix shell script

3239

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