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 and Final Papers at One Place From March 01 to March 12, 2014

+ Click Here To Join also Our facebook study Group.

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


See Your Saved Posts Timeline

Views: 2748

.

+ 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

.5: Analyze the statement check whether correct or incorrect justify in either case:
“Query Execution” is faster with the help of indexes. Marks 

is ka answer kia hai

answers please

answers please

thanxxxxxxxx alottttttttt bhai   u r doing great job keep it up

salam

my yesterday paper was

1.what is the purpose of joins. 2marks\

2. write 4 collision detection techniques. 2marks

3.write the failure of transactions. 3 marks ACID walay me se karna hai

4. correct the statements.    5marks

a. transactions are divisible and half transactions kuj isi type ki statement thi.

b. Durability is something when u get an error you can not retrieve your data. 

5. write index for the files 5 marks

6. write aquerry to define maximum marks and another query to find minimum result marks. 5marks

7. write a query to find the age greater than 20. 3marks

8. write the benefit of clusters. 2marks

9. write the benefits of indexes. 2marks

10. write the difference between truncate and drop command. 3marks

baki mcqs bht easy thay or jo files nadra gov wali koi file hai usme se b kafi aye thy or baki jo jo files meny yahn daikhi unme se b aye thy.

sadaf noreen  thanks for sharing 

Attention Students: You don’t need to go any other site for current papers pattern & questions. Because all sharing data related to current Final term papers of our members are going from here to other sites. You can judge this at other sites yourself. So don’t waste your precious time with different links. Just keep visiting http://vustudents.ning.com/ for all latest updates.

My Today's Paper CS-403 Database Management 3rd March 2014

total 40 MCQs  X 1 Mark = 40

4 Subjective X 2 Marks = 8 

4 Subjective X 3 Marks  = 12

4 Subjective X 5 Marks = 20

Total 80

Read the MCQs files shared on this forum 50% from that MCQs

Read the Subjective share on this forum 50% from that Subjective , Thanks to MOOAZ

Major questions from CREATE INDEX, CREATE VIEW, JOINs, Write SQL Query to get data basis of WHERE clause, or between clause

Difference between DROP, TRUNCATE and DELETE

Total 40 MCQs Mostly from MOAZZ file and mid
Total questions 52

Date : March 7,2014 Time : 11.00 am.
Subjective questions:
1) Write SQL command to delete a table(both table and data inside it) (2 marks)
2) Write steps in semi-join? (2 marks)
3) Write two benefits of views? (2 marks)
4) Write 3 operation/functions performed by CREATE Table command? (3 marks)
5) Rank the following as 'good' , 'average' , 'worse' in terms of space utilization
Linear probing
Chaining
Re-hashing (3 marks)
6) Table COMPANY and columns are COMPANY-NAME, ORDER-NUMBER
Write SQL command to display COMPANY-NAME in reverse alphabetical order? (3 marks)
7) Describe pessimistic and optimistic modes of locks? (3 marks)
8) Name two primary modes of locks? Differentiate between shared and update lock?
(5 marks)
9) A Table was given, to insert values in it? (5 marks)
10)What is file protection? Name its types? (5 marks)
11)Write reasons for using de-nornmalization? Give 3 real world scenarios of using it?
(5 marks)
12)What is common feature between RAID and Tape drive? (2 marks)

Anyone Solve all combine final Term Paper 2014

and uload please as soon as possible

Please solve these current Final Term Paper 2014

Please answer

 

Main points for help.

1. Match column A and B . Column A contains RAID 0,1,2,3,4 and column B contains properties of these      RAID.  ...........5 Marks

2. Create a table with given attributes and data types.          .... 5 Marks

3. Write query to Delete a row from table  ........3 marks.

4. what are materialized views  .......................3 marks

 

A table with values was given and said to give out put query.           ..... 5 marks

select st_name AS 'Student Name' ,st_add As ' Student Address' from student

two attributes have to select with alias.


dominant were:

command of sql

RAID Level

concurrency control 

Views

etc.

Paper was tough.


Differentiate simple and composite view?

  1. Difference between horizontal and vertical partitioning? Write in tabular form
  2. Attribute Allias ke bary me aik question tha yad nai ha
  3. What is view? Write general syntax of view? Write types of view?
  4. Write two index classification?
  5. This sql command is incorrect. Correct the command CREATE FURNITURE TABLE CREATE VUSTUDENT TABLE
  6. Aik concurrency control ph question tha
  7. Write a sql query aagy yad nai ha.
  8. Write a query for creating the view.
  9. aik question cachy ph tha         msqs zaida new thy 5 ya 6 old se thy baqi new thy

