FINALTERM EXAMINATION
Fall 2008
CS403- Database Management Systems (Session - 3)
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: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
WHERE employee_id = 12345
► DELETE WHERE person
FROM employee_id = 12345
FROM employee_id = 12345
► DROP FROM person
WHERE employee_id = 12345
WHERE employee_id = 12345
► DELETE WHERE person
WHERE employee_id = 12345
WHERE employee_id = 12345
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 GRANTOPTION;
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
www.allvupastpapers.blogspot.com
AdeelAbbasbk@gmail.com
No comments:
Post a Comment
PLEASE COMMENT ABOUT YOUR VISIT AND MY SITE
Note: Only a member of this blog may post a comment.