CS403 Final Term Current Papers 2018-2020

CS403 Current Final Term Papers 2018 To 2020 2020 Paper 1

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

Paper 2

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

Paper 3

40 mcqz...

Paper 4

CS 403 final term paper timing 5 pm Mcqs almost half past papers sy. 5 questions 3 marks.. Database create krna tha syntax likhna tha.? Characteristics of Physical storage media..? Five operations of relational algebra? In log file <tx,X,33> what does this statement.? 5 marks questions.. 2 table diaye thy aur in me sy table bnana tha semester result ka . Entity instance, entity set, entity typ tabel tha . View create krna tha PROFESSOR table tha. Timestamping..?

Paper 5

Cs403 today at 2:30 pm 40% mcq’s from past Questions: Types of joins. 3 marks statement about isolate 3 marks Write benefits of super/sub type entities in ER diagram. 5 marks What is locking an how to maintained it?? 3 marks write type name Command button 3 marks Heap 3 marks Create a view named project details on project table.......Islamabad m.from past 5 marks

Paper 6

Cs403 done Mcqs from past paper 15 aaay thay Short question m in operator ka use Normalization is based on all type of data. Base Query likhni the matching columns thay Columns ki query khud likhi the wo change kr k table m modification krni the