ERRORS Interview Questions
Questions Answers Views Company eMail

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

1 1166

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


What are row constructors?

1 1561

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


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


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


On which table the SSIS SQL Server logs are stored?

1 1859

Difference between Bookmark lookup & RID lookup?

1 2730

How will you Handle Error in SQL SERVER 2008?


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


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


Does DBCC CHECKDB requires DB to be in SINGLE_USER mode?


2 1237

How to view the error log for any specific instance?


When do you get "getwmicomexception"?


Why are memory errors hard to debug?

1 2144

Un-Answered Questions { ERRORS }

What is the difference between return code and completion code. When i was searching in the direct for the problem, the following errors displayed. Please can any1 explain these. Completion Code => 4 Message Id => XXDR012I Short Text => XDR field overflow. Key=SER. Len=8. Completion Code => 8 Message Id => XSQF009I Short Text => Sys call open() failed.Filename=/opt/apps/cdt3/USA/outbound/CD810O.errno=17. Completion Code => 8 Message Id => XCPR010I Short Text => Open failed for copy in OPEN_DEST_DATA. Errno=17. can you explain those 3 completion codes and also with difference between return code and completion code


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


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


When do you get "getwmicomexception"?


if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires


I am using Qt 5.6 during compilation it stops and gives error about Qmake The process "C:QtQt5." crashed. Error while building/deploying project untitled1 (kit: Desktop Qt 5.6.3 MSVC2015 64bit) When executing step "qmake"


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


ORA-26076: cannot set or reset value after direct path structure is allocated


today's peformance is less than took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql


Jetking is C C


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


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


My question is in FLASH I will take 10 or 5 questions and last I will give my username and password and also I will give score to the answers which user submitted and that too the score and details of of the user should come in separate file, this entire thing should be done in Flash only. Is it possibe?


I have written the code as below. here problem is that dt remain null. how to solve thst please tell me. public partial class Form1 : Form { private DataTable DTable; private DataRow drow; public Form1() { InitializeComponent(); } private OleDbConnection getConnection() { OleDbConnection con=new OleDbConnection (@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\winApp for Student\winApp for Student\App_Data\SchooMgnSystem.mdb;Persist Security Info=True"); return con; } private void button1_Click(object sender, EventArgs e) { InsertData(); } private void InsertData() { if (DTable==null) { DTable = new DataTable(); DTable.Columns.Add("StudID", typeof(string)); DTable.Columns.Add("StudName", typeof (string)); DTable.Columns.Add("Address", typeof(string)); drow = DTable.NewRow(); drow[0] = txtStudID.Text; drow[1] = txtSTudName.Text; drow[2] = txtAddress.Text; DTable.Rows.Add(drow); grdStudent.DataSource = DTable; } else { drow = DTable.NewRow(); drow[0] = txtStudID.Text; drow[1] = txtSTudName.Text; drow[2] = txtAddress.Text; DTable.Rows.Add(drow); grdStudent.DataSource = DTable; } } private void button2_Click(object sender, EventArgs e) { string cmdstr; OleDbCommand cmd; OleDbConnection con = getConnection(); foreach (DataRow Drow in DTable.Rows) { cmdstr = "Insert into Student values('" + drow[0].ToString() + "','" + drow[1].ToString() + "','"+drow [2].ToString()+"')"; cmd = new OleDbCommand(cmdstr,con); try { con.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } } }


Write down the difference between c. Loop and goto statement d. (!0) and (!1) e. (1= =! 1) and (1!=1) f. NULL and !NULL