.::VULMSIT::.eNoxel CS403 - Final TERM Paper Solved / Unsolved Materials

WWW.VUMON S TER.COM


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.

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


CS403 - Final TERM Paper Solved / Unsolved Materials

On Sat, Jun 23, 2012 at 6:35 PM, Umair Saulat <saulat.umair@googlemail.com> wrote:

CS403 - Final TERM Paper Solved / Unsolved Materials

--
Zindagi mein 2 Logo ka buhat khayal rahkoooo

Ist woh jiss ney tumhari jeet ke Liye buhat kuch hara hoo (Father)

2nd woh jiss ko tum ney har dukh me pukaara hoo (Mother)

Regards, 

Umair Saulat

--
Zindagi mein 2 Logo ka buhat khayal rahkoooo

Ist woh jiss ney tumhari jeet ke Liye buhat kuch hara hoo (Father)

2nd woh jiss ko tum ney har dukh me pukaara hoo (Mother)

Regards, 

Umair Saulat

--
Virtual University of Pakistan*** IT n CS Blog
================================
http://www.geniusweb.tk
 
http://itncs.tk
 
 
You received this message because you are subscribed to the Google
Groups "vulms" group.
To post to this group, send email to vulmsit@googlegroups.com
To unsubscribe from this group, send email to
vulmsit+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/vulmsit?hl=en?hl=en