CS403 All Current Final Term Papers 20 August 2016 to 02 September 2016
#1
Share Your Current Final Term Papers (Questions/Pattern) 20 August 2016 to 02 September 2016  to help each other. Thanks
#2
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..!
�#�SUBJECTIVE�:
(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.
#3
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.
#4
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
#5
Cs403 current paper 2016 solved


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


Possibly Related Threads...
Thread Author Replies Views Last Post
  CS610 Quiz first solved 2016 Rubaisha(Moody Girl) 0 150 11-17-2016, 11:13 PM
Last Post: Rubaisha(Moody Girl)
  CS502 assignment 1 Solution 2016 Rubaisha(Moody Girl) 0 680 11-17-2016, 04:18 PM
Last Post: Rubaisha(Moody Girl)
  CS602 assignment solution idea 2016 Rubaisha(Moody Girl) 0 201 11-16-2016, 10:49 AM
Last Post: Rubaisha(Moody Girl)
  MGT101 assignment solution 2016 Rubaisha(Moody Girl) 0 228 11-16-2016, 10:39 AM
Last Post: Rubaisha(Moody Girl)
  CS601 assignment_1 solution 2016 Rubaisha(Moody Girl) 0 114 11-16-2016, 10:31 AM
Last Post: Rubaisha(Moody Girl)
  CS614 complete solution of assignment 1 2016 Rubaisha(Moody Girl) 0 219 11-16-2016, 10:22 AM
Last Post: Rubaisha(Moody Girl)
  CS304 Assignment 1 Solution - Fall 2016 Rana 1 509 11-10-2016, 08:45 AM
Last Post: Lahori
  CS607 All Current Final Term Papers 20 August 2016 to 02 September 2016 Rubaisha(Moody Girl) 1 198 08-28-2016, 09:46 PM
Last Post: Rubaisha(Moody Girl)
  CS302 All Current Final Term Papers 20 August 2016 to 02 September 2016 Rubaisha(Moody Girl) 3 350 08-28-2016, 09:40 PM
Last Post: Rubaisha(Moody Girl)
  CS304 All Current Final Term Papers 20 August 2016 to 02 September 2016 Rubaisha(Moody Girl) 2 328 08-28-2016, 06:23 PM
Last Post: Rubaisha(Moody Girl)



Users browsing this thread:
1 Guest(s)