We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

CS403 Current Final Term Papers Spring 2014 & Past Final Term Papers at One Place from 22 August to 02 September 2014

ALL Current Final Term Papers Spring 2014 & Past Final Term Papers at One Place from 22 August to 02 September 2014


Share Your Final Term Papers Here in Reply of this Discussion

May Allah Solve Our Problems and Give Us Success

You Can download papers by a simple click on file. All the uploaded filed are in Zip file or PDF format So Install Adobe Reader and Winrar Software’s to open these Files

Note: If you download files with Internet Download Manager (IDM), you would face problem of damage files. All files are correct and no damage file, If you face this problem, Open IDM > Click on Options > Click on File Types > Remove PDF and ZIP from files types and save. After it download again files, files will work properly.

You Can Download Solved Final Term Papers, Short Notes, Lecture Wise Questions Answers Files, Solved MCQs, Solved Quizzes , Solved Final Term Subjective Papers , Solved Final Term Objective Papers From This Discussion For Preparation Final Term Paper of Spring 2014

Or

For Important Helping Material related to this subject (Solved MCQs, Short Notes, Solved past Papers, E-Books, FAQ,Short Questions Answers & more). You must view all the featured Discussion in this subject group.

For how you can view all the Featured discussions click on the Back to Subject Name Discussions link below the title of this Discussion & then under featured Discussion corner click on the view all link.

Or visit this link 

Click Here For Detail.

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 6843

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

DataBase Management System CS403 Final paper Spring 2014 (held on 22-AUG-2014)

Total Questions: 52

Total marks: 80

Total time: 120 minutes

MCQ: 40

4 Short questions each of 2 marks

4 short questions each of 3 marks

4 long questions each of 5 marks

(3 marks)

Q. Write an SQL statement to delete all rows from STUDENT table (table structure should not be disturbed) (5 marks)

Answer:- DELETE FROM STUDENT;

Q.Given below an EMPOLOYEE table (5 marks)

Empid

Empqual

Empsalary

Empadd

E1001

M.Phil

65000

Islambad

E1002

F.A

24000

Lahore

E1003

Bachelor

45000

Faisalabad

E1004

Master

52000

Mardan

 

Answer:-

Employee Salary

Employee Address

65000

Islambad

24000

Lahore

45000

Faisalabad

52000

Mardan

 

Write output of the following query

SELECT empsalary as ‘Employee Salary’, empadd as ‘Employee Address’ from EMPLOYE

 

Q. what is file protection control. Write basic types of file protection control. Write only names of its types. (5  marks)

Answer:- see page 261 handouts

50% object from past and 50% conceptual tha

Q. Differentiate between WHERE clause and HAVING clause (2 marks)

Q.Write an SQL statement to delete all records from a table CUSTOMER. (2 marks)

 

Q1 main purpose of alter command   2

Q2 how view can use for secuirty reason     2

Q3 2 ways of implement views     2

Q4 rewrite the query without using alias 2

Q5 main purpose of partition and placement    3

Q6 give an example of deadlock    3

Q7 output of like =%da% a query was given   3

Q8 create a view condition was given    5

Q9 a statement was given in which salary of employs was written we have to write the query to find salary between 5400 AND 6600    5  

Q10 A table and queries of inner join was give, have to find its output table   5 

Q11 careate a view with some condition was given   5

CS403 22 AUG 2014 CURENT FINTRM PAPERS


22aug2014 8:00AM
paper bht taff tha mera
mcqz end waly r start k lec m sy thy about transcation waly r 45 lec k paragraph m sy mcqz

2 qesn 2 marks k jst volatile r nonvolatile m difr 2nd ACID wala baki sb data bhir sy tha unki qury likhni thi r table thy unka iner outr join btna tha


BEST OF LUCK!

Salam.

MCQS : only two questions were about Actuall quiries.rest was just knowladge.

SUBJECTIVES: 4 Questions of 5 marks

here:

1.log file A .Direct access Operator ..Something like that

2.index sequential. B some option was given

3 index C transaction file

4.(index + data) D some option was given

We had to choose the correct option

a product diagram was given with its attributes(product name, product quantity etc).had to write it it SQL Query

a question on locks.:What are the primary two types of locks?then had to tell difference between shared lock and some other lock(induvidual i think)

There was also another quiry question.had to use View in that one

These were all 5 number questions

rest were 3 and 2 numbers

four types of views 2 marks

is this code correct?reason to be given as well 2 marks

and again another code was given had to tell if it was correct 2 marks (i think)

and few of them were quiry and a few simple ones,which do not involve quiry

read all handouts for mcqs.they were simple,...........if you know the answer.

Today Paper:

Obj:

20 MCQs from past papers.

15 MCQs from Hand outs.

5 Conceptual.

Sub:

3 or 4 from past papers.

1). What is the basic purpose of using Join? (2)

2). Write two ways of create tables in SQL server? (2)

