Have an account?
Skip to Content
Build your own quiz
20 questions
Show Answers
See Preview
- 1. Multiple ChoiceThe following are functions of a DBMS exceptCreating databaseProcessing dataCreating and processing formsAdministrating database
- 2. Multiple ChoiceThe DBMS that most difficult to use is ________Microsofts SQL ServerOracle Corporation OracleMicrosoft AccessIBM DB2
- 3. Multiple ChoiceDuplicate data often results in loss of data integrity because:A. Data formats may be inconsistentB. Data values may not agreeNeither A & BBoth A & B
- 4. Multiple ChoiceA database management system (DBMS) is a:Software system used to create, maintain, and provide controlled access to a databaseHardware system used to create, maintain, and provide controlled access to a databaseHardware system used to create, maintain, and provide uncontrolled access to a databaseSoftware system used to create, maintain, and provide uncontrolled access to a database
- 5. Multiple ChoiceA database application can perform which of the following activities?Add recordsDisplay / read recordsUpdate recordsAll of the above
- 6. Multiple ChoiceData administrator are responsible for ________Overall management of data resources in an organizationPhysical data designManaging technical issues in the database environmentWriting application program
- 7. Multiple ChoiceSome advantages of the database approach include all, but:Minimal data redundancyProgram-data dependencyImproved data consistencyImproved data sharing
- 8. Multiple ChoiceA relational database consists of a collection ofFieldRecordTableKeys
- 9. Multiple ChoiceA_______ in a table represents a relationship among a set of valuesFieldForeign keyRecordPrimary key
- 10. Multiple ChoiceThe term attribute refers to a ________ of a tableRecordForeign keyPrimary keyField
- 11. Multiple ChoiceThe term _______ is used to refer a rowRecordForeign keyPrimary keyField
- 12. Multiple ChoiceConsider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?NAMEIDCITYID, NAME
- 13. Multiple ChoiceWhich one of the following should be taken as a primary key?NameDepartmentIDDepartmentStreet
- 14. Multiple Choicewhich one of the following cannot be taken as a primary key?IDRegistrationNoDepartmentIDStreet
- 15. Multiple ChoiceA attribute in a relation is a foreign key if the _____ from one relation is used as an attribute in that relation.RecordForeign keyPrimary keyField
- 16. Multiple ChoiceWhich of the following gives a logical structure of the database graphically?Entity--relationship diagramEntity diagramDatabase diagramArchitectural representation
- 17. Multiple ChoiceThe entity relationship set is represented in E-R diagram asDouble diamondsUndivided rectanglesDashed linesDiamond
- 18. Multiple ChoiceThe rectangles divided into two parts representsEntity setRelationship setAttributes of a relationship setPrimary key
- 19. Multiple ChoiceIf you were collecting and storing information about your music collection, an album would be considered a(n) _____.RelationEntityInstanceAttribute
- 20. Multiple ChoiceThe records of a table can be of ________ order.AnySameSortedConstant
- Answer choicesTagsAnswer choicesTags