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

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.

+ Click Here To Join also Our facebook study Group.

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


See Your Saved Posts Timeline

Views: 6828

.

+ 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?)

Replies to This Discussion

Thanx Dear kafi ha 

Anmol Maha Thanks for sharing 

CS403 22 AUG 2014 CURENT FINTRM PAPERS solve by Humda

Attachments:

thanx alot Humda sis

thnx u al frnds

_____________ is not the phase of Database Development Process


Which of the following is Semantic Data Model?


DML COMMAND ARE USED 


Consider two sets A and B. A contains 3 elements and B contains 4. How many elements do their Cartesian product contains?


Which of the following stores the Textual Data?

Which of the following commands is used to drop the table named STUDENT? 

Which of the following is not a feature of effective interface?


Which of the following is not related with Browser based forms development?


________ is not a feature of hash access.



________ is disadvantage of chaining technique to handle the collisions.

_______ is advantage of Re-Hashing technique to handle the collisions.

Which of the following is the correct way of removing the Index called branchNoIndex? 

Which of the following is incorrect regarding Indexes?

Which of the following is true about the views?


Which of the following is NOT CORRECT Regarding VIEWS?


Which of the following Command creates a view named ST-LIST on STUDENT table to show all the columns?


Locking is maintained by _________

While recovering data, which of the following files does a Recovery Manager examines at first?



If A -> B then AC - > BC.
This inference rule is called as ________________.


In DFD, Collector shows the ________ of data to a single point


A Super key for which no subset is a Super key is called ____________. 

Normalization is based on the concept of______

Consider two sets A and B. A contains 4 elements and B contains 5. How many elements do their Cartesian product contains?

The database schema is written in_____

DML stands for _______


Which of the following is a valid reason for denormalization?


Which of the following is not a common relational database management system that uses SQL? 



_________is a special high-speed storage mechanism




Which of the following cannot be used as a DATA TYPE in SQL:


Suppose we have two relations “S (f, g, h, z)” and “R (x, y, a, b)”, while ‘f’ is the primary key of relation ‘S’, ‘x’ is the primary key of relation ‘R’ and ‘b’ in ‘R’ is used as foreign key.
Keeping in mind the above statement, which one of the following will be criteria for inner join.




DBMS operation involves_____

Which of the following window control will you use for deleting a record?


On each transaction restart, the recovery manager RM examines



Concurrency Control is a part of ______



Application programs can be developed in ________________ 
___++++++


Wait-for graph detects_____



Vertical partitioning is done on the basis of _________.


Which of the following statements create a database named COMPANY? ++


Deadlock can be prevented by giving each transaction a ___________.


_____________ is used to sort the result set in ascending or descending order.

SUBJECTIVE

What are two primary modes of locks? Differentiate between shared and update lock.


Create a view named “INSTRUCTOR-LIST” on INSTRUCTOR table to show INS-NAME and CITY of those instructors, who belongs to ISLAMABAD or KARACHI.

INSTRUCTOR (INS-ID, INS-NAME, CITY)



50)
STUDENT Table
STU_ID STU_NAME Address City
1 AHMAD ABC – 123 XYZ
2 ALI DEF – 456 WXY
3 RASHEED GHI – 789 WYZ
4 REHAN JKL – 012 XYZ
5 FAHAD MNO – 345 WXZ

RESULT Table
STU_ID SEMESTER TOTAL_SEM_MARKS
1 SP – 2011 400
2 SP – 2011 367
3 SP – 2011 164
5 SP – 2011 423

Sample tables are provided above. You have to draw output table of the SQL query given below.

SELECT STUDENT.STU_NAME, RESULT.TOTAL_SEM_MARKS
FROM STUDENT
INNER JOIN RESULT
ON STUDENT.STU_ID = RESULT.STU_ID
ORDER BY RESULT.TOTAL_SEM_MARKS


49)
CUSTOMER table have attributes “cs_id” and “cs_description”.
Write SQL Commands for each of the given scenario.

Add a column named "cs_name" of text type. 
Drop “cs_description” column. 
Delete the table. (Table structure and data both should be deleted).



48)
"Indexes can be defined even when there is data in the table". Indentify the statement as correct or incorrect. Justify your answer in either case.

47)
Write down any four reasons that results in the failure of database transactions?


46)Write a SQL command to Create a Table CUSTOMER with attributes cs_id and cs_name.
Where 
cs_id is of int type and should not be null
st_name is of text type.


45)
Write an SQL statement to delete rows from a table CUSTOMER where the last_name is HAMZA.

44)
What is a transaction? Write any two properties of a transaction. 

43)
What is the role of Self join? Give an example.

42)
What is the purpose of horizontal partitioning?

41)
Write a SQL command to drop the view named STUDENT-LIST

mt today paper mcqzmostly from past paper from moaz file and some short Q also from moaz file
Q. Given two tables DOCTOR (D_ID,D_CONTACT) , MEDICINE(M- CODE, Description) (i) Create unique index D_ID on DOCTOT (ii)Create unique index on both M-CODE, Description Q. What is a transaction? What are ACID properties? Q. diff between volatile and non volatile storage
Q. std id =04 , std name Ali, city lahore , phone 0300400000 then write the SQL queery to insert these information into student persnol information table.
Q. disadvantages of concurrent access.

Std id

Std name

Std supervisor id

St1001

Ahmed

Sp1001

St1002

Ahsan

Sp1002

St1003

Raiz

Sp1003

St1004

Akram

None

St1005

Ali

Sp1005

 

Supervisor name

Supervisorid

Mr.kahlid

Sp1001

Mr. ahmad

Sp1002

Mr. yasin

Sp1003

Mr. waqas

Sp1005

select *from student right outer join

supervisor on student id where 

 supervisorid=supervisorid (thek  say yaad nhi query ) whatwill be result of this query on above tabel 

Q.differnce between SQL and SQL server ???
Q. baqi ek SQl queery likhni thi about insert value
Q. Write sql statement for display list of persons in table PERSON and show only that records whose first name is Ahmed and who's Last name is akram
Qbaqi jo q thy woh bhi sql squery he write krni thi statment nhi yad

mcqz and subjectv moaz file 

Attachments:

any body solve all spring 2014 current papers please ...

RSS

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

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