Share:
Notifications
Clear all

[Solved] CS403 Current Papers Final term Spring 2020  

  RSS

admin
(@admin)
Admin
Joined: 2 years ago
Posts: 4336
09/09/2020 7:45 pm  

CS403 Current Papers Final term Spring 2020


 

Dear Students! Please share your current CS403 final term paper's questions here. Will be helpful to other students for their final term exams. 🌼

 

Share anything you remember ! 

QueryVU WhatsApp Groups subject wise : Join Now


Quote
admin
(@admin)
Admin
Joined: 2 years ago
Posts: 4336
11/09/2020 8:17 am  

CS403 Current Papers Final term Spring 2020


CS403 current paper | 10-09-2020

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

QueryVU WhatsApp Groups subject wise : Join Now


ReplyQuote
admin
(@admin)
Admin
Joined: 2 years ago
Posts: 4336
11/09/2020 8:18 am  

CS403 Current Papers Final term Spring 2020


CS403 current paper | 10-09-2020

40 mcqz...
sbjctv me 5 mx k 5 qstn thy..or 3 mx k b 5 thy...
50% mcqz from pst ppr...wqar ki file se...
subjctv me 5 qstn programing k thy...or bki m errors or output btana tha..
.cursor or itratn me diffrnc pocha tha

QueryVU WhatsApp Groups subject wise : Join Now


ReplyQuote
admin
(@admin)
Admin
Joined: 2 years ago
Posts: 4336
15/09/2020 7:26 pm  

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

QueryVU WhatsApp Groups subject wise : Join Now


ReplyQuote
admin
(@admin)
Admin
Joined: 2 years ago
Posts: 4336
15/09/2020 7:27 pm  

Cs403#👉Purpose of Count *in sql.
👉Primary index, and Secondary index.
👉PRIMARY Locke, define shared and update lock.
👉 Simple and Composit attributes.
👉 If A is Rno and B is Cgpa. Than find AXB, BXA, AXB=BXA.
👉 Draw view of Professor table with Profasor name City lahore,, id and subject.
👉 Define data types of Transation id, Date, Usrname, Quantity.
👉 Define a scenario where replication is bot allowed
👉 Write quesry fo salry form emply more then 50000 age between 35 to 45 and id in sequence

QueryVU WhatsApp Groups subject wise : Join Now


ReplyQuote
admin
(@admin)
Admin
Joined: 2 years ago
Posts: 4336
15/09/2020 7:27 pm  

My Cs 403
What is view write it's general syntax and different types
Write down any four reasons that result in database transaction
What is the main difference between drop and truncate command
Preliminary study
Create a view named product list on product table which show columns product(product id, product name, product quantity)
Select * from persons where first name like%a; what does this statement return
Identify the existing normal form of relations and covert into next higher normal form
Write SQL command for 1. add a column named cs of text type 2. Drop cs description column 3. Delete the table]
MCQs were from past papers mostly

QueryVU WhatsApp Groups subject wise : Join Now


ReplyQuote
admin
(@admin)
Admin
Joined: 2 years ago
Posts: 4336
15/09/2020 7:27 pm  

----- 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...

QueryVU WhatsApp Groups subject wise : Join Now


ReplyQuote
admin
(@admin)
Admin
Joined: 2 years ago
Posts: 4336
15/09/2020 7:27 pm  

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

QueryVU WhatsApp Groups subject wise : Join Now


ReplyQuote
admin
(@admin)
Admin
Joined: 2 years ago
Posts: 4336
15/09/2020 7:27 pm  

Today my cs403 paper

MCQs
☆Attribute is also known as
☆Following is not correct about input forms
☆Correct way of recovering the index
☆True regarding index is
☆Locking is maintaining by......
☆Following are as reference point in the log file
☆Data sharing in database avoids
☆ACID stands for
☆Or eik tha DDL stands for
☆ACID used in
☆Materialized view
Following is a tool dependent level
☆Component of data flow diagram
☆Drop table student name
☆Mathematical function of SQL
kch insert delete drop k thy

Question....

☆long mein eik long question diagram di hoi thi os sy table bnana tha query table
☆Eik question tha os mein indexes ka btana tha
☆eik question mein primary key ka btana tha 3number ka question tha
☆Disk or oski types ☆Tranaction
☆Share ans its types update share scheduled share difference

QueryVU WhatsApp Groups subject wise : Join Now


ReplyQuote
admin
(@admin)
Admin
Joined: 2 years ago
Posts: 4336
21/09/2020 11:50 pm  

CS403 Current Papers Final term Spring 2020


CS403 current paper | 16-09-2020

Mcqs are not from past papers.But easy
Subjective

🔴Difference between truncate command and Drop command.
🔴Difference between Alternate key and candidate key with example.
🔴Recovery procedure(write in correct order).
🔴Given 1 line, containing attributes. Like( Reg no , Roll no, stu name, class)
Reg no and Roll no are both underlined. Describe the given line contain candidate keys or not. Also describe it is BCNF or not.
🔴2 Questions are describe with SQL commands.
🔴Write characteristics of checkpoint.
🔴Table is given, Calculate student Mark's. Total Mark's are higher than average Mark's. Compute this table in SQL form and derive Mark's of the student.
🔴How many functions of an SQL. Mention with there names.
🔴2,3questions are describe with SQL command.(Means Mostly Questions are from query part)

QueryVU WhatsApp Groups subject wise : Join Now


ReplyQuote
Share: