Technical Part -2

The basic component of a file in a file system is a?

UoD stands for?

A relational database consists of a collection of

A ________ in a table represents a relationship among a set of values.

The term _______ is used to refer to a row.

The term attribute refers to a ___________ of a table.

For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

Can you use the UPDATE and SELECT clauses in one SQL statement?

Can we temporarily disable a login name?

Permanent setting of specific server characteristics is done by trace tags

Which of the following statements is/are false for Extended events in sql server 2008?

When SQL server is installed, which of the following database are created by default?

Which of the following statements is/are true for SQL server?

What is the difference between the WHERE and HAVING SQL clauses?

What is the syntax for creation new login on the SQL server?

Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

The different classes of relations created by the technique for preventing modification anomalies are called:

Which of the following gives a logical structure of the database graphically ?

The entity relationship set is represented in E-R diagram as

Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction ?

In OSI network architecture, the dialogue control and token management are responsibility of

In OSI network architecture, the routing is performed by

OSI stands for

The OSI model has ___ layers

Which of the following services use TCP?

DHCP
SMTP
HTTP
TFTP
FTP

What layer in the TCP/IP stack is equivalent to the Transport layer of the OSI model?

Which of the following describe the DHCP Discover message?

It uses FF:FF:FF:FF:FF:FF as a layer 2 broadcast.
It uses UDP as the Transport layer protocol.
It uses TCP as the Transport layer protocol.
It does not use a layer 2 destination address.

You want to implement a mechanism that automates the IP configuration, including IP address, subnet mask, default gateway, and DNS information. Which protocol will you use to accomplish this?

Which of the following is private IP address?

The _______ is the physical path over which a message travels.

The information to be communicated in a data communications system is the _______.

Frequency of failure and network recovery time after a failure are measures of the _______ of a network.

Which of this is not a class of IP address?

The class of an IP address can be determined by the ______bits of the ________ byte of the IP address.

110NNNNN . NNNNNNNN . NNNNNNNN . HHHHHHHH Which class of IP does this belong Where: N = network ID bitsH = host ID bits

Which process can affect of be affected by other processes executing in the system?

An un-interruptible unit is known as

The wait-for graph is a deadlock detection algorithm that is applicable when :

In internal fragmentation, memory is internal to a partition and :

Which of the following page replacement algorithms suffers from Belady’s Anomaly ?

The main virtue for using single Bus structure is ,

______ are used to over come the difference in data transfer speeds of various devices .

To extend the connectivity of the processor bus we use ______ .

Build & Fix Model is suitable for programming exercises of ___________ LOC (Line of Code).

Selection of a model is based on

Which of the following tags are related to Table in HTML ?

Which of the following is an attribute of <Table> tag?

Which of the following is not a pair tag?

myarr[5] is equivalent of?

The process of building new classes from existing one is called ______.