Internet & Web design Sample paper set 2

I

Internet & Web Design

Time: 1 hour                                                                                           Name: ______________

Note: All question of part-1 is mandatory and each question is carrying one marks. 2 questions are compulsory out of 4 from part-2.

(Part one)

Multiple Choices

1.  Effectiveness of data communication is depend on

a)      Delivery   b) Accuracy   c)Timeliness   d)All

2. Which of the following is not considered as network performance criteria?

a) Performance    b) Reliability   c)Security   d) Brand

3. Application of data communication is

a) Marketing & Sales   b)Manufacturing c) EDI  d) All

Longest common sequence

Given sequences say “MNOP” and NPA”

Longest common sequence of LCS is a sequence that appears in the same relative order in both the given sequence but not necessarily in a continuous manner.

See the example

M

N

O

P

Time Complexity

O(expression) is the set of functions that grow slower than or at the same rate as expression. It indicates the maximum required by an algorithm for all input values. It represents the worst case of an algorithm's time complexity.

ROW_NUMBER SQL Server

When SQL query has been run a query for create some output then sql server track number row on per partition returned. Which you can show using row number on the basis of following example

Syntax:

SELECT ROW_NUMBER() OVER (Order by Column_name) AS RowNumber,Col1,Col2,…

FROM dbo.newadmission