CLICK HERE FOR VARIOUS NEW JOBS 
CLICK HERE FOR VARIOUS EDUCATIONAL NEWS 
CLICK HERE FOR NEW SCHOLARSHIPS 
CLICK HERE FOR ADMISSION NOTICES 
Click And Follow On Google+ To Get Updates
Please Wait 10 Seconds... OR You CanSkip

ADMISSION NOTICES
Scholarships

Scholarship-300x291

BUDGET 2014-15
budget_2014-2015
New Date Sheets
VU SOLVED ASSIGNMENTS
Recent Posts

Posts Tagged ‘VU CS403-’

VU CS403- DATABASE MANAGEMENT SYSTEMS (Session -1) FINALTERM solved unsolved past papers Fall 2008

VU CS403- DATABASE MANAGEMENT SYSTEMS (Session -1) FINALTERM Solved Unsolved Past Papers Fall 2008

FINALTERM EXAMINATION

Fall 2008
CS403-Database Management Systems (Session -1)
Marks: 75

Question No: 1 ( Marks: 1 ) -Please choose one

Consider the following statements.

A. Conceptual schema which is the result of conceptual design is a logical description of all
data elements and their relationships.
B. Internal level of the database architecture consists of the physical view of the database.
C. External level of the database architecture provides the user view of the database.
With respect to the ANSI/SPARC three level database architecture, which of the above is/are
correct?
Only A.
Only C.
Only A and B.
Only B and C.
Question No: 2 ( Marks: 1 ) -Please choose one

Choose the symbol that corresponds to a discriminator attributes.

Question No: 3 ( Marks: 1 ) -Please choose one

Download Latest Papers: http://www.vumonster.com/viewPage.php?ID=Papers

WWW.VUMON S TER.COM

Which one of the following four E-R diagrams is the typical result you obtain
when you initially start with an E-R diagram containing just two entities, A and C,
in a Many-to-Many relationship, and then introduce an associative entity (B).

Question No: 4 ( Marks: 1 ) -Please choose one

GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT
OPTION;
What does this SQL statement do?

Grant permission to Amali,only to retrieve data from Employee table and grant permission to
Hiruni, only to update the designation from Employee table.
Grant permission to Amali & Hiruni to retrieve data from Employee table.
Grant permission to Hiruni in order to grant, select and update permission to Amali.
Grant permission to Amali and Hiruni to update all data except designation in Employee
table
Question No: 5 ( Marks: 1 ) -Please choose one

Download Latest Papers: http://www.vumonster.com/viewPage.php?ID=Papers

WWW.VUMON S TER.COM

Identify the command to delete a record in the table.

DELETE
DROP
INSERT
UPDATE
Question No: 6 ( Marks: 1 ) -Please choose one

How many clustered index(es) do each database table have?

2
3
5
1
Question No: 7 ( Marks: 1 ) -Please choose one

Which of the following is true about TRUNCATE?

Can be Rolled back.
Activates Triggers.
is DML Command.
Resets identity of the table.
Question No: 8 ( Marks: 1 ) -Please choose one

Which of the following constraints prevents any actions that would destroy links between
tables with the corresponding data values?

Download Latest Papers: http://www.vumonster.com/viewPage.php?ID=Papers

WWW.VUMON S TER.COM

NOT NULL
CHECK
PRIMARY KEY
FOREIGN KEY
Question No: 9 ( Marks: 1 ) -Please choose one

How many records do a DB view can display?

four or more
three or more
one or more
two or more
Question No: 10 ( Marks: 1 ) -Please choose one

Which of the following is true about application programs?

develop before the database design
Tools selection is made after the development database
meant to perform different operations by the user
must to design before the designing and developing database
Question No: 11 ( Marks: 1 ) -Please choose one

Which of the following is used to add or drop columns in an existing table?

Download Latest Papers: http://www.vumonster.com/viewPage.php?ID=Papers

WWW.VUMON S TER.COM

ALTER
HAVING
SELECT
THEN
Question No: 12 ( Marks: 1 ) -Please choose one

Which of the following is a correct way of selecting all the columns from a table
called PERSONS?

SELECT FROM * Persons
SELECT * FROM Persons
SELECT * WHERE Persons
SELECT WHERE * Persons
Question No: 13 ( Marks: 1 ) -Please choose one

Which of the following is incorrect with respect to indexed sequential files?

New records are added to an overflow file
Record in main file that precedes it is updated to contain a pointer to the
new record
The overflow is merged with the main file during a batch update
Multiple indexes for the same key field cannot be setup
Question No: 14 ( Marks: 1 ) -Please choose one

