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-16776: Health check of the log transport service failed.

1 3275

ORA-16777: unable to find the destination entry of a standby in V$ARCHIVE_DEST

1 5642

ORA-16778: log transport error for one or more databases

2 24119

ORA-16779: The destination parameter of some database has wrong syntax.

1 4110

ORA-16780: Destination to some database has used up its quota.

1 2990

ORA-16781: The status of log transport service for some database is unknown

1 3229

ORA-16782: some instance not open for read and write access

1 7907

ORA-16783: instance string not open for read and write access

1 4355

ORA-16784: The database object name given in property Dependency is incorrect.

1 2936

ORA-16785: The database is not in ARCHIVELOG mode

1 4047

ORA-16786: Resource guard cannot access Data Guard metadata

1 4734

ORA-16788: Unable to set one or more database configuration property values

1 3337

ORA-16789: Missing standby redo logs

1 5211

ORA-16790: The value of the configurable property is invalid

1 4925

ORA-16791: Unable to check the existence of the standby redo logs

1 2805

Un-Answered Questions { Database Errors }

How to view the error log for any specific instance?

2548

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

4045

hp asking for replication floppy to do reinstall 25254 server assistant

2973

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

2718

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

2246

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

[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

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

3720

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

2271

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

2037

What is the use of NOLOCK locking hint?

1837

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

8891

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

1675

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

2868

ORA-26095: unprocessed stream data exists

3651

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