cs403 current Final term paper 2020

 

30 -42 lectures sy zyda mcqs thy

 Cs403 

Today's my paper

Totally. Mcqs conceptual

No. One definition 

No. One question just 

Quries

Leacture 37 to 43

Mostly mcqs yaha se thee

Quries thii student name and father name ko combined krna thaa

1. Change int_salary into 3500

2. Drop coloumn

3. Change Colum

4. Creat table instructor_list

[2/28, 10:25 AM] ~zrrGujjar: Cs403 

Today's my paper

Totally. Mcqs conceptual

No. One definition 

No. One question just 

Quries

Leacture 37 to 43

Mostly mcqs yaha se thee

Quries thii student name and father name ko combined krna thaa

1. Change int_salary into 3500

2. Drop coloumn

3. Change Colum

4. Creat table instructor_list

CS403 important topics

De-normalization (concept)

Partitioning and its types

Replication 

Basic commands of SQL (select ,insert , delete, create)

 (DDL, DML and DCL)

Joins and it types

RAID levels pg 259

Hashing

Handling the collision

Primary and secondary indexing

Clustered Versus Un-clustered Indexes

Dense and Sparse Indices

Transactions and Schedules

Deadlocks , prevention, detection and handling

Problems of Timestamping

Toda is my ppr cs403 

Mostly mcq past paper

40 mcq

5 question 3 nbr ka or 5 question 5 nbr ka

1) Rollback dafination

2)" virtual table " explain

3) 4 function thy un ka set or subset bnany thy with diagram

4) Emplyee ,salery, age wagara dya huwa tha un ko denormalization ma likhna tha

5) students ki id , total marks, obtain marks, sab dya huwy thy usy SQL query ma likhna tha

6) Madicn (M- Madicn Discprition) SQL query write

7) Occurrencey problem and     explain 

8) suppose ap ki old file han or data raugh ho gya huwa usy long time tk save rakhny ka lya 5 majer advantages ,, ya sai yad nai ab

9) RAID 2 Level and RAID 3 Level explain

Best of luck

--cs403 paper today ---

----- 50 % mcqs were from past papers

---- remaining mcqs conceptual

--- unique index query

--- sql query with out 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...

Paper was easy