Download Latest Papers: http://www.vumonster.com/viewPage.php?ID=Papers

WWW.VUMON S TER.COM

What is the maximum limit of keys in context with Indexed sequential files?

7
255
1
235
Question No: 15 ( Marks: 1 ) -Please choose one

Which of the following is NOT a component of a DFD?

Dataflow
Datastore
External entities
Relationship between external entities
Question No: 16 ( Marks: 1 ) -Please choose one

Consider the following diagram depicting a kind of a relationship type where X and Z are entities and
Y is a relationship type:

Select the correct statement among the following on the above diagram.

Download Latest Papers: http://www.vumonster.com/viewPage.php?ID=Papers

WWW.VUMON S TER.COM

The relationship type Y is of cardinality ratio 1 : N.
The diagram depicts existence dependencies.
The participation of X in the Y relationship type is total.
The participation of Z in the Y relationship type is partial.
Question No: 17 ( Marks: 1 ) -Please choose one

If W, X, Y and Z are attributes of a relation, which of the following inference rules for functional
dependencies is correct?

If X
Y then Y -> X.
If X -> Y then (X, Z) -> (Y,W).

If X -> (Y,Z) then X -> Y.
If (X, Z) -> Y then X -> Y and Z -> Y.
Question No: 18 ( Marks: 1 ) -Please choose one

The information regarding views and Integrity constraints are found in
System Catalog

Data Dictionary
Indexes
Both Data Dictionary and System Catalog
Question No: 19 ( Marks: 1 ) -Please choose one

Which of the given techniques is/are used to improve query performance in database?

Download Latest Papers: http://www.vumonster.com/viewPage.php?ID=Papers

WWW.VUMON S TER.COM

Good File organization
Indexing
Both Indexing and Good File organization
Select only one record per query
Question No: 20 ( Marks: 1 ) -Please choose one

Which of the following is not true regarding Indexes?
Index can be defined even when there is no data in the table

It support Range selections
It can be created using Create Index
statement
It can not be created on composite attributes
Question No: 21 ( Marks: 1 ) -Please choose one

Which of the following is used to remove a DB view?
Del

Drop
Remove
Append
Download Latest Papers: http://www.vumonster.com/viewPage.php?ID=Papers

WWW.VUMON S TER.COM

Question No: 22 ( Marks: 1 ) -Please choose one

Which of following is not the feature of Indexes?

consume storage space.
must be refreshed when the data in their master tables changes
improve the performance of SQL execution when they are used for query rewrites
can be accessed directly using a SELECT statement
Question No: 23 ( Marks: 1 ) -Please choose one

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

A system file
Log file
Data dictionary
Metadata
Question No: 24 ( Marks: 1 ) -Please choose one

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

Constraints
Download Latest Papers: http://www.vumonster.com/viewPage.php?ID=Papers

WWW.VUMON S TER.COM

Relations
Check points
Transactions identities
Question No: 25 ( Marks: 1 ) -Please choose one

The main memory of a computer system is also known as

ROM
RAM
PROM
Hard disk
Question No: 26 ( Marks: 1 ) -Please choose one

Which of the following is not a feature of effective interface?

Effective interfaces can require more work to implement
An effective user interface minimizes the time users require to learn and
implement the system.
It helps users to accomplish their tasks and otherwise gets out of the way.
An effective interface imposes its requirements on users.
Question No: 27 ( Marks: 1 ) -Please choose one

Download Latest Papers: http://www.vumonster.com/viewPage.php?ID=Papers

WWW.VUMON S TER.COM

Which of the following is not a type of user interface?

Text based
Graphical User Interface (GUI)
Forms
DB tables
Question No: 28 ( Marks: 1 ) -Please choose one

_______is a control that enables users to select one option from an associated list; users
can also type an option.

Combo box
Button
Text box
Static area
Question No: 29 ( Marks: 1 ) -Please choose one

Which of the following is an example of non-volatile memory?

RAM
Main memory
Download Latest Papers: http://www.vumonster.com/viewPage.php?ID=Papers

WWW.VUMON S TER.COM

Flash memory
CPU
Question No: 30 ( Marks: 1 ) -Please choose one

Which of the following is an example of volatile memory?

RAM
ROM
Flash memory
CPU
Question No: 31 ( Marks: 1 )

What does 2PL stand for?

Question No: 32 ( Marks: 1 )

Which DML statement is used to modify rows of tables?

Question No: 33 ( Marks: 2 )

Briefly describe any two properties of Transactions?

Question No: 34 ( Marks: 2 )

In which situation do we need SELF JOIN?

Download Latest Papers: http://www.vumonster.com/viewPage.php?ID=Papers

