3i Infotech Papers: Sample Questions 412 - 413 of 1245

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

Question number: 412

» Basic CS » Networks

Essay Question▾

Describe in Detail

What is SLIP (Serial Line Interface Protocol)?

Explanation

Define SLIP in image

Define SLIP in Image

Define SLIP in image

  • SLIP is a TCP/IP protocol used for communication between two machines previously configured for communication with each other.

  • Very simple protocol for transmission of IP datagram across a serial line.

  • Allows packets to be sent from one IP address to another.

  • When flag byte occurs inside the IP packet character stuffing is used to solve the problem.

  • Not used as frequently as its successor- Point-to-Point Protocol which provides enhanced error detection and automatic configuration.

Disadvantages of SLIP

  • Does not perform error detection and correction.

  • Supports only IP- not used for other networks

  • Does not provide authentication.

  • Is not an approved internet standard.

Question number: 413

» Database » MySQL

MCQ▾

Question

Which of the following is NOT VALID as PL/SQL

Choices

Choice (4) Response

a.

NUM1, NUM2 number;

b.

deptname dept. dname % type;

c.

date1 date: = sysdate

d.

Bool boolean;

Answer

b.

Explanation

Structure of PL/SQL engine and PL/SQL block

Structure of PL/SQL Engine and PL/SQL Block

Structure of PL/SQL engine and PL/SQL block

  • The name of a PL/SQL variable consists of one of more letters and numerals. Dollar sign and number sign is not valid in PL/SQL.

  • Boolean values are single byte data type, either TRUE or FALSE or NULL ().

  • A variable is nothing but a name given to a storage area that programs can manipulate.

  • Every variable in PL/SQL has a specific data type, which defines size and layout of variable’s memory, the range of value it stores and set of operations that can be applied to the variable.

  • By default, variable names are not case-sensitive.

  • We cannot use a reserved PL/SQL keyword as a variable name.

  • PL/SQL variables are declared in the declaration section.

  • When we declare a variable, PL/SQL allocates the memory for the variable’s value and the storage location is identified by the variable name.

Syntax for declaring a variable:

  • Variable_name [CONSTANT] datatype [NOT NULL] [: =| DEFAULT initial_value]

  • Here, variable_name is a valid identifier in PL/SQL.

  • Datatype must be a valid PL/SQL data type defined data type