Placement papers on Database - Set 2

Placement papers on Database - Set 2

1. What are the important criteria for designing tables

Meaningful grouping of attribute
No redundancy
No inapplicable attribute
All the above
View Answer / Hide Answer


2. What is the language used by most of the DBMSs for helping their users to access data?

High level language
SQL
Query Language
4GL
View Answer / Hide Answer


3. Which database level is closest to the users?

External
Internal
Physical
Conceptual
View Answer / Hide Answer


4. Which is not a function of aggregate function?

Count
Avg
Create
Max
View Answer / Hide Answer


5. Which is the make given to the database management system which is able to handle full text data, image data, audio and video?

full media
graphics media
multimedia
hypertext
View Answer / Hide Answer


6. Which of the following are the properties of entities?

Groups
Table
Attributes
Switchboards
View Answer / Hide Answer


7. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?

report writer
query language
data manipulation language
transaction log
View Answer / Hide Answer


8. Which of the following database object does not physically exist?

Base table
Index
View
None of the above
View Answer / Hide Answer


9. Which of the following fields in a student file can be used as a primary key?

class
Social Security Number
GPA
Major
View Answer / Hide Answer


10. Which of the following hardware component is the most important to the operation of database management system?

high resolution video display
printer
high speed, large capacity disk
plotter
View Answer / Hide Answer