Cs403 All Current Final Term Papers Spring 2013 (20 Jul 2013 ~ 31 Jul 2013)

[+ ℱȺℋ££M ᏕȺQǐβ]

All Current Final Term Papers Spring 2013

From 20 Jul , 2013 to 31 Jul 2013 Spring 2013

 

PLZ Share Ur Papers Files Also where u Study

[Amna]

jitna mjy ata tha maine ab tak k current paper solve kar diay hain. agr koi mistake ho to plz theak kar dain. thanx

1.ek index create krna tha

Answer:
Basic Syntax of INDEX.
CREATE INDEX index_name
ON table_name (column_name)

Question#3 (Marks 5)
Create a simple index, name (Personal Index) on the LastName field of the person table?
Answer:-
TABLE person
(
FirstName char(15),
LastName char(15),
Address char(50),
City char(50),
Country char(25),
)
CREATE INDEX new_person_ LastName
on person (LastName)

Question:
Create unique index on “IndexNum” on Cust_Name attribute of Customer table.. (Marks 3)
Answer:-
CREATE INDEX IndexNum
ON Customer (Cust_Name)

2.one to one relation dia gay tha digram show krni thi page 89, page 143, page 144

3. RAID per column thy match krna tha page 258

4. 2 advantages of view
• Views are generally used to focus, simplify, and customize the perception each user has of the database
• Views can be used as security mechanisms by allowing users to access data through the view, without granting the users permissions to directly access the underlying base tables of the view
• view mechanism thus provides the support for logical data independence in the relational model

6. What is data redundancy / define redundancy in file processing system
It means if different systems of an organization are using some common data then rather than storing it once and sharing it, each system stores data in separate files. This creates the problem of redundancy or wastage of storage

7. Two types of lock modes thi
There are two primary modes for taking locks: optimistic and pessimistic.

Q.5: Student table is given below; write a SQL query to get all student names along with father names and address, which belongs to Lahore city.
Student (stu-id, stu-name, father-name, address, city)
Answer:
SELECT stu_name, father_name, address
FROM student
Where city=’Lahore’

Q.6: State the given statement is correct or incorrect justify your answer.
In recovery procedure, the transactions that have begin and an abort entry are redone.
Answer: Incorrect page 304
because
In recovery procedure, the transactions that have begin and an abort entry are ignored.

Q.7: Identify correct or incorrect justify your answer:
Cross Reference matrix is developed at the implementation phase of Database development process and its basic purpose is to communicate with user.
Answer: Incorrect
CRM is developed at the designing stage of the database. Page 65

Q.8: correct or incorrect justify:
“Query Execution” is faster with the help of indexes.
Answer: correct
Different types of database structures can be used for placement of data on disks, management of data in the forms of indexes and different database architecture is vital and leads to better retrieval and recovery of records

Q.9: correct or incorrect justify:
In recovery procedure, transaction that have a begin entry but does not have commit or rollback entry are redone.
Answer: Incorrect
Transactions that have a begin and no end entry (commit or rollback) are ignored

Q.10: “Check Point” is an entry in data dictionary.
Answer: incorrect page 304
Checkpoint is also a record or an entry in the log file.
plz share these answers

What is deadlock?
Deadlock is a situation when two transactions are waiting for each other to release a lock. The transaction involved in deadlock keeps on waiting unless deadlock is over.

Describe the main 3 factors of Index sequential file system.
Following are salient features of Indexed sequential file structure:
Records are stored in sequence and index is maintained.
Dense and nondense types of indexes are maintained.
Track overflows and file overflow areas are ensured.
Cylinder index increases the efficiency.

How to delete a view
Deleting Views: A view can be dropped using the DROP VIEW command, which is just like DROP TABLE.

10 marks question was like: the statements from last lectures were given and were asked to tell about correctness or Incorrectness. And also tell the reason.
Answer: mostly these statements are on page 304

approx 8 mcqs + 2 mark question was related to the Normal forms. Page 167
Normalization is basically; a process of efficiently organizing data in a database.
There are two goals of the normalization process:
Eliminate redundant data (for example, storing the same data in more than one table) and
Ensure data dependencies make sense (only storing related data in a table).

Write a query for creating the view (of the given info)
5. ek operation create krna tha to create a view type prdouct-name tha nd select all column of product

a) Create a view named CUSTOMER-LIST on CUSTOMER table to show only CST-ID in ascending order of those customers who belongs to Gujranwala City.
CREATE VIEW customer_list AS(select CST_ID
FROM customer
WHERE city=’Gujranwala’
ORDER BY CST_ID)

2. Analyze the statement given below and identify as correct or incorrect. Justify your answer in either case.

a) “It is a good approach to create an index on non-key attribute”.
Answer: yes it is a good approach
Secondary Indexes: Users often need to access data on the basis of non-key or non-unique attribute; secondary key. Like student name, program name, students enrolled in a particular program. Page 272

b) “Durability ensure that committed changes in the database can be lost due to any failure”.
Answer: Incorrect: Durability: Once a transaction has successfully committed, state changes committed by that transaction must be durable and persistent, despite any failures that occur afterwards. Page 292

[Amna]

“Query Execution” is faster with the help of indexes.

it is correct. because with the help of index we will see only few record not the whole file so it is faster.

[Amna]

Q: correct or incorrect. justify?
“Transaction is a dividable piece of work and execution of half transaction must be performed to preserve the data integrity”.
answer: A transaction is a set of changes that must all be made together. It is a program unit whose execution mayor may not change the contents of a database. Transaction is executed as a single unit.

