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-16761: Resource guard could not stop logical apply engine

1 3210

ORA-16762: Invalid database state

1 3426

ORA-16763: log transport service for some standby database unexpectedly online

1 5459

ORA-16764: log tranport service for some standby database unexpectedly offline

1 5851

ORA-16765: Physical apply service unexpectedly online

1 6943

ORA-16766: Physical apply service unexpectedly offline

1 7872

ORA-16767: Logical apply service unexpectedly online

1 3143

ORA-16768: Logical apply service unexpectedly offline

1 5346

ORA-16769: The physical standby database is incorrectly put into read-only state.

1 3109

ORA-16770: physical standby database not in read-only state.

1 4470

ORA-16771: Converting physical standby to primary failed in the failover operation.

1 4119

ORA-16772: Error in switching over between primary and standby databases

1 6434

ORA-16773: Error in starting the physical apply service (MRP process)

1 4249

ORA-16774: Error in stopping the physical apply service (MRP process)

1 3227

ORA-16775: Target standby in switchover operation has missing redo logs.

1 8223

Un-Answered Questions { Database Errors }

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

2271

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

2237

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

2792

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

1740

what is the instrument that used in Mechanical Energy??

2745

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

3440

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

2474

what is new g/l functionality

2681

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2260

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.

2861

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

2762

What is the meaning of lock escalation and why/how to stop this?

2716

ORA-26094: stream format error: input column overflow

2859

ORA-26030: index string.string had string partitions made unusable due to:

1990

[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

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