We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
+ Link For Assignments, GDBs & Online Quizzes Solution
+ Link For Past Papers, Solved MCQs, Short Notes & More
Dear Students! Share your Assignments / GDBs files as you receive in your LMS, So it can be discussed/solved timely. Files Upload Here.
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
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
.+ 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)
Thanx Dear kafi ha
Anmol Maha Thanks for sharing
CS403 22 AUG 2014 CURENT FINTRM PAPERS solve by Humda
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.
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)
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
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
INNER JOIN RESULT
ON STUDENT.STU_ID = RESULT.STU_ID
ORDER BY RESULT.TOTAL_SEM_MARKS
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).
"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.
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.
cs_id is of int type and should not be null
st_name is of text type.
Write an SQL statement to delete rows from a table CUSTOMER where the last_name is HAMZA.
What is a transaction? Write any two properties of a transaction.
What is the role of Self join? Give an example.
What is the purpose of horizontal partitioning?
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 supervisor id
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
any body solve all spring 2014 current papers please ...