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?

992

What are row constructors?

1 1561




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

1151

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

1497

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

1157

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?

1119

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

1365

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

1239

Does DBCC CHECKDB requires DB to be in SINGLE_USER mode?

TCS,

2 1237

How to view the error log for any specific instance?

1190

When do you get "getwmicomexception"?

1312

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

6598


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

1069


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

1137


When do you get "getwmicomexception"?

1312


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

1527






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

128


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

1206


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

774


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

1227


Jetking is C C

1152


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

5224


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

1669


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?

1287


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(); } } }

1427


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

2425