Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z




HCL SQL Server Interview Questions
Questions Answers Views Company eMail

What is SQL server agent?

2 6375

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 16984

Difference between Cluster and Non-cluster index?

32 125499

Rate yourself in .NET and SQL ?

1 6068

What are the steps you will take to improve performance of a poor performing query?

1 8403





What are the steps you will take, if you are tasked with securing an SQL Server?

1 5730

What is blocking and how would you troubleshoot it?

3 4848

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 8011

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 6233

What are statistics, under what circumstances they go out of date, how do you update them?

2 6449

What are the different ways of moving data/databases between servers and databases in SQL Server?

3 11665

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 7654

What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 20867

How to determine the service pack currently installed on SQL Server?

4 6968

Can you have a nested transaction?

4 8258

Post New HCL SQL Server Interview Questions




HCL SQL Server Interview Questions





Un-Answered Questions

Who were the fellow cosmonauts of rakesh sharma?

12


What is transfer learning ?

1


How do you get programmers to build testability support into their code?

1560


what is earliest retroactive accounting period

30


What is ADFS authentication?

15






Differentiate between ad-hoc and infrastructure topology and also explain with their advantages and disadvantages?

13


If a plane is in the air and there is a fly flying inside the plane does the plane get heavier when the fly lands?

13


explain the difference between operator overloading and function overloading.

33


Explain the difference between local and central version operating modes?

7


How to use file based sessions?

1


What is the second largest land carnivore?

1212


Why bytecode cannot be run in android?

4


How do you script a nested loop in QTP? I am showing a snipet of my code. Any suggestions to help me get this to work would be great appreciated! STEP A - Customer Number: No loop - ISBN: Loop STEP B - Customer Number: Loop - ISBN: Nested Loop Here is the code I am using now. I am using i for the loop and j for the nested loop in STEP B of my script. =========================================== 'CREATE AN ADDITIONAL CUSTOMER Dim myNum, RowNum, RowCnt2, val2, total, i DataTable.ImportSheet "C:\QOE Data - UAT1.xls" ,"Data" ,"Global" RowCnt2 = DataTable.GetRowCount i = 1 DataTable.SetCurrentRow(i) ' Set row to one Do while Not i > RowCnt2 i=i+1 DataTable.SetNextRow MsgBox Datatable.Value("Customer_Num") Msgbox i Msgbox RowCnt2 If Not i > RowCnt2 then val2=datatable.Value("Customer_Num","Global") OracleFormWindow("Sales Order").SelectMenu "File->New" OracleFormWindow("Sales Order").OracleTabbedRegion("Order Information").OracleTextField("Customer Number").SetFocus OracleFormWindow("Sales Order").OracleTabbedRegion("Order Information").OracleTextField("Customer Number").Enter val2 End If 'CREATE SECOND ISBN LIST DataTable.ImportSheet "C:\QOE Data - UAT1.xls" ,"Data" ,"Global" Dim j, RowCnt3, val3 RowCnt3 = DataTable.GetRowCount For j = 1 To RowCnt3 DataTable.SetCurrentRow(i) ' datatable.getSheet("DataTable").setNextRow If Trim(DataTable("ISBN",dtGlobalSheet)) = "" Then j = j - 1 Exit For End If Next 'Define ISBN rows If RowCnt3 <> j Then RowCnt3 = j End If 'Loop through ISBN rows For j = 1 To RowCnt3 DataTable.SetCurrentRow(i) val3 = Datatable.Value("ISBN","Global") msgbox j If j = 1 Then OracleFormWindow("Sales Order").OracleTabbedRegion("Line Items").OracleTextField("Ordered Item").SetFocus OracleFormWindow("Sales Order").OracleTabbedRegion("Line Items").OracleTextField("Ordered Item").Enter val3 else If j < 16 Then OracleFormWindow("Sales Order").OracleTabbedRegion("Line Items").OracleTextField("Ordered Item_"&i).SetFocus OracleFormWindow("Sales Order").OracleTabbedRegion("Line Items").OracleTextField("Ordered Item_"&i).Enter val3 else If RowCnt1 => 16 Then OracleFormWindow("Sales Order").OracleTabbedRegion("Line Items").OracleTextField("Ordered Item_15").SetFocus OracleFormWindow("Sales Order").OracleTabbedRegion("Line Items").OracleTextField("Ordered Item_15").InvokeSoftkey "DOWN" OracleFormWindow("Sales Order").OracleTabbedRegion("Line Items").OracleTextField("Ordered Item_15").SetFocus OracleFormWindow("Sales Order").OracleTabbedRegion("Line Items").OracleTextField("Ordered Item_15").Enter val3 end if end if End If Next 'EXIT APP msgbox i loop Browser("Browser").Page("Oracle Applications 11i").Sync Browser("Browser").Close ========================================== It isn't working correctly in my nested loop in STEP B (for ISBN). Any ideas?? Thanks! SBsteve

5708


What is the difference between a standard controller and a custom controller? : salesforce crm

3


How to write business scripts using object repository with different scenarios

793