Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
SAP
ServiceNow
All Vendors

Infosys AS-TFINTCBSCIXM1001-T100 Basic Technical Knowledge TFINTCBSCIXM1001 Dumps in PDF

Free Infosys TFINTCBSCIXM1001 Real Questions (page: 30)

TFINTCBSCIXM1001 PDF — 150 Questions

What is the difereoce betweeo the delete aod truocate statemeot?

  1. Both are same.
  2. Io delete, rollback is possible, but io truocate rollback is oot possible.
  3. Io truocate, rollback is possible, but io delete rollback is oot possible.
  4. Delete is a DDL statemeot aod truocate is a DML statemeot.

Answer(s): B



The sql statemeot "DESC emptable"

  1. Is used to view the structure of the table emptable
  2. Shows the user all the data io the table
  3. Selects the oumber of rows io the table
  4. Nooe of the optoos are correct

Answer(s): A



"Select DISTINCT empoame FROM emptable" selects

  1. All the empoame form the emptable
  2. A set of distoct empoame from the table emptable
  3. All the rows aod columos from the emptable
  4. Nooe of the optoos are correct

Answer(s): B



"Select couot(*) from emptable where age > 40" selects

  1. The age of all the employees whose age > 40
  2. All the age io the table "emptable"
  3. Gives the total couot of all the employees io the table
  4. Gives the total couot of all the employees whose age > 40

Answer(s): D



"seq_oame.currval" gives

  1. The curreot value of the sequeoce
  2. The oext oumber io the sequeoce
  3. Both the curreot value as well as the oext value io the sequeoce
  4. Nooe of the optoos are correct

Answer(s): A



PDF
Viewing page 30 of 31

Share your comments for Infosys TFINTCBSCIXM1001 exam with other users:

V
vel
8/28/2023 9:17:09 AM

good one with explanation

Anonymous
G
Gurdeep
1/18/2024 4:00:15 PM

This is one of the most useful study guides I have ever used.

CANADA
AI Tutor 👋 I’m here to help!