Tag: technology

Questions Related to technology

Identify the issues in the code below 

Set con = CreateObject("ADODB.Connection") 
con.Open "Provider=Microsoft.ACE.OLEDB.12.0;
Data source=C:\...\Database1.accdb" 
rs = con.Execute("select * from Table1") 
rs.MoveFirst 
Do While rs.EOF     
    Msgbox rs.Fields(0).Name & " : " &rs.Fields(0).Value & " " & rs.Fields(1).Name & " : " &rs.Fields(1).Value & " " & rs.Fields(2).Name & " : " & rs.Fields(2).Value  
Loop 
rs.Close 
con.Close

Issue1) SQL query is issued as an argument to an incorrect method Issue2) Condition with the loop is incorrect Issue3) Code is not designed navigate to the next record in the recordset Issue4) Connection string is incorrectly formed Issue5) Msgbox cannot display data from Database Issue6) Set keyword is missing in a statement
technology testing

  1. Issue2, Issue3, Issue6

  2. Issue1, Issue2, Issue3

  3. Issue2, Issue4, Issue6

  4. No issues - The code is perfect

Show answer
Correct Option: A

What is the method used to get the root element of an xml document

technology testing

  1. RootElement

  2. GetRootItem

  3. GetRootNode

  4. GetRootElement

Show answer
Correct Option: D

What does the ChildElements method of XMLUtil returns?
technology testing

  1. collection having child nodes/elements

  2. a node/child

  3. true if there are children and false if no children

  4. root node

Show answer
Correct Option: A

What is the indexed property used to retrieve child nodes from a collection?

technology testing

  1. collection_obj.element(0)

  2. collection_obj.Item(0)

  3. collection_obj.node(0)

  4. No such property

Show answer
Correct Option: B

Predict the output of the following script the uses the below xml




      Rajesh
      111
      CS
      A


      Meera
      222
      Maths
      B


      Aarthi
      333
      Commerce
      C



Set xmlDoc = XMLUtil.CreateXMLFromFile("C:\...\students.xml") 
Set rt  = xmlDoc.GetRootElement 
Set rtChildColl = rt.ChildElements 
Set node = rtChildColl.Item(rtChildColl.Count) 
set nodeAtt = node.ChildElements 
Msgbox nodeAtt.Item(1).Value
technology testing

  1. 222

  2. A

  3. No value. It returns an empty string

  4. Aarthi

Show answer
Correct Option: D

Recovery scenario takes us thru the following wizard steps in the following sequence

technology testing

  1. define a trigger, define the recovery operations, define the post recovery operations

  2. define the recovery operations, define a trigger, define the post recovery operations

  3. can be created in any order

  4. no such wizard is available in Quick Test

Show answer
Correct Option: A

T-code to reduce an IDoc ?
technology programming languages

  1. WE30

  2. WE31

  3. BD53

  4. BD64

Show answer
Correct Option: C

Which FM is used for dynamic selection screens
technology programming languages

  1. DYNAMIC_SEARCH_PARTNER

  2. FREE_SELECTIONS_INIT

  3. DYNAMICALLY_CREATE_ML_DATA

  4. DYNAMIC_MENUE

Show answer
Correct Option: B

GETCURSOR is used to trace the data on double click of a field in the list
technology programming languages

  1. True

  2. False

Show answer
Correct Option: A

T-code for enhancement in SAP
technology programming languages

  1. CMOD

  2. SMOD

  3. SM35

  4. SPROXY

Show answer
Correct Option: A