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

Database Errors Interview Questions

Questions Answers Views Company eMail

EXP-00042: Missing NLS_CHARACTERSET/NLS_NCHAR_CHARACTERSET in props$

1 4574

EXP-00043: Invalid data dictionary information in the row where column "string" is "string" in table string

1 2690

EXP-00044: must be connected 'AS SYSDBA' to do Point-in-time Recovery or Transportable Tablespace import

2 8656

EXP-00045: Cannot export SYSTEM Tablespace for Point-in-time Recovery or Transportable Tablespace

1 3124

EXP-00046: Tablespace named string does not exist

1 3567

EXP-00047: Missing tablespace name(s)

1 3421

EXP-00048: Cannot export SYSAUX Tablespace for Point-in-time Recovery or Transportable Tablespace

1 3624

EXP-00049: %s option is not compatible with Point-in-time Recovery or Transportable Tablespace Export

1 2737

EXP-00050: Cannot perform Partition Export "string" on non-partitioned table "string"

1 3071

EXP-00051: "string" - given partition or subpartition name is not part of "string" table

1 4849

EXP-00052: error on row number of partition string

1 3071

EXP-00053: unable to execute QUERY on table string because the table has inner nested tables

1 3067

EXP-00054: error on row number of subpartition string

1 3336

EXP-00055: %s.string is marked not exportable

1 5835

EXP-00057: Failure to initialize parameter manager

1 2937

Un-Answered Questions { Database Errors }

why we are using shift key in unix shell script

3165

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

2434

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

2597

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

2662

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

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

2452

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.

2802

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

2521

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2802

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

1618

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

6652

write a database figure to implement the master detained relationship.

2936

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

2410

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

2212

NZE-28890: Entrust Login Failed

1882

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