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

Database Errors Interview Questions

Questions Answers Views Company eMail

PCB-00005: Command line option MODE=ANSI required with option NLS_LOCAL=YES

1 3184

PCB-00006: Userid only used when SQLCHECK=FULL, userid ignored.

1 2979

PCB-00007: %s

1 2651

PCB-00008: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL

1 5178

PCB-00009: Cannot change MAXLITERAL after an EXEC SQL statement

1 2978

PCB-00010: SQLCHECK value in EXEC ORACLE statement exceeds command line value

1 3929

PCB-00011: DBMS=V6 no longer supported; using DBMS=NATIVE

1 2753

PCB-00012: Command line option DYNAMIC=ANSI required with option TYPE_CODE=ANSI

1 3087

PCB-00100: Unable to reopen temporary file string

1 3184

PCB-00101: Could not find or open system configuration file

1 3434

PCB-00102: Input file name length exceeds the maximum length

1 2941

PCB-00104: Unable to open input file "string"

1 2755

PCB-00105: Included file name "string" exceeds name limit of number characters

1 3380

PCB-00106: Unable to open INCLUDE file "string"

1 4894

PCB-00108: Unable to open list file "string"

1 3013

Un-Answered Questions { Database Errors }

What is the use of NOLOCK locking hint?

1788

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6653

[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

2731

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

2232

NZE-28890: Entrust Login Failed

1882

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

2643

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

2225

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

3993

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-26095: unprocessed stream data exists

3578

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

2705

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

2455

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3171

What is live lock, deadlock and what is Lock escalation?

2434

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2522

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