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 Laser records data by burning microscopic holes in the surface of the disk with a Hard disk RAM Optical disk Floppy disk
2 Which of the following is NOT a component of a DFD? Select correct option: Dataflow Datastore External entities Relationship between external entities
3 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’ DELETE WHERE person FROM employee_id = 12345 DROP FROM person WHERE employee_id = 12345 DELETE WHERE person WHERE employee_id = 12345
4 ALTER TABLE exams
RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID. Syntax of ALTER TABLE is NOT correct.
 True False Not Sure
5 Which of the following is NOT a feature of Indexed sequential files? Records are stored in sequence and index is maintained Dense and nondense types of indexes are maintained Track overflows and file overflow areas can not be ensured. Cylinder index increases the efficiency
6 While recovering data, which of the following files does a recovery manager examines at first? A system file Log file Data dictionary Metadata
7 Which of the following gives all the fields from employee table named as EMP? SELECT * from EMP; SELECT emp* from EMP' SELECT emp_id where EMP; SELECT * where EMP;
8 Which of the following is not true about De-normalization? It is the process of attempting to optimize the performance of a database De-normalization is a technique to move from lower to higher normal forms of database modeling It enhances the performance of DB In de-normalization it is required to add redundant data.
9 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
10 What is the alternate name of Data Dictionary? Index Metadata Data System Catalog
Download This Set
×