3). Technique used to detect deadlocks. Explain briefly? (5)

4). Two questions on creating view with ascending order? (3, 5)

5). In which criteria replication and clustering are used. Explain replication? (3)

6). Why direct access is preferred over sequential access? (3)

7). What is serial execution? (2)

8). Create table author, uss ki books aur phone no. ko primary key and Int data type waghaira me SQL me commands likhni thi? (5)

advantage of IN operator? Difrnce b/w Views and Indexes? Define Inseration anomaly? aur ek table craete krna tha aur us me values insert krwani thien. data types TEXT , Number, Date&time use krni thi (5 marks) Aur 2 tables ko inner join sy join krna tha.which technique is motre efficient and why? Direct access or sequential file access

guria  Thanks for sharing ur paper.. 

MY TODAYS PAPER MOST MCQs

Which of the following is one of the purpos of using DDL command

  1. Inserting records into database
  2. Updating records into database
  3. Manipulating database
  4. Creating and destroying database

In ERD what type of relation between subject and student

  1. 1:1
  2. 1:M
  3. M:M
  4. Ternary

Suppose there are 5 rows and 4 columns in TABLE1 and 6 rows and 7 columns in TABLE2; what is the size of the Cartesian product in case of CROSS JOIN between these two tables?

 

  1. 30
  2. 65
  3. 28
  4. 35

Which of the activity which is not perform during development of applications?

  1. Data input programs
  2. Editing
  3. Display
  4. Data collection

 

Which of the following data is already stored and not created when needed

  1. Derived data
  2. Calculated data
  3. Actual data
  4. Virtual data
  5. Statical data

_________ is used to access and manipulate data

  1. DDL
  2. DML
  3. DCL
  4. SQL

Which of the following statement are DML command

  1. Insert
  2. Grant
  3. Alter
  4. Create

A table can have clustered index(es)

  1. Only one
  2. Only two
  3. More than two
  4. Only three

Wait-for graph is maintaind by

  1. Lock manager
  2. Index manager
  3. View manager
  4. Constraint manager

________ occurs when multiple users want to update same object at the same time

  1. Uncommitted update problem
  2. Inconsistent analysis problem
  3. Lost  join problem
  4. Lost update problem

For a specific database number of application programs always

  1. Vary
  2. Fixed
  3. Predefined
  4. Known

In case of context level DFD the system is represented by

  1. At least one process
  2. One process only
  3. Two process
  4. Three process

The machine that spins a disk is called a

  1. Disk derive
  2. CD ROM
  3. DVD ROM
  4. None of the given

When data found in check it is called

  1. Cache hit
  2. ?
  3. ?
  4. ?

In natural join common attributes appear

  1. Only once
  2. Two times
  3. Three times
  4. Both 2 or 3

Access control commands of SQL fall under

  1. DDL
  2. DML
  3. DCL
  4. SQL

Check option command is also known as

  1. Write only
  2. ?
  3. ?
  4. ?

SQL count function returns all _________ in table view

  1. Rows
  2. Columns
  3. Tables
  4. ?

A view can be deleted by using _____ command

  1. Delete view
  2. Truncate view
  3. Drop view
  4. ?

 

Write down the major types of statements used in SQL, write any three      (3)

Write down any four reasons that results in failure of database transaction      (3)

Write an SQL statement which displays a list of persons from the table named PERSON. The complete information of only those persons should be displayed whose the first name ALI and last name is Ahmed       

last question have 5 num

Today my paper of cs403;

Two benefits of using views.

List two commands of DML?

Write SQL query to find out the name of those employees whose status does not belong to hourly basis?

An Index may or may not comprise of multiple columns true or false give reason?

the index can comprise multiple columns (a composite index), like the way a telephone directory is organized by last name and first name. A clustered index determines the storage order of data in a table.

Create unique Index …………… query likhni thi? (5)

CREATE UNIQUE INDEX pr_prName

ON program(prName)

It can also be created on composite attributes. We will see it with an example.

CREATE UNIQUE INDEX

St_Name ON

Student(stName ASC, stFName DESC)

How check points makes the recovery procedure of efficient in content of deffec.. approach ? Four points was write? (5)

• Writes are deferred until commit for transaction is found

• For recovery purpose, log file is maintained

• Log file helps to redo the actions that may be lost due to system crash

• Log file also contains checkpoint records

Student (STU_ID, STU_NAME, FATHER_NAME, ADDRESS, CITY, PHONE NO)

Write an SQL query on student table to show complete record of each student who’s name start with Alphabet “A” and end with “N”? (5)

RAIDS related were column?

Q1 main purpose of alter command  

is used to add or drop columns in an existing table

 

Q2 how view can use for security reason     2

as security mechanisms by allowing users to access data through the view, without grantingthe users permissions to directly access the underlying base tables of the view.

Q3 2 ways of implement views     2

Q4 rewrite the query without using alias 2