yh kal 2 bje ka paper ha sorry kal tabiat teak nai thi is lye paper share nai ker ski.Sorry baqi question yad nai

 

mera obejctive zayda is attatched file say ayaa..

subjective main ye tha

What is the Difference between DDL AND DML?
Wht is physical Memory device write three characteristics?
Creat a table.. us k attributes or data type b mention karnay thay.

Creat a View from a given table.. us k attributes or data type b mention karnay thay.



What is the Difference between DDL AND DML?
Wht is physical Memory device write three characteristics?
Creat a table.. us k attributes or data type b mention karnay thay.

Creat a View from a given table.. us k attributes or data type b mention karnay thay.

Attachments:


 Total Marks: 80

 Total MCQs: 40 (Each of 1 Mark)

Total Short Questions: 4 (Each of 2 Mark)

Total Short Questions: 4 (Each of 3 Mark)

Total Long Questions: 4 (Each of 5 Mark)

Recent paper cs403

Mcqs :

Question 1---Question 40

Subjective:

Question 41 : What is the difference Between Voltile and non volatile Memory?

Question 42 : What is the Difference between DDL AND DML?

Question 43 :When constructor accurate the data ?  

Question 44:Define the purpose of Deal Lock ?

Question 45 :Which comman is use in SQL 96 which command support it?

Question 46 :Use the Alter command in the data structure?

Question 47 :Wht is physical Memory device write three characteristics?

Question 48 :statement is given tell the Sql structure?

Question 49 :write the forms of SQL ?

Question 50 :Wht is file protection control write there names?

Question 51 :  What is unary and ternary Relationship?

Question 52 : Describe To_Date() function

Q:1 what are the creteria to judge the affectiveness of a chache memory?

Q:2 Differentiate between procedural and non-prodedural DML.

Q:3 How for should the recovery manager go backword in the log-file to trace the transaction affacted from the crash that the recovery manager needs to redo or ignore.

Q;4 write a SQL command to show all the cities from given students table .city should be not repeated :

STUDENTS(stu_id,stu_name,father_name,address, city , province)

Q:5 Analyze the statement give below and identify as correct or incorrect . Justify

"isolation" ansure that a transaction which is in progress may noot affect the transaction.

Q:6 what are the primary modes of locks? Differentiat between shared and update lock.

Q :7 Analyze the below query and findout why it will not work. correct the error

SELECT*FORM customer WHERE Year>'2004'

Q: 8 analyze the statement. Justify your answer

in RAID level 1 if either drive fails no data is lost.

Q: 9 justify

0)After defining indexes are not updated in any case

1) index can only be defined when table has at least 100 rows


how  view can be used for security purpose?

Q discuss the purpose of FROM clause in SQL query?

Q Analyze the statement is it correct or not:-

SQL is a structural language that is ,it allow the user to concentrate on specifying what data is required  rather than concentrating on the how to get ?
Q; describe Dense key index?
Q; analyse the statement 
            “isolation “ ensures that the transaction which is in progress may or may not be affected other transactions ?
Q; write SQL command. To display all the columns except CITY and REFERED_BY from the table given below 
 patient (P_ID,NAME,ADRESSES,CITY,ZIP,PROVINCE,COUNTRY,DATE_ADMITTED,
DATE_DISTARGE,REFERED_BY)?
Q: write rules you will follow while writing any SQL command ?
Q: analyze the statement
               0)after defining the indexes are not updated in any case .
                1)indexes can only be define when table have atleast 100 rows.
 Q: write SQL statement which display a list of person from the table name PERSON the complete information only those person should be display whose first name is Ali and last name is Ahmad?
Q; analyze the statement 
                 “it is a good approach to create an indexes on non_key attribute “
Q: write two primary modes of locks ?describe the difference between shared and updated lock ?             

Q1. Checkpoint makes the recovery procedure efficient. how RM will go back to start the

transaction.

Q2. 

Course (CourseNo, Ctitle, InstructNo)

Instructor (InstructNo, InstructName, InstructDept)

 denormalize the above relations to one form back? 

 

 

Q3. It is a good approach to create an index on non-key attribute. 

 

Q4. Give four reasons that results in the failure of database transactions.

 

Q5. Create a view named ‘STUDENT_DETAILS’ on ENROLMENT table which will show STD_ID and STD_NAME of those STUDENT, who belongs to KARACHI and MULTAN.

