CS403 Old paper 2009


Question No: 1     ( Marks: 1 )      - Please choose one
                                                   Which of the following statements is true about the views?
view is always a complete set of all the tables in a database
View can not be used for retrieving data
The results of using a view are not permanently stored in the database.
Rows can not be updated or deleted in the view


Question No: 2     ( Marks: 1 )      - Please choose one
What is the alternate name of Data Dictionary?
Index
Metadata
Data
System Catalog


Question No: 3     ( Marks: 1 )      - Please choose one
IN function helps reduce the need to use multiple AND conditions.
True
False

Question No: 4     ( Marks: 1 )      - Please choose one
                                                   Browser based forms are developed in the following tools EXCEPT
HTML
Scripting language
Front Page
Web-based Forms


Question No: 5     ( Marks: 1 )      - Please choose one
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


Question No: 6    ( Marks: 1 )      - Please choose one 
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
Physical Record and Denormalization Denormalizatiois a technique to move from higher to lower normal forms of database modeling in order to speed up database access. Denormalization
process is applied for deriving a physical data model from a logical form. In logical data basdesign we group things logically related through same primary key. In physicadatabase design fields are grouped, as they are stored physically and accessed by DBMS. In general it may decompose one logical relation into separate physical records, combine some or do both. There is a valid reason for denormalization that is
to enhance the performance.
Question No: 7    ( Marks: 1 )      - Please choose one


Which of the following gives all the fields from employee table named as EMP?
SELECT * from EMP;
SELECT emp* from EMP'

Question No: 8     ( Marks: 1 )      - Please choose one 
Which of the following types of partitioning reduces the chances of unbalanced partitions?
Hash
Hash Partitioning: It is a type of horizontal partitioning. In this type particular algorithm is applied anDBMS knows that algorithm. So hash partitioning reduces the chances of unbalanced


Question No: 9     ( Marks: 1 )      - Please choose one
While recovering data, which of the following files does a recovery manager examines at first?
A system file
Log file
Data dictionary
Metadata


Question No: 10    ( Marks: 1 )     - Please choose one
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
Indexed Sequential Summary:
Following are salient features of Indexed sequential file structure: Records are stored in sequence and index imaintained.
Dense and nondense types of indexes are maintained.
Track overflows and file overflow areas are ensured. Cylinder index increases the efficiency .


Question No: 13     ( Marks: 1 )      - Please choose one
ALTER TABLE exams
RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID. Syntax of ALTER TABLE is NOT correct.
True
False


Question No: 14     ( Marks: 1 )      - Please choose one
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


Question No: 15    ( Marks: 1 )     - Please choose one
Which of the following is not a form of optical disk?
CD ROM
WORM
Erasable Optical
EEPROM


Question No: 16     ( Marks: 1 )      - Please choose one
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


Question No: 17     ( Marks: 1 )      - Please choose one
In which of the following situations, Clustering is suitable:
Frequently updating
Relatively static
Relatively deletion
Relatively dynamic


Question No: 18     ( Marks: 1 )      - Please choose one
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




Question No: 19     ( Marks: 1 )      - Please choose one
Which of the following is NOT a component of a DFD? Select correct option:
Dataflow
Datastore
External entities
Relationship between external entities


Question No: 20     ( Marks: 1 )      - Please choose one
Laser records data by burning microscopic holes in the surface of the disk with a

Hard disk
RAM
Optical disk
Floppy disk
Optical disks record data by burning microscopic holes in the surface of the disk with a laser. To read the disk, another laser beam shines on the disk and detects thholes by changes in the reflection pattern.
Question No: 21     ( Marks: 1 )      - Please choose one
Which of the following concepts is applicable with respect to 3NF?
Full functional dependency
Any kind of dependency
Transitive dependency
Partial functional dependency


Question No: 22     ( Marks: 1 )      - Please choose one
Which of the following is NOT a feature of a good interface?
Consistency
Process based
Data structure based
User friendly



No comments:

Post a Comment