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
Tags:
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
“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.
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)
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.
welcome. thanks for sharing ur point of view. plz pray for me. today is my paper at 10am :(
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)
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...
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.
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.
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
my todays paper cs403....shared above
25 mcqs out of 40 from moaaz file
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
© 2021 Created by + M.Tariq Malik.
Powered by
Promote Us | Report an Issue | Privacy Policy | Terms of Service
We non-commercial site working hard since 2009 to facilitate learning Read More. We can't keep up without your support. Donate.
We are user-generated contents & non-commercial site. All product, videos, pictures & others contents on site don't seem to be beneath our Copyrights & belong to their respected owners & freely available on public domains. All Contents on site are for personal & non-commercial use.We believe in Our Policy & do according to them. If Any content is offensive in your Copyrights then please email at m.tariqmalik@gmail.com with copyright detail & We will happy to remove it immediately.
Management: Admins ::: Moderators
Awards Badges List | Moderators Group
All Members | Featured Members | Top Reputation Members | Angels Members | Intellectual Members | Criteria for Selection
Become a Team Member | Safety Guidelines for New | Site FAQ & Rules | Safety Matters | Online Safety | Rules For Blog Post