WWW.VUMON S TER.COM

Question No: 35 ( Marks: 3 )

In context with Transaction, what does the ACID stand for?

Question No: 36 ( Marks: 3 )

Write any three advantages of standard SQL.

Question No: 37 ( Marks: 3 )

Shortly explain BYTE data field?

Question No: 38 ( Marks: 5 )

Write a statement to create a table named “Person”, with four columns. The column
names will be “LastName”, “FirstName”, “Address”, and “Age”.

Question No: 39 ( Marks: 5 )

Write any five features of VIEWS in databases.

Question No: 40 ( Marks: 10 )

Write the syntax to create an updatable view named ‘clerk’ of all clerks in the
‘employees’ table. Only the employees’ IDs, last names, department numbers, and
jobs are visible in this view, and these columns can be updated only in rows where
the employee is a kind of clerk (i-e either PU_CLER or SH_CLERK)

Question No: 41 ( Marks: 10 )

How does an RM (Recovery Manager) performs recovery procedure? What are check
points? Explain its importance in recovery procedure.

VU CS403- DATABASE MANAGEMENT SYSTEMS (Session -1) FINALTERM Solved Unsolved Past Papers Fall 2008

VU CS403- DATABASE MANAGEMENT SYSTEMS FINALTERM solved unsolved past papers

VU CS403- DATABASE MANAGEMENT SYSTEMS FINALTERM Solved Unsolved Past Papers

PROBLEM STATEMENT

Normalization

Assignment #3

CS403

Total Marks: 30

Note:

 

– Solve assignment yourself. If it is found that your assignment is copied with other student or from any of the internet resource, then both assignments will marked as zero. Don’t put assignment related question on MDB. For any further queries about assignments mail at:

– No assignment will be accepted after due date via email.

 

– If you are confused with any of the point or face any problem, send an e-mail on time, so that you can be guided before the assignment due date. No reply for assignment related e-mail would give before one day of last day of assignment submission. Once again, intimate about cheating from internet or any of class mate or friend. But, internet and students / group discussions are open for all students. No excuses are accepted, if cheating case is proved.

 

 

Purpose:

This assignment has been designed so that you would be able to have good concepts of:

  • Normalization

 

Before Starting:

  • You must have good concepts of the three normal forms

 

The Assignment:

Consider the given relation, Student_CreditHours

 

StuId

StuName

Age

Discipline

Credit-hours

4536

Ahmed Faraz

21

BCS

33

3452

Faisal Aslam

20

BCS

48

6154

Ahmed Ali

20

BBA

66

2112

Ahmed Faraz

19

BBA

84

7823

Aqeel Raza

24

MBA

12

5462

Hassan Ali

22

MCS

72

 

 

 

 

 

 

 

 

 

 

Where;

StuId => student Id

StuName => student name

Age => Age of the student

Discipline => The program in which the student is enrolled

Credit-hours => The number of credit hours earned so far

 

Primary Key: StuId, Discipline

 

Question Statement:

 

What change(s) do you suggest to normalize the above relation upto the 3rd normal form?

 

Important! Solution Table

 

 

You are required to fill the following table as the solution of your assignment:

 

Normal Form

Yes/No

Changes

First

 

Second

 

Third

 

 

 

 

 

 

 

 

 

 

 

 

 

How to fill the table:

 

  • Write “Yes” if the relation is in the respective normal form
  • Write “No” if the relation is in not in the respective normal form. In this case, you must suggest some changes which you want to make in the given relation to bring it into the respective normal form. These changes must be written in the “Changes” column.

 

 

What  to Submit

 

You are simply required to fill the solution table and send it as your assignment.

 

VU CS403- DATABASE MANAGEMENT SYSTEMS FINALTERM Solved Unsolved Past Papers

VU CS403- DATABASE MANAGEMENT SYSTEMS (Session – 5 ) FINALTERM solved unsolved past papers SPRING 2007

VU CS403- DATABASE MANAGEMENT SYSTEMS (Session – 5 ) FINALTERM Solved Unsolved Past Papers SPRING 2007

FINALTERM  EXAMINATION

SPRING 2007

CS403 – DATABASE MANAGEMENT SYSTEMS (Session – 5 )

 

Marks: 100

Time: 150min

 

StudentID/LoginID:

______________________________

Student Name:

______________________________

Center Name/Code:

______________________________

Exam Date:

Tuesday, July 10, 2007

 

Please read the following instructions carefully before attempting any of the questions:1.  Attempt all questions. Marks are written adjacent to each question.

2.  Do not ask any question about the contents of this examination from any one.

a.   If you think that there is something wrong with any of the questions, attempt it

     to the best of your understanding.

