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

Database Errors Interview Questions

Questions Answers Views Company eMail

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

Capita India Pvt Ltd,

2497

What is Mutex error in Triggers?

3006

What is the use of NOLOCK locking hint?

1722

What are the required/mandatory parameters that have to be passed with RAISEERROR statement?

1 3522

What severity level errors are managed in TRY-CATCH block?

2175

What are row constructors?

1 3837

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

2618

How many types of internal joins are there in SQL Server?

2818

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

2385

On which table the SSIS SQL Server logs are stored?

1 4071

Difference between Bookmark lookup & RID lookup?

1 4872

How will you Handle Error in SQL SERVER 2008?

2351

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

2606

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

2474

Does DBCC CHECKDB requires DB to be in SINGLE_USER mode?

TCS,

2 3675

Un-Answered Questions { Database Errors }

ORA-26028: index string.string initially in unusable state

3813

write a database figure to implement the master detained relationship.

2890

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

2746

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2577

why we are using shift key in unix shell script

3088

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

2177

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

2689

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

2618

What severity level errors are managed in TRY-CATCH block?

2175

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?

2674

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

2405

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3327

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1631

How will you Handle Error in SQL SERVER 2008?

2351

What is the use of NOLOCK locking hint?

1722

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