VU CS-403 Online Test Preparation

CS-403 Final Term Exams Preparation Virtual University

Sr. #	Questions	Answers Choice
1	Materialized views and Indexes are NOT similar by the following way(s).	hey consume storage space They must be refreshed when the data in their master tables changes They can be accessed directly using a SELECT statement All of the Given
2	In SQL queries, while creating tables or relations in database, key columns may be specified by	Data type Null Not Null Owner
3	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
4	Which of the following is not a type of user interface?	Graphical User Interface (GUI) Forms DB tables Text based
5	Which of following is not the feature of Indexes?	consume storage space must be refreshed when the data in their master tables changes improve the performance of SQL execution when they are used for query rewrites can be accessed directly using a SELECT statement
6	The information regarding ‘views’ and ‘Integrity constraints’ are found in	Both Data Dictionary and System Catalog System Catalog Data Dictionary Indexes
7	A relation (from the relational database model) consists of a set of tuples, which implies th	Relational model supports multi-valued attributes whose values can be represented in sets. for any two tuples, the values associated with all of their attributes may be the same for any two tuples, the values associated with one or more of their attributes must differ. all tuples in a particular relation may have different attributes.
8	Which of the following is incorrect with respect to indexed sequential files?	New records are added to an overflow file Record in main file that precedes it is updated to contain a pointer to the new record The overflow is merged with the main file during a batch update Multiple indexes for the same key field cannot be setup
9	Which of the following is true about application programs?	develop before the database design Tools selection is made after the development database meant to perform different operations by the user must to design before the designing and developing database
10	Which of the following is NOT a feature of HASH ACCESS?	indexes to search or maintain Very fast direct access Inefficient sequential access Use when direct access is needed, but sequential access is not.

Download This Set