Technical Questions

Q:

 Stored procedures have which of the following advantages?

A) It takes a longer time to write them as compared to writing Visual Basic. B) Data integrity improves as multiple applications access the same stored procedure.
C) Network traffic increases D) Result in thicker client and thinner database server.
 
Answer & Explanation Answer: B) Data integrity improves as multiple applications access the same stored procedure.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 4089
Q:

Give an example of one address microprocessor?

Answer

8085 is a one address microprocessor. In 8085 interrupts  are classified by software and hardware interrupts.

Report Error

View answer Workspace Report Error Discuss

Subject: Hardware

3 4088
Q:

What is fragmentation? Different types of fragmentation?

Answer

Fragmentation occurs in a dynamic memory allocation system when many of the free blocks are too small to satisfy any request. 


External Fragmentation: External Fragmentation happens when a dynamic memory allocation algorithm allocates some memory and a small piece is left over that cannot be effectively used. If too much external fragmentation occurs, the amount of usable memory is drastically reduced. Total memory space exists to satisfy a request, but it is not contiguous. 


Internal Fragmentation: Internal fragmentation is the space wasted inside of allocated memory blocks because of restriction on the allowed sizes of allocated blocks. Allocated memory may be slightly larger than requested memory; this size difference is memory internal to a partition, but not being used

Report Error

View answer Workspace Report Error Discuss

1 4083
Q:

How would you free the memory allocated by the following program?

#include "alloc.h"

#define MAXROW 3

#define MAXCOL 4

main()

{

     int **p, i;

     p = (int **) malloc (MAXROW * sizeof (int *));

      for ( i = 0; i < MAXROW ; i++)

            p[i] = (int *) malloc (MAXCOL * sizeof (int ));

}

Answer

for ( i=0; i < MAXROW ; i++)


free (p[i]);


free (p);

Report Error

View answer Workspace Report Error Discuss

Subject: Programming

0 4067
Q:

Ethernet uses which topology

A) Star B) Bus
C) Twisted pair D) Both B & C
 
Answer & Explanation Answer: B) Bus

Explanation:

Ethernet uses Bus topology.

Report Error

View Answer Report Error Discuss

7 4052
Q:

How long is an IPv4 address?

A) 128 bytes B) 32 bits
C) 32 bytes D) 128 bits
 
Answer & Explanation Answer: B) 32 bits

Explanation:

Internet Protocol version 4 (IPv4) which defined an IP address as a 32-bit value

IPv4 is in contrast to IPv6, which defined an IP address as a 128 bits value.

Report Error

View Answer Report Error Discuss

Filed Under: Networking
Job Role: Analyst , Bank Clerk , Network Engineer

0 4052
Q:

 ________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.

A) ASP B) XML
C) ODBC D) ADO
 
Answer & Explanation Answer: D) ADO

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 4025
Q:

Where does CPU Enhanced mode originate from?

Answer

Intel's 80386 was the first 32-bit processor, and since the company had to backward support the 8086. All the modern Intel-based processors run in the Enhanced mode, capable of switching between Real mode (just like the real 8086) and Protected mode, which is the current mode of operation.

Report Error

View answer Workspace Report Error Discuss

Subject: Hardware

1 4011