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 A superkey that does not contain a subset of attributes that is itself a superkey is called a ___ candidate key primary key superkey secondary key
2 A software package designed to store and manage databases Database DBMS Data model Data
3 In which of the following, Materialized Views are suitable Data warehousing Decision support Mobile computing All of the Given
4 ALTER TABLE exams ALTER COLUMN Q_description varchar(50) Syntax of ALTER TABLE is NOT correct. True False Not Sure
5 Partitions may become unbalanced in: Range partitioning Hash partitioning List partitioning Vertical partitioning
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 users click to perform an action, set or toggle a state, or set an option. Button Text box Input form Report
8 Which of the given techniques is/are used to improve query performance in database? Good File organization Indexing Both Indexing and Good File organization Select only one record per query
9 What is the impact of setting multiple indexes for the same key, in index sequential file Multiple indexes for the same key can not be set It increases efficiency It decreases efficiency It will increase complexity as the access time will be increased
10 What is the maximum limit of keys in context with Indexed sequential files? 7 255 1 235
Download This Set
×