CS403 - Data Base Managment System Final Term

by **winnersgroup** Sun Feb 13, 2011 11:47 am

Dear Friends

AOA

I have given CS-403 DBMS paper. Most of the MCQ's are from past papers. Some subjective questions which i remeber are:

What is the purpose of IN Fucntions?
In which situation join is used?
What is serial execution?
Write three advantages of views?
What are locking protocols, explain?
What is rehashing?
In which situation self join is used?
Why direct access is preferred over sequential access?

Best of luck for your exams!

by Asad Sun Feb 13, 2011 11:48 am

Jazaak Allah

by Asad Sun Feb 13, 2011 11:48 am

1.Application programmer as user of database systems, (5)
2.different b/w rollback and rollforward.(5)
3.why will you prefer delete command on drop command while deleting a table,(5)
4.how many number of clusters are used in database and reason of limit,
5.purpose of having clause,
6.purpose of protection,
7.explain data independency
8.two types of interface,
9.write DML statement that changes the values of one or more than one attribute based on some condition.
10.describe insertion anomaly,
11.COMMIT and ROLLBACK

by **winnersgroup** Sun Feb 13, 2011 11:48 am

1.Application programmer as user of database systems, (5)
2.different b/w rollback and rollforward.(5)
3.why will you prefer delete command on drop command while deleting a table,(5)
4.how many number of clusters are used in database and reason of limit,
5.purpose of having clause,
6.purpose of protection,
7.explain data independency
8.two types of interface,
9.write DML statement that changes the values of one or more than one attribute based on some condition.
10.describe insertion anomaly,
11.COMMIT and ROLLBACK

by **winnersgroup** Sun Feb 13, 2011 11:50 am

by Asad Sun Feb 13, 2011 11:50 am

People the paper is quite lengthy(and the dusty keyboards makes it more lengthy [You must be registered and logged in to see this image.] )
52 questionions
42(objectives)
What is the difference between Commit and rollback?(2marks)
What is the problem which occur in normalization of 1 form of normalization(2marks)
Why will u prefer direct access over sequential access?(2marks)
This question i have forgotten(5marks)
What type of information is stored in data dictionary?(3marks)
What problem occurs when data concurrency is not controlled?(3marks)
What is the purpose of file protection?(3marks)
What are database objects?(5marks)
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 Ali(5marks)
What is unary and ternary Relationship?(5marks)

by **winnersgroup** Sun Feb 13, 2011 11:52 am

[You must be registered and logged in to see this link.] Happy

by Abir Sun Feb 13, 2011 12:54 pm

thankx alot kiss

by Abir Sun Feb 13, 2011 12:55 pm

thankx alot kiss

by Asad Mon Feb 14, 2011 12:17 pm

download today paper

Attachments

: cs403 today paper.doc You don't have permission to download attachments.(21 Kb) Downloaded 40 times

by **winnersgroup** Tue Feb 15, 2011 2:12 pm

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)

by **winnersgroup** Tue Feb 15, 2011 2:13 pm

My cs403 subjective questions

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.

by **winnersgroup** Tue Feb 15, 2011 2:13 pm

FILE opertations and examples with sql? (5)
3 Transations problems
Importance of NOt NUll ? (5)

by **winnersgroup** Tue Feb 15, 2011 2:15 pm

Dear Fellows in paper of CS 403 following were few questions that i m able to keep in memory
[You must be registered and logged in to see this link.]
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
[You must be registered and logged in to see this link.]

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
[You must be registered and logged in to see this link.]

Which of the following serves as a milestone or reference point in the log file?

► Constraints

► Relations

► Check points

► Transactions identities
[You must be registered and logged in to see this link.]

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
[You must be registered and logged in to see this link.]

Which of the following are the general activities, which are performed during the development of application programs?

► Data input programs

► Editing

► Display
[You must be registered and logged in to see this link.]

The main memory of a computer system is also known as

► ROM

► RAM

► PROM

► Hard disk
[You must be registered and logged in to see this link.]

The main memory of a computer system is also known as

► ROM

► RAM

► PROM

► Hard disk

[You must be registered and logged in to see this link.]

While recovering data, which of the following files does a recovery manager examines at first?

► A system file

► Log file

► Data dictionary

► Metadata
[You must be registered and logged in to see this link.]

What is the alternate name of Data Dictionary?

► Index

► Metadata

► Data

► System Catalog

Which of the following statements are Data Definition Language command?
[You must be registered and logged in to see this link.]
► 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
[You must be registered and logged in to see this link.]
4)What is Entity Extension?

Pray For me as well

Thx
[You must be registered and logged in to see this link.]
► All of given