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-00716: Attribute/method 'string' can occur only once in an ALTER TYPE statement

1 3034

PLS-00717: method 'string' does not have matching signature among existing methods

1 3570

PLS-00718: type of attribute 'string' does not allow modifications to the attribute

1 3227

PLS-00719: only widening of attribute 'string' constraints is allowed

1 4172

PLS-00720: type 'string' has evolved

1 3769

PLS-00721: 'string' formed a non-REF mutually-dependent cycle with 'string'

1 2941

PLS-00722: supertypes's AUTHID is different than subtype's AUTHID

1 3578

PLS-00725: type 'string' must be a supertype or subtype of the TREAT expression

1 5365

PLS-00726: MODIFY ELEMENT is supported only on schema-level varray and nested tables

1 2974

PLS-00727: MODIFY LIMIT is supported only on schema-level varray types

1 3098

PLS-00728: the limit of a VARRAY can only be increased and to a maximum 2147483647

1 3894

PLS-00729: only widening of the collection element type is allowed

1 3289

PLS-00730: collection element type does not allow modifications

1 3088

PLS-00731: ALTER TYPE is supported only on schema-level types

1 2632

PLS-00732: Illegal overload of ellipsis in formal parameter list

1 3253

Un-Answered Questions { Database Errors }

ORA-26027: unique index string.string partition string initially in unusable state

6794

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

2502

How to view the error log for any specific instance?

2546

How will you Handle Error in SQL SERVER 2008?

2446

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.

2948

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

2716

NZE-28868: Peer certificate chain check failed.

2868

What is Mutex error in Triggers?

3131

what is the instrument that used in Mechanical Energy??

2743

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

8883

IMP-00070: Lob definitions in dump file are inconsistent with database.

1801

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

4042

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

2471

write a database figure to implement the master detained relationship.

3020

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

3716

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