FINALTERM EXAMINATION
Fall 2009
CS403- Database Management Systems


Time: 120 min
Marks: 75


Question No: 1 ( Marks: 1 ) - Please choose one
_______ records data by burning microscopic holes in the surface of the disk with a
laser.


► Hard disk
► RAM
► Optical disk
► Floppy disk


Question No: 2 ( Marks: 1 ) - Please choose one
______ is a control that presents a set of choices from which a user can select one or more items; items can be text, graphics, or both.


► Text input
► Report
► Button
► List box


Question No: 3 ( 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: 4 ( Marks: 1 ) - Please choose one
_______ is a control that users click to perform an action, set or toggle a state, or set an option.


► Button
► Text box
► Input form
► Report


Question No: 5 ( Marks: 1 ) - Please choose one
Which of the following is not true about input forms?

► Provide an easy, effective, efficient way to enter data into a table
► Especially useful when the person entering the data is not familiar with the inner workings
► Provide different controls to add data into the tables
► One input forms can populate one table at a time


Question No: 6 ( Marks: 1 ) - Please choose one
Browser based forms are developed in the following tools EXCEPT


► HTML
► Scripting language
► Front Page
► Web-based Forms


Question No: 7 ( Marks: 1 ) - Please choose one
Which of the following are the general activities, which are performed during the development of application programs?


► Data input programs
► Editing
► Display
► All of given


Question No: 8 ( Marks: 1 ) - Please choose one
Which of the following should not be a property of a database transaction?


► Atomicity
► Isolation
► Durability
► Divergence


Question No: 9 ( Marks: 1 ) - Please choose one
The main memory of a computer system is also known as


► ROM
► RAM
► PROM
► Hard disk


Question No: 10 ( 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: 11 ( Marks: 1 ) - Please choose one
Which of the following is the correct way of removing the Index called branchNoIndex?

► DROP INDEX branchNoIndex;
► APPEND INDEX branchNoIndex;
► REMOVE INDEX branchNoIndex;
► DEL INDEX branchNoIndex;


Question No: 12 ( Marks: 1 ) - Please choose one
What is the alternate name of Data Dictionary?

► Index
► Metadata
► Data
► System Catalog


Question No: 13 ( 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: 14 ( Marks: 1 ) - Please choose one
Identify the correct statement.

► Referential integrity constraints check whether the primary key values are unique.
► Referential integrity constraints check whether an attribute value lies in the given range.
► Referential integrity constraints are specified between entities having recursive relationships.
► When Referential integrity rules are enforced, a tuple in one relation that refers to another
relation must refer to an existing tuple.


Question No: 15 ( Marks: 1 ) - Please choose one
Select the correct statement among the following on proper naming of schema constructs:


► Entity type name applies to all the entities belonging to that entity type and therefore a plural name is selected for entity type.
► In the narrative description of the database requirements, verbs tend to indicate the names of
relationship types.
► The nouns arising from a database requirement description can be considered as names of attributes.
► Additional nouns which are appearing in the narrative description of the database
requirements represent the weak entity type names.


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:


CS403.jpg

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

► 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
Identify the correct statement about ANSI/SPARC architecture.


► The external level is not concerned with individual user perceptions
► The internal level, in a database system, will always be relational
► Any given database has exactly one conceptual schema and one physical schema, but it may have several external schemas.
► A data definition language is used to define the internal schema.


Question No: 18 ( Marks: 1 ) - Please choose one
Which of the following SQL commands deletes a record of an employee with the employee_id 12345, from a table named PERSON.

► DELETE FROM person
WHERE employee_id = 12345
► DELETE WHERE person
FROM employee_id = 12345
► DROP FROM person
WHERE employee_id = 12345
► DELETE WHERE person
WHERE employee_id = 12345

Sponsored Links





Question No: 19 ( Marks: 1 ) - Please choose one
Which of the following is NOT a feature of a good interface?

► consistency
► process based
► data structure based
► user friendly

Question No: 20 ( Marks: 1 ) - Please choose one
Identify the correct statement with respect to normalization.


► Normalization is a formal technique that can be used only at the starting phase of the database design.
► Normalization can be used as a top-down standalone database design technique.
► The process of normalization through decomposition must achieve the lossless join
property at any cost whereas the dependency reservation property is sometimes
sacrificed.
► The process of normalization through decomposition must achieve the dependency
reservation property at any cost whereas the lossless join property is sometimes
sacrificed.


Question No: 21 ( Marks: 1 ) - Please choose one
Which of the following concept is applicable with respect to 2NF?


► Non-transitive dependency
► Full functional dependency
► Partial dependency
► Transitive dependency

Question No: 22 ( Marks: 1 ) - Please choose one
Suppose there are 4 fields in a table named CUST (customer_id, first_name, last_name, phone). Which of the following gives all the information of the customers in the table whose last name is ALI?

► SELECT * FROM CUST WHERE last_name='ALI';
► SELECT * FROM CUST WHERE last_name=ALI;
► SELECT * FROM CUSTOMER WHERE name=ALI;
► SELECT * FROM CUSTOMER WHERE last_name=ALI;

Question No: 23 ( Marks: 1 ) - Please choose one
Which of the following is INCORRECT about VIEWS?

► It is not possible to left out the data which is not required for a specific view.
► A database view displays one or more database records on the same page.
► Views can be used as security mechanisms
► Views are generally used to focus the perception each user
has of the database.


Question No: 24 ( Marks: 1 ) - Please choose one
Identify the advantage of DELETE command over TRUNCATE.

► Can be Rolled back.
► is DDL Command.
► cannot activate a trigger.
► faster and uses fewer system


Question No: 25 ( 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: 26 ( Marks: 1 ) - Please choose one
Which of the following statements is true about the views?

► view is always a complete set of all the tables in a database
► View can not be used for retrieving data
► The results of using a view are not permanently stored in the database.
► Rows can not be updated or deleted in the view


Question No: 27 ( Marks: 1 ) - Please choose one
Which of the following statements are Data Definition Language command?


► INSERT
► UPDATE
► GRANT
► TRUNCATE


Question No: 28 ( Marks: 1 ) - Please choose one
Which of the following statements are Data Manipulation Language command?


► INSERT
► GRANT
► TRUNCATE
► CREATE


Question No: 29 ( 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: 30 ( Marks: 1 ) - Please choose one
Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of


► Physical data independence.
► Concurrency control.
► Logical data independence.
► Functional dependency

Question No: 31 ( Marks: 1 )
What is Ordering field?


Question No: 32 ( Marks: 1 )
Which clause is used to sort the records in the result set?

Question No: 33 ( Marks: 2 )
What is the major benefit of HASH paritioning?

Question No: 34 ( Marks: 2 )
How can we prevent deadlocks for concurrent Transactions?

Question No: 35 ( Marks: 3 )
State the major disadvantage of creating and using index.


Question No: 36 ( Marks: 3 )
Write any three factors which we consider while defining key in designing an indexed sequential file?

Question No: 37 ( Marks: 3 )
How do you select all records from the table using SQL statements? Write the syntax.


Question No: 38 ( Marks: 5 )
How can a VIEW be used for security measures?

Question No: 39 ( Marks: 5 )
In which situtation do you prefer DELETE command to delete a table instead of using DROP command?

Question No: 40 ( Marks: 10 )
Write four advantages and four disadvantages of De-normalization.


Question No: 41 ( Marks: 10 )
Explain and differentiate the two types of application users:
• Intermediate
• Expert