Have an account?
Skip to Content
Build your own quiz
18 questions
Show Answers
See Preview
- 1. Multiple ChoiceWhat is database?Collection of organized data that allows access, retrieval of that data.Collection of organized data that allows access, retrieval, and use of that data.Collection of organized data that allows retrieval, and use of that data.
- 2. Multiple ChoiceWhy we need database?To store a particular pictureTo store a particular textTo store a particular collection of data.To store a particular audio
- 3. Multiple ChoiceWhich is the example of File Based System?Using MySQL to find specific dataUsing MS Access to control users accessUsing spreadsheet software to manage data of employeeUsing OpenOffice.org Base to create new table
- 4. Multiple ChoiceWhy File Based System become unpopular?It causes sync with all the data synchronizationIt causes data redundancy
- 5. Multiple ChoiceWhat is Database Management System?A software system that enables users to access to the database.A software system that enables users to create access to the database.A software system that enables users to define, create, maintain and control access to the database.A software system that enables users to maintain and control access to the database.
- 6. Multiple ChoiceWhich of the following is NOT Advantages of DBMSIncreased data consistencyReduced data redundancyImproved data securityIncrease data isolation
- 7. Multiple ChoiceWhich of the following is the disadvantages of DBMS?Cost of setup of DBMS is relatively cheapDatabase systems are complexDatabase will not be corruptedDatabase systems are fast to be designed
- 8. Multiple ChoiceWhich type of application should you use if you need to store a large quantity of data in an organized format that you can easily query?DatabasePresentationSpreadsheetWord Processor
- 9. Multiple Choice
Logically related data consists of these EXCEPT
attributes
relationships
entities
variables
- 10. Multiple Choice
Data Definition Language is used to _______ the DBMS.
create
define
control access
manage
- 11. Multiple Choice
Data Manipulation Language is used to _______ the DBMS.
create
define
control access
manage
- 12. Multiple Choice
_____ is the bridge between machine and human in a DBMS environment
People
Hardware
Software
Data
Procedure
- 13. Multiple Choice
_______ decides how the logical DB design is to be physically realised
Data Administrator (DA)
Database Administrator (DBA)
Database Designers (Logical & Physical)
Application Programmers
- 14. Multiple Choice
Using different file organization should not require change to conceptual or external schemas.
This is referring to
Logical Data Independence
Physical Data Independence
Conceptual Data Independence
User Data Independence
- 15. Multiple Choice
_______ is responsible for the management of the data resource.
Data Administrator (DA)
Database Administrator (DBA)
Database Designers (Logical & Physical)
Application Programmers
- 16. Multiple Choice
_______ is responsible for the maintenance of operational control.
Data Administrator (DA)
Database Administrator (DBA)
Database Designers (Logical & Physical)
Application Programmers
- 17. Multiple Choice
_______ builds the application programs that provide the required functionality for the end-users.
Data Administrator (DA)
Database Administrator (DBA)
Database Designers (Logical & Physical)
Application Programmers
- 18. Multiple Choice
For the ANSI-SPARC Three-Level Architecture, ________ is the community view of the database.
External Level
Conceptual Level
Internal Level
- Answer choicesTagsAnswer choicesTags