SELECT {*|col_name [[AS] alias] [, …n]} FROM tab_name

SELECT [ALL|DISTINCT]

{*|culumn_list [alias][,…..n]} FROM table_name

[WHERE <search_condition>]

 

Q5 main purpose of partition and placement    3

Q6 give an example of deadlock    3

Q7 output of like =%da% a query was given   3

Q8 create a view condition was given    5

Q9 a statement was given in which salary of employs was written we have to write the query to find salary between 5400 AND 6600    5  

Q10 A table and queries of inner join was give, have to find its output table   5 

Inner Join : Only those rows from two tables are joined that have same value in the common attribute while In a left outer join, PROGRAM rows without a matching COURSE row appear in the result left table (i.e. the one that precedes in SQL statement) regardless of the existence of matching records in the right table.

Q11 create a view with some condition was given   5

 pata nahi.. past papers kiye hi nahi maine,, abhi paper khtm kia .. 1 hr ka paper tha bht easy.. 2 codes k ae thy, ek non dense index, correct incorrect statement k 2 questions thy , ek ACID ki terms, ek DML k commands, ek scenario tha partition batani thi,

 Today my paper of cs403;
Two benefits of using views.
List two commands of DML?

Data Manipulation is retrieval, insertion, deletion and modification of information from the database. A DML is a language, which enables users to access and manipulate data. The goal is to provide efficient human interaction with the system.
Write SQL query to find out the name of those employees whose status does not belong to hourly basis?
An Index may or may not comprise of multiple columns true or false give reason?
Create unique Index …………… query likhni thi? (5)

How check points makes the recovery procedure of efficient in content of deffec.. approach ? Four points was write? (5)
Student (STU_ID, STU_NAME, FATHER_NAME, ADDRESS, CITY, PHONE NO)
Write an SQL query on student table to show complete record of each student who’s name start with Alphabet “A” and end with “N”? (5)
RAIDS related were column?

You,.......you wrote this from your memory???

Today’s my paper of cs403.

The paper was easy. You should read the book carefully if you want to give a good and better paper.

Discuss the Replication and clustering. Also advantages of replication?(3)

What is Alter table statement?(2)

Two types of caching are commonly used in personal computers?(2)

What is a view? Types of view?(5)

Describe the serial execution?(3)

 2 statement teh or batna tah wo correct h yah pr incorrect.

i think etna h kafi h

RSS

Latest Activity

Asad Malik updated their profile
1 minute ago
Sucana Shafiq liked + M.Tariq Malik's discussion ISL201 Islamic Studies Assignment No 01 Fall 2019 Solution & Discussion
3 minutes ago
+'innocent" BSc replied to +'innocent" BSc's discussion Teaching of General Science (EDU201) Assignment I (Fall 2019) in the group GSC201 Teaching of General Science
5 minutes ago
+'innocent" BSc replied to +'innocent" BSc's discussion Teaching of General Science (EDU201) Assignment I (Fall 2019) in the group GSC201 Teaching of General Science
7 minutes ago
+!!! Annie !!!+ added a discussion to the group EDU654 Addressing problems of learning through technology and pedagogy
10 minutes ago
+!!! Annie !!!+ added a discussion to the group EDU433 Professionalism in Teaching
13 minutes ago
irum zahra and mubashir rehman are now friends
14 minutes ago
MUHAMMAD USMAN replied to Ikra butt's discussion CS504 QUIZ NO 1 SOLUTION WITH COMPLETE GUIDELINES 2019 in the group CS504 Software Engineering - I
15 minutes ago
Profile IconMUHAMMAD USMAN and Ikra butt joined + M.Tariq Malik's group
15 minutes ago
irum zahra liked + M.Tariq Malik's group MGT301 Principles of Marketing
17 minutes ago
Soha waris replied to + M.Tariq Malik's discussion EDU402 Curriculum Development Assignment No 01 Fall 2019 Solution & Discussion in the group EDU402 Curriculum Development
35 minutes ago
Profile IconSoha waris and ALI HASSAN joined + M.Tariq Malik's group
35 minutes ago
zobialatif posted a discussion
36 minutes ago
maria ali added a discussion to the group STA630 Research Methods
1 hour ago
maria ali joined + M.Tariq Malik's group
1 hour ago
+!!! Annie !!!+ liked + M.Tariq Malik's group EDU302 Human Development and Learning
1 hour ago
+!!! Annie !!!+ liked №Oř's group Novels and Famous e books
1 hour ago
+!!! Annie !!!+ liked + M.Tariq Malik's group CS204 Cyber Law
1 hour ago
+!!! Annie !!!+ liked + M.Tariq Malik's group EDU433 Professionalism in Teaching
1 hour ago
+!!! Annie !!!+ liked + M.Tariq Malik's group EDU654 Addressing problems of learning through technology and pedagogy
1 hour ago

Today Top Members 

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service