We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
CS403 Final Term Papers Spring 2019 (24 August ~ 04 September 2019) & All Solved Past Papers, Solved MCQs & Helping Material
.+ 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)
Cs403 My today's paper Mcqs 20 to 25 moaaz file sy tha... Subjective 1. What is inter schema mapping? 2. Difference between SQL and SQL server? 3. Difference between optimistic and pessimistic modes for taking locks? 4. Which method is in DBMS to detect Deadlock? Briefly explain. Baki questions yad ni...
60% mcqs from past moaaz files
5 questions of 3 marks 5 questions of 5 marks
Index , index types difference between them
View, general syntax,view types
I think ye cs403 k liay imp hy...
DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database.
Examples: SELECT, UPDATE, INSERT statements
DDL is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database.
Examples: CREATE, ALTER, DROP statements
DCL is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it.
Examples: GRANT, REVOKE statements
TCL is abbreviation of Transactional Control Language. It is used to manage different transactions occurring within a database.
Examples: COMMIT, ROLLBACK statements
CS403 11:00 Am
Half MCQ's were from past papers.
Q1. Gives 4 reasons why database transactions failed?
Q2. Aik columns data dia tha uska sql query likhni thi.
Mcqs totally from waqar file
What is cluster.write the benefit of clustring?
Different level of data write just name?
Student or course ky attribute given thy relation btana tha ?
What is hash? Describe the function of hashing?
Differentiate between optimistic or mesimistic mode?