ENROLMENT (STD_id, COURSE_ID, STUDENT_NAME, CITY)

Q6. A candidate is applied for a study program in XYZ University. We have the relation to save his / her data in table Candidate-Info. 

Candidate can apply for more than one campus for a single degree program. choose control tools appropriate for each attribute of table. Controls / Tools list is as under;

list dia gia tha 

 

Your answer format is given below;

Attribute Name -> Tool Name

Fields of table are as under;

Candidate-Info (Candidate-name, Gender, Candidate-picture, Campus-selected, Program)


Q7. create a table on Employ along with 3 attributes and datatypes

Q8. create view syntax. 

Q9. Dif b/w RAID & tape 

Q10. analyze the statement 
                 “it is a good approach to create an indexes on non_key attribute “.

Question 41 : What is the difference Between Voltile and non volatile Memory?

Question 42 : What is the Difference between DDL AND DML?

Question 43 :When constructor accurate the data ?  

Question 44:Define the purpose of Deal Lock ?

Question 45 :Which comman is use in SQL 96 which command support it?

Question 46 :Use the Alter command in the data structure?

Question 47 :Wht is physical Memory device write three characteristics?

Question 48 :statement is given tell the Sql structure?

Question 49 :write the forms of SQL ?

Question 50 :Wht is file protection control write there names?

Question 51 :  What is unary and ternary Relationship?

Question 52 : Describe To_Date() function

 

  • Differentiate simple and composite view?
  • Difference between horizontal and vertical partitioning? Write in tabular form
  • What is view? Write general syntax of view? Write types of view?
  • Write two index classification?
  • This sql command is incorrect. Correct the command CREATE FURNITURE TABLE CREATE VUSTUDENT TABLE .
  • Write a query for creating the view.

1. Match column A and B . Column A contains RAID 0,1,2,3,4 and column B contains properties of these      RAID.  ...........5 Marks

2. Create a table with given attributes and data types.          .... 5 Marks

3. Write query to Delete a row from table  ........3 marks.

4. what are materialized views  .......................3 marks

5. A table with values was given and said to give out put query.           ..... 5 marks

select st_name AS 'Student Name' ,st_add As ' Student Address' from student

two attributes have to select with alias.



 My Today's Paper CS-403 Database Management 3rd March 2014

total 40 MCQs  X 1 Mark = 40

4 Subjective X 2 Marks = 8 

4 Subjective X 3 Marks  = 12

4 Subjective X 5 Marks = 20

Total 80

Read the MCQs files shared on this forum 50% from that MCQs

Read the Subjective share on this forum 50% from that Subjective , Thanks to MOOAZ

Major questions from CREATE INDEX, CREATE VIEW, JOINs, Write SQL Query to get data basis of WHERE clause, or between clause

Difference between DROP, TRUNCATE and DELETE

 

otal 40 MCQs Mostly from MOAZZ file and mid 
Total questions 52

Date : March 7,2014 Time : 11.00 am.
Subjective questions:
1) Write SQL command to delete a table(both table and data inside it) (2 marks)
2) Write steps in semi-join? (2 marks)
3) Write two benefits of views? (2 marks)
4) Write 3 operation/functions performed by CREATE Table command? (3 marks)
5) Rank the following as 'good' , 'average' , 'worse' in terms of space utilization
Linear probing
Chaining
Re-hashing (3 marks)
6) Table COMPANY and columns are COMPANY-NAME, ORDER-NUMBER 
Write SQL command to display COMPANY-NAME in reverse alphabetical order? (3 marks)
7) Describe pessimistic and optimistic modes of locks? (3 marks)
8) Name two primary modes of locks? Differentiate between shared and update lock? 
(5 marks)
9) A Table was given, to insert values in it? (5 marks)
10)What is file protection? Name its types? (5 marks) 
11)Write reasons for using de-nornmalization? Give 3 real world scenarios of using it? 
(5 marks)
12)What is common feature between RAID and Tape drive? (2 marks)

 

Attachments:

Solution of some of the above questions 

Remember me in Your prayers

What is the difference Between Voltile and non volatile Memory?

 

Volatile storage: Computer storage that is lost when the power is turned off is called as volatile storage.

Non volatile storage:  Computer storage that is not lost when the power is turned off is called as non – volatile storage, pronounced cashe is a special high-speed storage mechanism. It can be either a reserved section of main memory or an independent high-speed storage device. Two types of caching are commonly used in personal computers: memory caching and disk caching.pg 255

Thanks,anyone solve all paper and upload please.

RSS

Latest Activity

Today Top Members 

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

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