b.   If you believe that some essential piece of information is missing, make an

     appropriate assumption and use it to solve the problem.

c.   Write all steps, missing steps may lead to deduction of marks.

 3.   Exam is Closed Book. No handouts or extra material is allowed in exam hall other than rough sheet which will be provided by the examiner.

      4.   Use of cell phone during the examination is strictly prohibited,

otherwise strict disciplinary action will be taken as per university rules

 

 

 

For Teacher’s use only

Question

1

2

3

4

5

6

7

8

9

10

Total

Marks

Question

11

12

13

Marks

 

 

Question No: 1    ( Marks: 15 )
Write SQL queries for the following relations 

CUSTOMER (custId, name, address, city, province, postalCode, phone)

ORDER (orderNo, custId, invNo, datePlaced, datePromised, terms, status)

ORDER_LINE (orderLineNo, orderNo, pCode, qty)

INVOICE (invNo, custId, orderNo, date, status)

INVOICE_LINE (invLineNo, invNo, pCode, qtyShip)

PRODUCT (pCode, pName, pDescription)

 

a)      Delete a customer’s record whose name is zafar and city is Karachi.

b)     List all the product names in descending order whose quantity shipped is less than 5000.

c)      List all the invoice numbers whose product code is 12.

d)     List all the order numbers whose quantity is more than 2500.

e)      Create a view containing the following attributes from the CUSTOMER and ORDER relations.

 

CUSTOMER (custId, name, address)

ORDER (orderNo, datePlaced, status)  

 

 

 

Question No: 2    ( Marks: 6 )
Differentiate between the followings.                

Horizontal and Vertical partitioning.

 

 

 

Question No: 3    ( Marks: 25 )
Differentiate between the followings? 

a)      Differentiate committed and rollback transaction

b)     What are the major differences in clustered and non clustered indexes?

c)      What is the difference between detection and prevention schemas of dead lock prevention?

d)     What is the difference b/w Equi-join and Natural join?

 

 

 

Question No: 4    ( Marks: 20 )
Normalize the given data table up to 3NF. 

(Student#  ,   Advisor ,    Adv-Room  ,    Class1  ,   Class2   ,   Class3)

 

 

 

Question No: 5    ( Marks: 18 )
a)    What is transaction? Differentiate between pre-emptive and non pre-emptive transactions.

b)   Why we need sub query? Explain in detail.

 

 

 

Question No: 6    ( Marks: 2 )     –  Please choose one
Select the activity that is most clearly part of the Database Administrator’s responsibility.

►  Performance tuning 
►  Data modification 
►  Data deletion 
►  Data entry 

 

 

Question No: 7    ( Marks: 2 )     –  Please choose one
Which normalisation transformation corresponds to “Eliminating partial key dependencies”?

►  unnormalised to 1NF 
►  1NF to 2NF 
►  2NF to 3NF 
►  3NF to BCNF 

 

 

Question No: 8    ( Marks: 2 )     –  Please choose one
Locking was introduced into databases so that

►  Keys can be provided to maintain security 
►  All simultaneous transactions are prevented 
►  Passwords can be provided to maintain security 
►  Consistency can be enforced 

 

 

Question No: 9    ( Marks: 2 )     –  Please choose one
A back-up and recovery regime should protect an organisation against:

►  incorrect data 
►  corrupt media 
►  insecure data 
►  data validation 

 

 

Question No: 10    ( Marks: 2 )     –  Please choose one
SQL has ———– types of commands

► 
► 
► 
► 

 

 

Question No: 11    ( Marks: 2 )     –  Please choose one
Transactions are often referred to in terms of ACID. Which one of the following is not part of the term ACID?

►  Atomic 
►  Isolation 
►  Durable 
►  Complete 

 

 

Question No: 12    ( Marks: 2 )     –  Please choose one
In ——- type of partitioning table is split on the basis of rows

►  Horizontal 
►  Vertical 
►  Parallel 
►  None of the given 

 

 

Question No: 13    ( Marks: 2 )     –  Please choose one
Which of the following is a good example of what is meant by?“Serialisability”

►  All disk access happens one after another 
►  The result of the transactions is the same as if the transactions wentone after another

 

►  The situation where the Lost Update problem exists 
►  All transactions happen one after another 

 

 

 

 

VU CS403- DATABASE MANAGEMENT SYSTEMS (Session – 5 ) FINALTERM Solved Unsolved Past Papers SPRING 2007

ALL NEW RESULTS
Educational News

Updated Educational News

Categories
POSTS BY DATE
December 2016
M T W T F S S
« Sep    
 1234
567891011
12131415161718
19202122232425
262728293031