3i Infotech Papers: Sample Questions 797 - 798 of 1245

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

Question number: 797

» Basic CS » Networks

Essay Question▾

Describe in Detail

What is NETBIOS and NET BEUI?

Explanation

  • NETBIOS:

    • Programming interface allowing I/O requests to be sent to and received from a remote computer.

    • Hides the networking hardware from applications.

    • Supports small to medium networks providing transport and network layer support.

    • Fast and small and works well for the DOS operating system.

  • System wide methods of resolving NETBIOS names to IP address are:

    • b-node - Broadcast node

    • p-node - Point-to-point node queries an NBNS name server to resolve addresses.

    • m-node - First uses broadcasts, then falls back to querying an NBNS name server.

    • h-node - The system first attempts to query an NBNS name server, then falls back to broadcasts if the name server fails.

  • NETBEUI:

    • NETBEUI is NETBIOS extended user interface.

    • A transport protocol designed by Microsoft and IBM for small subnets responsible for data transport.

    • Handles all the frame formatting not handled by NETBIOS.

Question number: 798

» Database » MySQL

Essay Question▾

Describe in Detail

What cursor type do you use to retrieve multiple record sets?

Explanation

Explicit cursor type do use to retrieve multiple record sets.

Explicit cursor:

  • An explicit cursor is defined in the declaration section of the PL/SQL Block.

  • It is created on a SELECT Statement, which returns more than one row.

    Syntax for creating cursor:

    CURSOR cursor_name IS select_statement;

  • cursor_name – A suitable name for the cursor.

  • select_statement – A select query that returns multiple rows.