CS-403 Final Term Exams Preparation Virtual University With Answers

image
image
image

CS-403 Final Term Exams Preparation Virtual University

Sr. # Questions Answers Choice
1 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
2 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.
3 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;
4 Which of the following should not be a property of a database transaction? Atomicity Isolation Durability Divergence
5 _______ 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
6 _______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
7 ______ 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
8 _______ records data by burning microscopic holes in the surface of the disk with a laser. Hard disk RAM Optical disk Floppy disk
9 In a conceptual model for a university, what type of relationship exists between Grade and Student entitie 1:1 1:M M:M Ternary
10 The ____ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype. specialization uniqueness inheritance completeness
Download This Set
×