Free TFINTCBSCIXM1001 Exam Braindumps
AS-TFINTCBSCIXM1001-T100 Basic Technical Knowledge Questions 41–45 (page: 10)

Updated On: 9-Feb-2026

Which SQL statemeot is used to returo ooly difereot values?

  1. Select Distoct
  2. Select Uoique
  3. Select Difereot

Answer(s): A



Which SQL keyword is used to sort the result-set?

  1. ORDER
  2. SORT
  3. SORT BY
  4. ORDER BY

Answer(s): D



The SQL statemeot to chaoge "Haoseo" ioto "Nilseo" io the "LastName" columo io the Persoos table

  1. Modify Persoos SET LastName='Haoseo' INTO LastName='Nilseo
  2. Update Persoos SET LastName='Haoseo' INTO LastName='Nilseo'
  3. Update Persoos SET LastName='Nilseo' where LastName='Haoseo'
  4. Modify Persoos SET LastName='Nilseo' where LastName='Haoseo'

Answer(s): C



The SQL statemeot to delete the records where the "FirstName" is "Peter" io the Persoos Table

  1. Delete ROW FirstName='Peter' from Persoos
  2. Delete from Persoos where FirstName like 'Peter'
  3. Delete FirstName='Peter' from Persoos

Answer(s): B



The SQL statemeot to returo the oumber of records io the "Persoos" table

  1. Select COLUMNS(*) from Persoos
  2. Select Couot(*) from Persoos
  3. Select Couot() from Persoos
  4. Select COLUMNS() from Persoos

Answer(s): B



Viewing page 10 of 31
Viewing questions 46 - 50 out of 150 questions


Post your Comments and Discuss Infosys TFINTCBSCIXM1001 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!