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

<a href=https://buytadalafshop.com/>Cialis</a>

“I haven’t seen you in these parts,” the barkeep said, sidling during to where I sat. “Personage’s Bao.” He stated it exuberantly, as if low-down of his exploits were shared by settlers about multitudinous a fire in Aeternum.

He waved to a unimpassioned keg apart from us, and I returned his token with a nod. He filled a telescope and slid it to me across the stained red wood of the court before continuing.

“As a betting chains, I’d be ready to wager a honourable portion of coin you’re in Ebonscale Reach on the side of more than the drink and sights,” he said, eyes glancing from the sword sheathed on my hip to the salaam slung across my back.


Possibly Related Threads…
Thread / Author Replies Views Last Post
Last Post by FrankJScott
10-13-2021, 10:06 PM
Last Post by FrankJScott
10-13-2021, 12:11 AM
Last Post by Mourldorp
10-12-2021, 06:11 AM

Users browsing this thread: 1 Guest(s)