3i Infotech Papers: Sample Questions 683 - 684 of 1245

Examrace Placement Series prepares you for the toughest placement exams to top companies.

Question number: 683

» Database » Oracle

True-False▾

Question

Is the Following Statement True or False?

SET TRANSACTION USE ROLLBACK SEGMENT is used to create user objects in a particular Table space.

Answer

FALSE

Explanation

Transaction and rollback segments.

Transaction and Rollback Segments.

Transaction and rollback segments.

  • The SET TRANSACTION statement:

    • Sets a transaction as read-only

    • Sets a transaction as read/write

    • Assigns a name to a transaction

    • Assigns a rollback segment to a transaction

  • The operation performed affects only our current transaction.

  • Transaction ends COMMIT or ROLLBACK statement is issued.

  • Oracle Database implicitly commits the current transaction before and after executing a data definition language statement.

Syntax of Set Transaction:

SET TRANSACTION [READ ONLY|READ WRITE]

[ISOLATION LEVEL [SERIALIZE|READ COMMITED]

[USE ROLLBACK SEGMENT ‘segment_name’]

[Name ‘transaction_name’];

Question number: 684

» Basic CS » Networks

Essay Question▾

Describe in Detail

What is Protocol Data Unit?

Explanation

  • Protocol Data Unit is an open system interconnection term used in telecommunications

  • Refers to a group of information added or removed by a layer of the OSI model.

  • Represents a unit of data specified in the protocol of a given layer- consisting of protocol control information and user data.

  • Term specifically related to the initial four layers of the OSI model.

  • DSAP (Destination Service Access Point), SSAP (Source Service Access Point) are addresses used by the LLC (Logical Link Control) to identify the protocol stacks on the receiving and sending machines generating and using the data.

PDU for each layer of the OSI model is listed below:

  • Physical layer

    • Raw bits (1s or 0s) transmitted physically via the hardware

  • Data Link layer

    • A frame

  • Network layer

    • A packet that contains the source and destination address

  • Transport layer

    • A segment that includes a TCP header and data

  • Session layer

    • The data passed to the network connection

  • Presentation layer

    • The data formatted for presentation

  • Application layer

    • The data received or transmitted by a software application