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-00060: Both CURSOR and STATEMENT have AT clauses at line number of file string.

1 3254

PCC-00061: Error at line number, column number. PLS-number: string

1 3009

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

1 5589

PCC-00063: Reached end of file string before End-of-Statement at line number!

1 3671

PCC-00064: All uses of a given host variable must use identical indicator variables.

1 2783

PCC-00065: Userid required, but not specified.

1 2949

PCC-00066: Userid only used when SQLCHECK = FULL, userid ignored.

1 3279

PCC-00067: Ireclen exceeded. Line number in file string truncated.

1 3339

PCC-00068: Host and indicator variables may not have the same name.

1 2699

PCC-00069: Host variable "string" has unsupported datatype at line number in file string

1 3421

PCC-00070: Illegal syntax, Exponential value in SQL statement: string

1 3554

PCC-00071: Unable to open message file.

1 2879

PCC-00072: Input file name length exceeds the maximum length

1 3041

PCC-00073: Cursor is declared but never OPENed at line number in file string.

1 2713

PCC-00075: ":" expected before indicator variable

1 3124

Un-Answered Questions { Database Errors }

What is the use of NOLOCK locking hint?

1783

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

2443

How will you Handle Error in SQL SERVER 2008?

2401

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

2798

what is new g/l functionality

2610

ORA-26084: direct path context already finished

1947

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

2211

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

2410

ORA-26029: index string.string partition string initially in unusable state

2154

ORA-26095: unprocessed stream data exists

3559

What is the meaning of lock escalation and why/how to stop this?

2648

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

3152

What is Mutex error in Triggers?

3062

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2729

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

2800

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