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

Database Errors Interview Questions

Questions Answers Views Company eMail

PLS-00627: 'string' must be a strongly typed ref cursor

1 3971

PLS-00628: 'string' must be a valid record attribute

1 2969

PLS-00629: PIPE statement cannot be used in non-pipelined functions

1 10341

PLS-00630: pipelined functions must have a supported collection return type

2 13874

PLS-00631: PARTITION-BY and CLUSTER/ORDER-BY clauses must be used with the same function argument

1 2949

PLS-00632: NOT INSTANTIABLE method cannot have a body

1 3098

PLS-00633: RETURN statement in a pipelined function cannot contain an expression

1 6014

PLS-00634: type with NOT INSTANTIABLE methods must be declared NOT INSTANTIABLE

1 4602

PLS-00635: method does not override

1 4884

PLS-00636: overriding method requires OVERRIDING keyword

1 3875

PLS-00637: FINAL method cannot be overriden or hidden

1 2877

PLS-00638: cannot overload MAP method

1 2886

PLS-00639: NCHAR/NVARCHAR2 cannot be byte length semantics

1 3575

PLS-00640: a pipelined function cannot be called from PL/SQL context

1 2927

PLS-00641: INTO clause not allowed for this SELECT statement

1 2913

Un-Answered Questions { Database Errors }

ORA-26030: index string.string had string partitions made unusable due to:

1994

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

3234

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

4045

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1710

What is Mutex error in Triggers?

3140

How will you Handle Error in SQL SERVER 2008?

2454

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

What is the use of NOLOCK locking hint?

1837

How to view the error log for any specific instance?

2548

what is the instrument that used in Mechanical Energy??

2754

why we are using shift key in unix shell script

3243

hp asking for replication floppy to do reinstall 25254 server assistant

2973

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

8891

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.

2949

what is new g/l functionality

2683

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