CS403 Final Term Current Paper (Feb 2011)
objective koe nae past ppr sy aya.........bas thora thora aya tha.............subjective molahiza farmaye.........
1-Name 2 types of ordered indices? (2)
(saara ppr main zahen pr zoor daity rahy akhir kar last main yaad a hi gea.......;p)
2-Briefly explain any 2 property of transactions? (2)
(briefly v likha hai n explain v likha hai wo v 2 marks ka....haad nae ho gae....)
3-In which sitiuation it is require to use a join? (2)
4-what is meant by Inter Schema Mapping (2)
(is main apna concept lika.....ataa nae tha........;p)
5-how do the time stamping approch works to give priorties tothe transaction? (3)
(shukr hai akhei wakt main me yahi prh rae thi......)
6-how can we identify records in case of sequential files (3)
(is main main ny apna concept likha......aata nae tha........;p)
7-what is purpose of IN operator?
8-what does controlled redundacy as a advantages of database system mean? (3)
(yai to mid hi wala tha....kr lia)
9-Briefly eplain 3rd normal form (5)
(yai v mid wala tha.....ho gea)
10-what is the significance of check point in recovery procedure.How it is used in recovery procedure (5)
(last time peha tha........kr hi lia thora thora)
11-shortly eplain index?give 2 types of indexes (5)
(mostly mcqs idex pr thy....main ny copy paste wahein sy vaikh kr kr liya.....;p)
12-wo question ganda tha........mjy pasad nae aya.....aur choor dia.......query likhni thi........:/
to at the end ............ tiare achi achi krna...........:p
......................
Another Paper:
Some Questions which I could remember.
Difference b/w COMMIT and ROLLBACK (2)
Define the domain of attribute? (2)
What is the purpose of protection? (3)
What is the main objective Concurrency Control? (5)
...................
Another Paper:
FILE opertations and examples with sql? (5)
3 Transations problems
Importance of NOt NUll ? (5)
......................
Another Paper:
In which situation join is used?
Join
Joins can be used in SELECT, UPDATE and DELETE statements.
What is serial execution?
Serial execution is when tasks are completed consecutively (one after the other), as opposed to concurrently (at the same time, in parallel).
Write three advantages of views?
Advantages of views:
1. View the data without storing the data into the object.
2. Restict the view of a table i.e. can hide some of columns in the tables.
3. Join two or more tables and show it as one object to user.
4. Restict the access of a table so that nobody can insert the rows into the table.
Disadvatages:
1. Can not use DML operations on this.
2. When table is dropped view becomes inactive.. it depends on the table objects.
3. It is an object so it occupies space.
What are locking protocols, explain?
What is rehashing?
One has to use 'rehash' to get
table and field completion. This gives a quicker start of
mysql and disables rehashing on reconnect. WARNING:
options deprecated; use --disable-auto-rehash instead.
In which situation self join is used?
Self Join is nothing but a table joining with itself.
It is very helpful to fetching duplicate data from a table..
if we want to fetch the emp_id from emp whice are duplicate in emp tab.
examp:
select a.emp_id b.emp_id
from emp a emp b
where a.emp_id=b.emp_id and
a.rowid<>b.rowid.
we can get duplicate value easily by help of self join
Why direct access is preferred over sequential access?
Disk storage has several characteristics to recommend it: it is physically secure, requiring no handling; it provides both sequential and direct access to records; and it is reasonable in cost. These factors make disk storage the preferred medium today.
While tape storage is relatively simple, disk storage can be complex. Although sequential access on disk is no more complex than on tape, direct access may involve complex file structures. Efficient use of these structures requires an understanding of the physical medium and the operating system components that perform the actual reading and writing of data on the disk.
.......................
Another Paper:
Dear Fellows in paper of CS 403 following were few questions that i m able to keep in memory
Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?
► 24
► 32
► 12
► 16
Which of the following is not one of the properties of Transaction?
► atomicity
► consistency
► redundancy
► durability
Which of the following is NOT a feature of Indexed sequential files?
► Records are stored in sequence and index is maintained.
► Dense and nondense types of indexes are maintained.
► Track overflows and file overflow areas can not be ensured.
► Cylinder index increases the efficiency
Which of the following serves as a milestone or reference point in the log file?
► Constraints
► Relations
► Check points
► Transactions identities
Which of the following is not true regarding DB transactions?
► A set of database operations that are processed partly
► A database transaction is a logical unit of database operations
► A database transaction must be atomic
► A database transaction must contains the ACID property
Which of the following are the general activities, which are performed during the development of application programs?
► Data input programs
► Editing
► Display
The main memory of a computer system is also known as
► ROM
► RAM
► PROM
► Hard disk
The main memory of a computer system is also known as
► ROM
► RAM
► PROM
► Hard disk
While recovering data, which of the following files does a recovery manager examines at first?
► A system file
► Log file
► Data dictionary
► Metadata
What is the alternate name of Data Dictionary?
► Index
► Metadata
► Data
► System Catalog
Which of the following statements are Data Definition Language command?
► INSERT
► UPDATE
► GRANT
► TRUNCATE
Questions were
1) Difference Bet Delete Table and Drop Table?
2) Commanlities bet Materialized View and Indexes?
3)Difference bet partial Completeness and Total Completeness Constraints
4)What is Entity Extension?
Pray For me as well
Thx
► All of given
