CS403 All Current Final Term Papers 20 August 2016 to 02 September 2016
Share Your Current Final Term Papers (Questions/Pattern) 20 August 2016 to 02 September 2016  to help each other. Thanks
Cs403 Current paper:
Mostly MCQs from past paperz
Question about Normalization and Denormalization

Question about Quries
Change the data type of the table
Drop and Add columns
Set the Default Value
Describe the 4 types of view.
MY today's Paper of CS403- DBMS
question about syntax of In statement. (5 marks)
write names of 2 primary locks, and differentiate between shared and update locks.(5 marks)
Benefit of cluster index. (2)
Disadvantage of using indexes. (2)
Match the columns about Raids… (5)
Two Statement was given we have to tell if it’s correct or incorrect with justifying ans. (3)
What is Transaction? Write 2 properties of transaction. (2)
How to display all rows from the table. Write its syntax (3)
Syntax of View. (5)

CS403 PAPER (20-AUGUST-2016) :
�#�MCQS�: 7-8 MCQS from MOAAZ FiLe.. RemaiNinG C0nceptuaL..!
(2 Marks Questi0ns):
1. Write Names of the Two Types Of Horizontal Partitioning.
2. Write Names of the Four Types Of VIEWS.
3. Correct The Statement:
“Hashing provides slow, time consuming data retrieve from sequential files” �#�it_was_from_MOAAZ_Subjective_File�
4. Had to c0rrect the Table Syntax, which was given.
(3 Marks Questi0ns):
1. As an interface designer, what features should be included in the interface for the expert user. Answer must be l0gical.
2. Give one example of Deadlock on DBMS Transaction.
3. Had t0 Relate Column1 with Column 2 with three entries in b0th c0lumns.
& the Remaining Paper c0mprises 0f INDEXES, TABLE SYNTAX'S & 0ne Questi0n was 0f VIEW of 5 marks.

today's cs403 paper many mcqs were from past papers In 4 questions statements were given and we have to justify is it correct or incorrect. 2 questions were about write SQL queries. One question was characteristics of hash accessed method. One question was benefits of SQL.
CS403 (22-8-2016)
MCQS mostly were from Moaz past paprs file.
Theory questions:
1. ACID stands for?
2: Difference between Horizontal and vertical partitioning
3: Define index and its syntax.
4: Write any two DML commands.
5: Convert normal forms to another. (tables was given)
6: Match the following:
transaction ( internal schema )
3 level architecture (ACID)
Transaction Log (DBMS)
7: Write SQL statement to insert ROW.
8: Difference between DENSE index and Sparse index.

remaining questions were from sql queries. 
sql queries from VIEW topic.
Today cs403 paper
Q1 Difference B/w vertical partitioning and horizontal partitioning. 2 marks
Q2. Difference B/w Dense Index and Sparse Index. 2 marks
Q3 Describe the WHERE clause and HAVING clause. 2 Marks
Q4 Discuss any two situation of concurrent Access of data? 2 marks
Q5 when a query a sent to the database to find any specific value and an index is not being used….. 3 marks.
Q6 statement was given need to create view using sql commands 3 marks
Q7 Create a simple index, named “PersonINDEX”, on the CNIC field of the Person table. 3 marks
Q8 this question is about SQL statement create view … I forgot statement …. Sad Tongue 3 marks
Q9 Analyze the statement given below and identify each statement as correct or or incorrect. Justify your answer in either case.
1. “Durability ensures that committed change in the database can be lost due to any failure.
2. Transaction is a divide unit if work and execution of half transaction must be perform to preserve the data integrity
Q 10 If a table 1 and table 2 have same entity and the table 1 is 20 index and the table 2 14 index. Then the sequential file access use these operations (Insertion, updation or selection) on both table. Keep in mind the above scenario and mark the below given statements correct or incorrect. (Marks 5)
I. Insertion in table 1 take greater time than table
II. Updation in table 2 take greater time then table 1
III. Retrieving a record from table 1 take lesser time than table 2.
Q 11 Given that attributes as follows assigns them different data type.
Stu-ID, Name , DOB , Stu-PIC, Degree-ID
Data type = varchar, char , date, BLOB.
Q12 two column are given about Query, Database and physical and logical view need to match column A and column B . 5 marks
Cs403 current paper 2016 solved

Attached Files
.docx   Cs403 Current paper 2016 solve by Rubaisha.docx (Size: 26.79 KB / Downloads: 22)

Possibly Related Threads…
Thread Author Replies Views Last Post
  All subjects Final Term Solved Past papers Rubaisha(Moody Girl) 11 46,264 08-23-2020, 01:53 AM
Last Post: jtahir57
  VU Past Papers by Waqar Solved by Hadi Admin 0 3,318 12-10-2019, 06:49 PM
Last Post: Admin
  CS402 Mid Term Solved Past Papers Pakistani 0 3,705 06-16-2019, 08:32 AM
Last Post: Pakistani
  VU All Past Papers Admin 16 72,551 06-06-2019, 12:28 PM
Last Post: Mujahid punjabi
  PSY632 Final Term Past Paper Mishi Khan 1 4,950 05-21-2019, 11:46 PM
Last Post: Farooqi Brothers
  CS615 Solved Final Term Paper [Current] Admin 0 3,813 03-03-2019, 10:04 AM
Last Post: Admin
  STA730 Final Term Past Paper Mishi Khan 0 4,541 02-16-2019, 02:37 AM
Last Post: Mishi Khan
  STA630 Final Term Past Paper Mishi Khan 0 2,965 02-16-2019, 02:35 AM
Last Post: Mishi Khan
  STA301 Final Term Past Paper Mishi Khan 0 1,749 02-16-2019, 02:32 AM
Last Post: Mishi Khan
  PHY301 Final Term Past Paper Mishi Khan 0 1,144 02-16-2019, 02:10 AM
Last Post: Mishi Khan

Users browsing this thread:
1 Guest(s)