CS 403 – VU Final Term Current Paper 2021

4
150
CS 403 CS 431 - VU Final Term Current Paper 2021

Cs 403 – VU Final Term Current Paper 2021

SQL Queries

clustered or non clustered Index ki definition

D/f b/w stored or derived attribute?

Define Hash Function h?

Three basic operations/functions of “CREATE TABLE” in SQL command?

Define transaction?

unique index query

sql query without allias

sql query for join.

show output of query

define hash function

define concurrency controller

query for delete and update

query for alter table

give most suitable attributes for student entity…

1) Describe purposes of using Materialized views
2) SELECT * from Login Where username like ‘a%m’ return the result.
3) List down three data types which are used to handle the textual data in SQL Server.
4) Differentiate between primary and secondary indexes.
5) Suppose we have an ERD having two entities Voter and Ballot paper. There is one to one relationship between these two entities.

6)
Voter Entity has attributes as;
Voter-CNIC, Voter-name
Ballot Paper Entity has attributes as;
Paper-id, Paper-type
Paper-id = Ballot Paper Serial Number
Paper-type = Vote is conducted for Provincial or National Assembly
Map the said scenario into relation (s).

7)
Create a view named “INSTRUCTOR-LIST” on INSTRUCTOR table to show INS-NAME and CITY of those instructors, who belongs to ISLAMABAD or KARACHI.

INSTRUCTOR (INS-ID, INS-NAME, CITY)

8)
Mention the names of the techniques in following scenarios to avoid collision in finding hash function;
1- The technique where unlimited numbers of collisions are handled by enlisting the chain of collisions attached to appropriate slot.
2- The collision avoidance technique in which empty slot in the table is found either by a new function or re-applying the original one.

CS 403 – VU Final Term Current Paper 2021

CS 431 Paper

Short questions
Warless
WAP three reasons communication system and example
2. Simple parity check table
Diagram
Window flow control diagram
IP operation Name
Long question
What is Home address care of address with example
Why use positive acknowledgement
When time out

more paper

4 COMMENTS

  1. Negatif SEO ile rakiplerinizin sitelerini kolaylıkla alt sıralara düşürebilir ve siz rakiplerinizin yerine geçebilirsiniz.

    Sizler için sevmediğiniz yada rakip sitelerinize ANTİ
    SEO çalışması yani Negatif SEO çalışması yapabilirim.

    With negative SEO, you can easily lower your competitors’ sites
    and you can replace your competitors.
    I can do ANTI SEO work, that is, Negative SEO work for you or your competitor sites
    that you do not like.

    Negatif SEO

  2. I’m not positive where you’re getting your info, however great topic.
    I must spend some time finding out much more or working out more.
    Thank you for wonderful information I was searching for
    this information for my mission.

  3. This is a really good tip especially to those fresh to the blogosphere.
    Simple but very accurate information… Appreciate your sharing this
    one. A must read article!

LEAVE A REPLY

Please enter your comment!
Please enter your name here