3i Infotech Placement: Sample Questions 761 - 763 of 1245

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 761

Edit

Write in Short

Short Answer▾

Can you run the product development on all operating systems?

Explanation

  • No we can not run the product development on all operating systems.
  • It is formatted differently on different operating systems and only supports operating systems running off the central operating system that it was built to support.

Question 762

Edit

Describe in Detail

Essay▾

Explain difference between TCP & UDP

Explanation

Difference between TCP & UDP
Difference between TCP & UDP
TCPUDP
Transmission Control ProtocolUser Datagram Protocol
Connection oriented protocolConnectionless protocol
Used in applications in which fast transmission of data not requiredPreferred in applications requiring priority of sending data on time and on faster rates
Slower speed of transferFaster speed
Rearranges data packets in the order specifiedNo inherent order as all packets are independent of each other.
Header size is 20 bytesHeader size is 8 bytes
ReliableUnreliable
Example: HTTP, FTP, SMTP etc.Example: DNS, DHCP, TFTP, SNMP, RIP, VOIP etc.

Question 763

Question

MCQ▾

What are the SQL clauses supported in the link property sheet?

Choices

Choice (4)

a.

WHERE & START WITH

b.

START WITH & HAVING

c.

WHERE, START WITH & HAVING

d.

WHERE & HAVING

Answer

c.

Explanation

  • WHERE, START WITH & HAVING are the SQL clauses supported in the link property sheet.

WHERE Cause

  • Used to filter the result from a SELECT, INSERT, UPDATE, or DELETE statement.

    Syntax

    WHERE conditions;

START with Cause

  • Appears in hierarchical SQL queries and queries data with master details relationships.
  • Marks node starting node or level of the tree structured data.
  • Scalar value can be assigned the root of the query.

Syntax

SELECT [COLUMNS]

FROM TABLE_NAME

START WITH [COLUMN] = [ROOT NODE VALUE]

CONNECT BY [CONDITION]

HAVING Clause

  • Restricts the results of a GROUP BY in a selectExpression.
  • Applied to the entire result as a single group.

Syntax

HAVING searchCondition

Developed by: