3i Infotech Placement: Sample Questions 757 - 758 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 757

Edit

Describe in Detail

Essay▾

What is DML (Data Manipulation Language) ?

Explanation

Define Data Defination Language
  • Data Manipulation is:
    • retrieval of information from the database
    • insertion of new information into the database
    • deletion of information in the database
    • modification of information in the database
  • A DML is a language which enables users to access and manipulate data.
  • The goal is to provide efficient human interaction with the system.
  • There are two types of DML:
    • procedural: the user specifies what data is needed and how to get it
    • nonprocedural: the user only specifies what data is needed
      • Easier for user
      • May not generate code as efficient as that produced by procedural languages
  • A query language is a portion of a DML involving information retrieval only. The terms DML and query language are often used synonymously.

Question 758

Edit

Write in Short

Short Answer▾

What are the data units at different layers of the TCP/IP protocol suite?

Explanation

  • The data unit created at the application layer is called a message.
  • The transport layer the data unit created is called either a segment or a user datagram.
  • The network layer the data unit created is called the datagram.
  • The data link layer the datagram is encapsulated into a frame and finally transmitted as signals along the transmission media

Developed by: