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

Database Errors Interview Questions

Questions Answers Views Company eMail

PCC-02112: OBJECTS option ignored. OBJECTS=YES is not allowed for DBMS=V6 or V7.

1 3065

PCC-02113: DBMS=V6 no longer supported; using DBMS=NATIVE, CHAR_MAP=VARCHAR2.

1 2825

PCC-02114: Command line argument MODE=ANSI may not be used with DBMS=V6

1 2947

PCC-02115: Unable to open output file for writing

1 3537

PCC-02116: You must specify a file extension using the HEADER option

1 3874

PCC-02129: CMD-LINE: Client supplied static options table is invalid

1 2761

PCC-02132: CMD-LINE: Could not allocate memory

1 2796

PCC-02133: CMD-LINE: Error in string processing function

1 2670

PCC-02134: CMD-LINE: Null option supplied

1 3222

PCC-02135: CMD-LINE: User asked for help

1 2869

PCC-02138: CMD-LINE: Internal consistency error

1 3139

PCC-02144: CMD-LINE: Blank characters are not allowed on either side of an equal sign (=)

1 8518

PCC-02150: Error at line number, column number in file string

1 2980

PCC-02151: Line number column number file string:

1 2937

PCC-02152: Unable to open file string to display or list the source line number

1 2916

Un-Answered Questions { Database Errors }

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

2298

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

2714

NZE-28890: Entrust Login Failed

1922

Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2661

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2760

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

3703

How will you Handle Error in SQL SERVER 2008?

2440

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.

2849

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

1999

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.

2945

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

2495

ORA-26095: unprocessed stream data exists

3638

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

1815

ORA-26032: index string.string loading aborted after string keys

2177

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

2253

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