1. SELECT FROM EMP for salary>10000 will do following
- selects all columns from employee table which have salary>30000
- selects and displays all columns from employee table which have salary>30000
- Invalid syntax
- None of the above
2. Entity Relationship Model is used for
- describing the process flow of the system
- designation database
- describe the entities of the information system and their relations
- all of above
3. Mark the property not contained in relational database
- collection of tables
- SQL of data retrieval and changes
- data independence
- connections to data through pointers
4. Mark the false statement about the primary key constraint of RDBMS
- primary key may be foreign key in another table
- primary key may contain missing values
- primary key can contain atomic values
- primary key has unique values
5. Which keyword is not used with the select command in SQL?
- where
- from
- group by
- create
6. Mark the property not applicable in RDBMS
- No duplicate table name
- No duplicate row
- Row order is insignificant
- values at the intersection or row and column are breakable
7. Which rule helps to maintain referential integrity in database?
- foreign key values should always be matched by corresponding primary key values
- null values should not be used in database
- null value of one attribute is always equal to null value of other attributes
- value of concatenated key must be unique
8. A key that is on the multiple side of ‘one-to-many’ relationship is known as
- primary key
- Foreign key
- secondary key
- none of the above
9. The ascending order of a data hierarchy is :
- bit-byte-record-field-file-database.
- byte-bit-field-record-file-database
- bit-byte-field-record-file-database
- bit-byte-field-record-file-database
10. which of the following hardware components is the most important to the operation of database management system?
- high-resolution video display
- printer
- high-speed, large capacity disk
- plotter