Q: Suppose the employees of an organization are entering 500 entries per day on text based interface and you are required to design the graphical user interface (GUI) for that organization. Which of these options would you not like to adopt while designing the user interface.

- Internet browsing
- Image editing
- Text editing
- Shortcut keys
- Audio playback (correct option)

[+ M.Tariq Malik]

 Dazzling Bobby thanks for sharing  keep it up 

Attention Related Final Term papers Spring 2013: All Fellows You don’t need to go at any other site for current Final Term papers Spring  2013, Because All discussed data/sharing of our members in this discussion are going from here to other sites. (Other sites Admins/mods Copy from here & posted at their sites with fake IDs or original name: p). you can judge this at other sites yourself. So don’t waste your precious time with different links.

 

[Amna]

welcome. thanks for sharing ur point of view. plz pray for me. today is my paper at 10am :(

[Amna]

Create new view as Product_list from the table PRODUCT including all the columns of the table?

answer:
CREATE VIEW product_list AS (SELECT *
FROM product)

[Cyberian]

Dazzling Bobby in Quiz 5 you have to use SELECT * for all details instead of columns and then gave conditions WHERE city='lahore' like that...

[YAMNA]

 

MCQS was 80 % from MOAAZ file.

 

Q 1. Tell the abbreviation of ACID? Marks 2

Q 2. Read the statement if incorrect rewrite in correct form.

“Hashing provides slow, time consuming data retrieve from sequential files”. Marks 2

Q 3.What is the purpose of windows controls? Write two examples. Marks 2

Q 4. Matching colums…Symbols were given and we have to match them. Marks 2

Q.5: Analyze the statement check whether correct or incorrect justify in either case:
“Query Execution” is faster with the help of indexes. Marks 3
Q 6. Analyze the statement check whether correct or incorrect justify in either case:
  “A locking protocol is a set of rules to be followed by each database index.” Marks 3

Q 7: : Analyze the statement check whether correct or incorrect justify in either case:
        “In three schema architecture, External schema is responsible for data storage on hard disk”.  Marks 3

Q 8: : Analyze the statement check whether correct or incorrect justify in either case:
       “A statement was given”.  Marks 3

Q 9: 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)   Marks05

Q 10. 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)  Marks 5

Q 11 and 12  was of matching columns.  Marks 5 each.

 

 

[+ M.Tariq Malik]

YAMNA thanks for sharing ur paper 

Attention Related Final Term papers Spring 2013: All Fellows You don’t need to go at any other site for current Final Term papers Spring  2013, Because All discussed data/sharing of our members in this discussion are going from here to other sites. (Other sites Admins/mods Copy from here & posted at their sites with fake IDs or original name: p). you can judge this at other sites yourself. So don’t waste your precious time with different links.

 

[Amna]

Mcq===== Hash algorithm access time= O(1)
Q1: Write any two similarities between Materialized views and indexes? (Marks 2)
Answer:- (Page 290)
Materialized views are similar to indexes in several ways:
• They consume storage space.
• They must be refreshed when the data in their master tables changes.

Q2: Subtype discriminator? 2 marks

Q3: Attributes alias related tha. Without alias write this query again. 2 marks
SELECT p.pr_name INNER JOIN c.cr_name
p.pr_name=c.cr_name

Q4: collision? 2marks

Q5: create view about student. And display in ascending order? 3mark
Answer: CREATE VIEW view_name AS ( SELECT column_name
FROM table_name
ORDER BY column_name)
According to this syntax create view. When we did not mention ASC/DESC with ORDER BY then This query will return column_name in ascending order.

Q6: GUI related statement. (Something like that) we cannot view more than one form. 3marks

Q7: One to one relation was given. Between employee and parking space. Make ERD. 3marks
EMPLOYEE(emp_id, emp_name, address)
PARKING_SPACE(parking_id)

Q8: State the given statement is correct or incorrect justify your answer. 3 marks
In recovery procedure, the transactions that have begin and an abort entry are redone.
Answer: Incorrect page 304
Because
In recovery procedure, the transactions that have begin and an abort entry are ignored.

Q9: page 5 of moaaz file…. CREATE UNIQUE INDEX of D_ID wala question. 5marks

Q10: match column
Column A---------Column B
Strong key-------Can be good candidate key

Primary key------Independent existence

Secondary key----Dependent existence

Weak key---------May or maynot return any instance

Q:11 create view of PROFESSOR_LIST on PROFESSOR table. Display name who belongs to city ‘LAHORE ‘and Course ‘ALGORITHM’? 5marks
PROFESSOR(id, name, city, course)
Answer: CREATE VIEW PROFESSOR_LIST AS( SELECT name
FROM PROFESSOR
WHERE (city=’LAHORE’) OR (course=’ALGORITHM’))

Q12: match column
Column A------------Column B
Log file------------Direct access to data organization
Sequential index----Double access to data
index---------------Transactional file
(Index+data)--------Unique key

[Amna]

my todays paper cs403....shared above

25 mcqs out of 40 from moaaz file

[Amna]

Q:10 confirmed answers (5 marks)

strong entity and weak entity tha--------- now answer is

strong entity-------independent existence

primary key--------good candidate

secondary key-----may or maynot return any instance

weak entity--------dependent

Q:12 confirmed answr from book (5 marks)

log file---------------------transactional file

indexed sequential-------unique key

index-----------------------direct access to data organization

index+data----------------double access to data