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-16792: Some configurable property value is inconsistent with the database setting.

1 5571

ORA-16793: Logical Standby Database Guard is unexpectedly OFF

1 3890

ORA-16794: Database Guard is ON for primary database

1 4536

ORA-16795: Database resource guard detects that database reinstantiation is required

1 7237

ORA-16796: One or more properties could not be imported from the database.

2 12571

ORA-16797: SPFILE is missing in the Data Guard broker environment

1 15283

ORA-16798: Unable to complete terminal recovery on the standby

1 4266

ORA-16799: Physical apply service is offline

1 3104

ORA-16800: Log transport service for some database is incorrectly set to ALTERNATE.

1 3805

ORA-16801: Some log transport related property is inconsistent.

1 7335

ORA-16802: downgrading log transport mode from SYNC disallowed

1 2953

ORA-16803: Unable to query a database table or fixed view.

2 11017

ORA-16804: One or more configuration properties in metadata have invalid values.

1 2868

ORA-16805: Change of LogXptMode property violates overall protection mode.

1 3378

ORA-16806: Supplemental logging is not turned on.

1 4390

Un-Answered Questions { Database Errors }

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2300

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.

2857

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

8885

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2701

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

1801

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

2524

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

2036

IMP-00064: Definition of LOB was truncated by export

6473

write a database figure to implement the master detained relationship.

3020

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

2270

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

2761

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

2868

ORA-26095: unprocessed stream data exists

3644

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

4042

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

1671

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