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 Which of the following is one of the purposes of using DML commands? Creating databases Destroying databases Inserting data in tables Non of the above
2 You can’t modify more than one table at a time through a view. True False Not Sure
3 An entity can be logically connected to another by defining a ____. hyperlink common attribute primary key superkey
4 An entity type is defined when the database is actually constructed a specific type such as an integer, text, date, logical etc a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR) defined by the database designer
5 Which of the following is disadvantage of chaining technique to handle the collisions? Unlimited Number of elements Fast re-hashing Overhead of multiple linked lists Maximum number of elements must be known
6 Only one type of constraint can be enforced in any table by CREATE command True False Not Sure
7 In which of the following situations, Clustering is suitable: Frequently updating Relatively static Relatively deletion Relatively dynamic
8 Which of the following is the correct description of cache hit? When data is found in the cache When data is removed in the cache The number of times the cache is accessed directly by the processor When data is lost from the cache
9 Which of the following is not a form of optical disk? CD ROM WORM Erasable Optical EEPROM
10 Browser based forms are developed in the following tools EXCEPT HTML Scripting language Front Page Web-based Forms
Download This Set