Basic CS [3i Infotech Placement]: Sample Questions 10 - 11 of 243

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

Question 10

Basic CS
Edit

Write in Short

Short Answer▾

What is SAP?

Explanation

  • Service access point or SAP is an identifying label for network used in OSI networking.
  • Allows other computers to communicate with the other layers of network protocol stack.
  • Conceptual location at which one OSI layer can request the services of another OSI layer.
  • At low level, it is a data structure and identifier for a buffer area in system memory.
  • Source Service Access Point or a Destination Service Access Point refers to the boundary between the Data Link Layer and the Network Layer.

Question 11

Question

MCQ▾

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the employee table?

Choices

Choice (4)

a.

ALTER TABLE employee DROP PRIMARY KEY CASCADE

b.

MODIFY TABLE employee DELETE PRIMARY KEY employee_id_pk CASCADE

c.

MODIFY TABLE employee DROP CONSTRAINT employee_id_pk CASCADE

d.

ALTER TABLE employee DROP PRIMARY KEY employee_id_pk CASCADE

Answer

a.

Explanation

ALTER TABLE employee DROP PRIMARY KEY CASCADE removes the EMPLOYEE _ID_PKPRIMARY KEY constraint and all depending constraints from the EMPLOYEE table.

Developed by: